ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS
would get error below



ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below..

Answer / guest

Cause: Media recovery with one of the incomplete recovery
options ended without error. However, if the ALTER DATABASE
OPEN RESETLOGS command were attempted now, it would fail
with the specified error. The most likely cause of this
error is forgetting to restore one or more datafiles from a
sufficiently old backup before executing the incomplete
recovery.

Action: Rerun the incomplete media recovery using different
datafile backups, a different controlfile, or different stop
criteria.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-16813: apply service not running on the apply instance string recorded by the broker

1 Answers  


ORA-16091: dependent archive log destination already archived

1 Answers  


ORA-23606: invalid object string

1 Answers  


ORA-16569: Data Guard configuration is not enabled.

1 Answers  


SQL*Loader-00946: OCI error while string for table string subpartition string

1 Answers  






ORA-37016: (XSACQUIRE01) You must specify objects to acquire for the ACQUIRE command.

1 Answers  


ORA-00108: failed to set up dispatcher to accept connection asynchronously

1 Answers  


SQL-02133: Unable to initialize process for use with threads

1 Answers  


TNS-12548: TNS:incomplete read or write

1 Answers  


RMAN-06431: recovery catalog created

1 Answers  


PROC-00026: Error while accessing the physical storage

1 Answers  


ORA-33452: (ESDREAD06) Discarding compiled code for workspace object because number is now dimensioned by workspace object. It was dimensioned by workspace object when the code was compiled.

1 Answers  


Categories