fake recovery for open resetlogs
582889Jun 2 2008 — edited Jun 2 2008Hi
There is no problem in the database (oracle xe).
I want to perform fake recovery inorder to open resetlogs but I couldnt do that.
SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 209715200 bytes
Fixed Size 1286580 bytes
Variable Size 71306828 bytes
Database Buffers 134217728 bytes
Redo Buffers 2904064 bytes
Database mounted.
SQL> recover database until cancel;
ORA-00279: change 18634852803 generated at 06/02/2008 14:12:52 needed for
thread 1
ORA-00289: suggestion :
C:\ORACLE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ARCHIVELOG\2008_06_02\O1_MF_1_5
200_%U_.ARC
ORA-00280: change 18634852803 for thread 1 is in sequence #5200
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'C:\ORACLE\ORADATA\XE\SYSTEM.DBF'
ORA-01112: media recovery not started
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'C:\ORACLE\ORADATA\XE\SYSTEM.DBF'