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

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

Question Posted / guest

2 Answers
5974 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / guest

Cause: An incomplete recovery session was started, but an
insufficient number of logs were applied to make the
database consistent. This file is still in the future of the
last log applied. The most likely cause of this error is
forgetting to restore the file from a backup before doing
incomplete recovery.

Action: Either apply more logs until the database is
consistent or restore the database file from an older backup
and repeat recovery.

Please add more information about this Error

Is This Answer Correct ?

0 Yes

0 No

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

Answer / suhas d

Hello,

If we use a backup controlfile and do recovery, it is
mandatory to open the database with the RESETLOGS option
(incomplete or point in time recovery).

The Backup and Recovery Basics Oracle doc states this
clearly.

If this is an ARCHIVE mode database and controlfile was
backed up using RMAN 'BACKUP CURRENT CONTROLFILE' or such,
we can do incomplete recovery and open resetlogs.

SQL> recover database until cancel using backup controlfile;

Copy over as many archived logs from source to the local
(target) log_archive_dest folder (suggested) and give full
path directions in the above command.

Recovery can happen until you wish to. Type CANCEL when
done and open the database with resetlogs option.

Regards,
Suhas

Is This Answer Correct ?

0 Yes

0 No

Post New Answer