I had attempted recovering the DB using Change based as follows
SQL> recover database until change 30333;
The following message appeared
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'E:\ORACLE\ORADATA\PNL\SYSTEM01.DBF'
how do i proceed from here
Restart your recovery process from the beggining, this time by firstly restoring files from sufficiently old backup.
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Since you are doing incomplete recovery, did you restored all the datafiles?
hi jmodic/ chao_ping
when i try RECOVER DATABASE; all the archive log (ARC 8,9,10) and online redo logs are applied and the database is brought to the latest position.
but, my requirement is to recover the DB until ARC 9 starting from the old backup.
The backup datafile you are restoring must be older than CHANGE 30333.
Click Here to Expand Forum to Full Width