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-06005: NETASY: dialogue file read failure

1 Answers  


EXP-00047: Missing tablespace name(s)

1 Answers  


CLSS-00100: configuration data access failed for key string

1 Answers  


ORA-23334: column string does not exist in table or column group

1 Answers  


ORA-01518: CREATE DATABASE must specify more than one log file

1 Answers  






ORA-24778: cannot open connections

1 Answers  


ORA-01639: instance string has no thread assigned to it

1 Answers  


DRG-50907: score threshold string outside valid range 1 to 100

1 Answers  


NCR-03013: NCRO: Operation not supportd

1 Answers  


QSM-01037: Query Rewrite failed to allocate the necessary query join graph

1 Answers  


ORA-12156: TNS:tried to reset line from incorrect state

1 Answers  


ORA-14168: only one subpartition may be modified

1 Answers  


Categories