Question:
I am performing a database recovery and
I get this ORA-01152 error:
SQL> alter database open
2 ;
alter
database open
*
ERROR at line 1:
ORA-16004: backup
database requires recovery
ORA-01152: file 1 was not restored
from a sufficiently old backup
ORA-01110: data file 1:
'+DATA/dprod/datafile/system01.dbf'
How do I get around this ORA-01152 error
and restore my database?
Answer:
We start by using the
oerr utility for information on the ORA-01152 error:
ORA-01152: file 1 was not restored from a
sufficiently old backup
Cause: 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.
Action: Either apply more logs until the database
is consistent or restore the database file from an older backup and
repeat recovery.
As you see, you need to take one of the following actions to
alleviate the ORA-01152 error:
- Continue to apply logs from your archived redo log
filesystem: Ensure that you are in
ARCHIVELOG mode and check your redo log file destination to
ensure that you have enough redo logs. If you are in
NOARCHIVELOG mode, the only way to get around the ORA-01152
error is to perform a full restore from your last cold backup,
losing any updates since the backup was taken. This will most
likely result in you getting fired for ineptitude.
- Restore from an older backup: If you restore from an
older backup the ORA-01152 error will not appear because Oracle
will be able to fully recover the database into a consistent
state.
Check
HERE for more information on the ORA-01152 error.
|
|
Get the Complete
Oracle SQL Tuning Information
The landmark book
"Advanced Oracle
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
buy it
for 30% off directly from the publisher.
|