Database Recovery - Change Based

[ramji_1123]

Hi guys

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

regards

ramji

[jmodic]

Restart your recovery process from the beggining, this time by firstly restoring files from sufficiently old backup.

[chao_ping]

hi,
Since you are doing incomplete recovery, did you restored all the datafiles?

[ramji_1123]

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.

regards

ramji

[SANJAY_G]

The backup datafile you are restoring must be older than CHANGE 30333.

Sanjay