Database Backup and Recovery (MOSC)

MOSC Banner

ORA-01152: file 1 was not restored from a sufficiently old backup

edited Oct 19, 2013 7:11AM in Database Backup and Recovery (MOSC) 4 commentsAnswered
I have just backed up a db and I am trying to restore it on another servers with different SID.I have started nomount the db with pfile,restored controlfile,mounted the db but when I recover the db as below error below appears.From list backup in RMAN latest scn is 2668073 but I want to restore till scn 2668333 incomplete recovery
ORA-01152: file 1 was not restored from a sufficiently old backup


RMAN> 2> {
3> set newname for datafile '+DATA/dc/datafile/system.284.828223243' to '+DATA/test/datafile/system.284.828223243';
set newname for datafile '+DATA/dc/datafile/sysaux.292.828223243' to '+DATA/test/datafile/sysaux.292.828223243';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center