Oracle database error code ORA-01547 – warning: RECOVER succeeded but OPEN RESETLOGS would get error below

Oracle Database Error Code ORA-1547 Description :
warning: RECOVER succeeded but OPEN RESETLOGS would get error below
Error 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.

How to Solve :
Rerun the incomplete media recovery using different datafile backups, a different control file, or different stop criteria.


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , , , ,
No Comment Yet   
«
»