ORA-01152 file string was not restored from a sufficiently old backup
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-01152 from Oracle 10g ?
An incomplete recovery session was started, but an insufficient number of logs were applied to make the database consistent. This file is still in the future of the last log applied. The most likely cause of this error is forgetting to restore the file from a backup before doing incomplete recovery.
How to deal with ORA-01152 from Oracle 10g ?
Either apply more logs until the database is consistent or restore the database file from an older backup and repeat recovery.
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-01144 File size ( string blocks) exceeds maximum of string blocks
- ORA-01145 offline immediate disallowed unless media recovery enabled
- ORA-01146 cannot start online backup - file string is already in backup
- ORA-01147 SYSTEM tablespace file string is offline
- ORA-01149 cannot shutdown - file string has online backup set
- ORA-01150 cannot prevent writes - file string has online backup set
- ORA-01151 use media recovery to recover block, restore backup if needed
- ORA-01153 an incompatible media recovery is active
- ORA-01154 database busy. Open, close, mount, and dismount not allowed now
- ORA-01155 the database is being opened, closed, mounted or dismounted
- ORA-01156 recovery in progress may need access to files
- ORA-01157 cannot identify/lock data file string - see DBWR trace file
- ORA-01158 database string already mounted
- ORA-01159 file is not from same database as previous files - wrong database id
- ORA-01160 file is not a string