alter database open ERROR at line 1: ORA-16004: backup database requires recovery ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: '/opt/ora10g/oradata/orcla/system01.dbf' 解决如下: 先sql>recover datafile '/opt/ora10g/oradata/orcla/system01.db...
SQL> alter database open; alter database open * ERROR at line 1: ORA-10458: standby database requires recovery ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: '/u01/app/oracle/oradata/orcl151/system01.dbf' 解决过程: 查看主库log_archive_config...
2. I elimated the file in logic way and then i recreated the controlfile 3. I executed ALTER DATABASE RECOVER and the result was: Media Recovery Log /export/home/users/oracle/app/oracle/product/8.1.7/dbs/arch1_899590.dbf
方法/步骤 1 首先shutdown immediate关闭数据库提示“ORA-01109: database not openDatabase dismounted.ORACLE instance shut down.”数据库已经处于关闭状态。2 startup启动数据库报错，提示“ORACLE instance started.Total System Global Area 1603411968 bytesFixed Size 2213776 bytesVariable Size 1426065520 ...
ORA-01110: data file 1: '< directory >/SGSDGB/data02/system01.dbf' 2.2 检查问题是否匹配 遇到有mos差不多的文档故障处理,啥也别说了,看看是不是匹配这个问题! Redo apply at standby site suddenly failed as shown in the alert.log: CAUSE ...
1. 6: Total System Global Area 1258291200 bytes 1. 7: Fixed Size 1267236 bytes 1. 8: Variable Size 822086108 bytes 1. 9: Database Buffers 419430400 bytes 1. 10: Redo Buffers 15507456 bytes 1. Step 4:恢复数据库控制文件。 1: RMAN> restore controlfile from '/u03/flash_recovery_area/EP...
2. I elimated the file in logic way and then i recreated the controlfile 3. I executed ALTER DATABASE RECOVER and the result was: Media Recovery Log /export/home/users/oracle/app/oracle/product/8.1.7/dbs/arch1_899590.dbf
hello gurus, I executed : 1 - backup full database; 2 - i try to restore this database by;
ORA-01110: data file 1:'/u01/APP/oracle/oradata/orcl151/system01.dbf' 查询资料,确认到异常原因为日志的scn与控制文件不一致,以下为处理步骤: 备库启动到mount状态: SQL> shutdown immediate; ORA-01109: database not open Database dismounted. ...
查看数据文件的状态,可以看到21号文件TEST_new_index04.dbf 目前是在RECOVER状态。jeanron@TEST> select file_name,status,online_status from dba_data_files; FILE_NAME STATUS ONLINE_ --- --- --- /U01/app/oracle/oradata/TEST/TE