ORA-01113: file string needs media recovery tips
Oracle Error Tips by Donald BurlesonConsulting (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
string needs media recovery
An attempt was made to online or open a database with a file
that is in need of media recovery.
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
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.