FIX RMAN-11001 ORA-01547 "warning: RECOVER succeeded but OPEN RESETLOGS would get error below"

advertisements

_____________________________________________________________________________________________________________________

The Eucharistic Miracles of the World
Error Description:
Open resetlogs fails with 01152, 00000, "file %s was not restored from a sufficiently old backup "

Solution Description:
It looks like the datafiles are not consistent state. The datafiles must be in consistent state after the recovery to open the database in open resetlogs.

You have to reexecute the script using a longer recovery with ‘set until’ clause.

Make sure the log sequence you specified in set until clause is at least one grater thatn the last one created after the database backup completes. In this case RMAN takes upto the required sequence and this will make the consistency for the recovery.

_____________________________________________________________________________________________________________________

A visitor from Dennery viewed 'How to Check User Quota on Oracle Tablespace - DBA' 11 mins ago
A visitor from Marinilla viewed 'OS error in starting service OracleMTSRecoveryServ' 1 hr 1 min ago
A visitor from Arroio do sal viewed 'How to Force Oracle RMAN to Delete All Archive log' 1 hr 5 mins ago
A visitor from Medellin viewed 'Find / Check Hot/Frequently Accessed Objects in Or' 1 hr 31 mins ago
A visitor from Seattle viewed 'ERROR: OMS_HOST cannot be null. Pass OMS_HOST valu' 1 hr 49 mins ago

0 comments:

Post a Comment

Labels

Oracle (629) Script (86) General (77) Unix (47) Blog (23) Technology (19) gadget (6) games (6) Business (3) OCI (3) SQL* Loader (3) Datapump (2)
 

acehints.com Copyright 2011-23 All Rights Reserved | Site Map | Contact | Disclaimer