ORA-01547 warning: RECOVER succeeded but OPEN RESETLOGS would get error below
This is an Oracle Database Server Message. This can be generated by the Oracle Database when running any Oracle program.
What is the cause of ORA-01547 from Oracle 10g ?
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 deal with ORA-01547 from Oracle 10g ?
Rerun the incomplete media recovery using different datafile backups, a different controlfile, or different stop criteria.
Contacting Oracle support services ?
Some messages recommend contacting Oracle Support Services to report a problem. Please go here for more information : Oracle Support.
Linked Error Messages
- ORA-01539 tablespace ' string ' is not online
- ORA-01540 tablespace ' string ' is not offline
- ORA-01541 system tablespace cannot be brought offline; shut down if necessary
- ORA-01542 tablespace ' string ' is offline, cannot allocate space in it
- ORA-01543 tablespace ' string ' already exists
- ORA-01544 cannot drop system rollback segment
- ORA-01545 rollback segment ' string ' specified not available
- ORA-01546 tablespace contains active rollback segment ' string '
- ORA-01548 active rollback segment ' string ' found, terminate dropping tablespace
- ORA-01549 tablespace not empty, use INCLUDING CONTENTS option
- ORA-01550 cannot drop system tablespace
- ORA-01551 extended rollback segment, pinned blocks released
- ORA-01552 cannot use system rollback segment for non-system tablespace ' string '
- ORA-01553 MAXEXTENTS must be no smaller than the string extents currently allocated
- ORA-01554 out of transaction slots in transaction tables
- ORA-01555 snapshot too old: rollback segment number string with name " string " too small