ORA-01113: file string needs media recovery

I got ” ORA-01113: file string needs media recovery”  error in Oracle database.

ORA-01113: file string needs media recovery

Details of error are as follows.

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.

SQL> alter database open; 
alter database open
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '+DATA/MSDB/ONLINELOG/system01.dbf'

file string needs media recovery

This ORA-01113 error is related with the attempt was made to online or open a database with a file that is in need of media recovery.

If you got ORA-01110: data file 1: ‘+DATA/MSDB/ONLINELOG/system01.dbf’ errors, then run the recover database until cancel again as follows.

SQL> recover database until cancel;
ORA-00279: change 696770 generated at 29/04/2020 11:23:13 needed for thread 1
ORA-00289: suggestion :
+DATA/MSDB/ARCHIVELOG/archivelog/2020_04_30/o1_mf_1_2_%u_.arc
ORA-00280: change 696770 for thread 1 is in sequence #2


Specify log: {=suggested | filename | AUTO | CANCEL}
cancel
Media recovery cancelled.

Now Media recovery is done, we can open database in resetlogs mode as follows.

SQL> alter database open resetlogs;

Database altered.

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )