 |
|
ORA-01113: file string needs media recovery tips
Oracle Error Tips by Burleson Consulting (S. Karam)
|
Question: I get this error when starting my Oracle
database. What is the ORA-01113 error?
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'F:\DB\SYSTEM01.DBF'
Answer: You should be able to begin Oracle normally after ORA-01113 has been
resolved within the database. The Oracle docs note this on the
ORA-01113 error:
-
ORA-01113: file
string needs media recovery
-
Cause:
An attempt was made to online or open a database with a file
that is in need of media recovery.
-
Action:
First apply media recovery to the file.
The ORA-01113 error can be thrown when you begin to start Oracle
with the "startup" command. The ORA-01113 has many causes:
-
Bad RMAN cloning
-
True file in need of recovery condition
After conforming that the file is need need
of recovery, consider issuing the recover datafile '<datafile-name>'
command to apply the archived redo
logs.
As a note, if you are using a standby database, many people often make
the mistake of using a hot backup, while forgetting to issue an 'alter
tablespace...begin backup...end backup' under tablespace.
