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.
|
|
 |
|
Guarantee your Success!
Oracle is the
world's most complex, robust and flexible database, considered
impossible to master without a mentor.
That's why all BC
Oracle trainers are working professionals, experts in Oracle who
share their tips and secrets. |
|
| |
|
Burleson is the American Team
Note:
This Oracle
documentation was created as a support and Oracle training reference for use by our
DBA performance tuning consulting professionals.
Feel free to ask questions on our
Oracle forum.
Verify
experience!
Anyone
considering using the services of an Oracle support expert should
independently investigate their credentials and experience, and not rely on
advertisements and self-proclaimed expertise. All legitimate Oracle experts
publish
their Oracle
qualifications.
Errata?
Oracle technology is changing and we
strive to update our BC Oracle support information. If you find an error
or have a suggestion for improving our content, we would appreciate your
feedback. Just
e-mail:
 and include the URL for the page.
Copyright ? 1996 - 2012
All rights reserved.
Oracle ?
is the registered trademark of Oracle Corporation.
|
|
