ORA-01113: File 1 requires media recovery

Two days ago, due to forced shutdown, data files in the database were damaged. One database cannot be started and the media needs to be restored. Follow the online method:

Login data: sqlplus "/as sysdba"

Disable data: shutdown immediate;

Then start the data: startup;

An error was reported during startup:

ORA-01113: File 1 requires media recovery

ORA-01110: Data File 1: 'd: \ ORADATA \ gjjj1_1.dmp'

Then shut down the database: shutdown immediate;

Enable the database: startup mount;

Then: recover datafile 'd: \ ORADATA \ gjjj1_1.dmp ';

I recovered a file and a file, that is to say, after I restored the file, I closed the database and restarted it. This was done for about 7 or 8 times. Later, I can restore all the database files at a time, so that I don't need to enable or close the database 7 or 8 times.

Two days ago, due to forced shutdown, data files in the database were damaged. One database cannot be started and the media needs to be restored. Follow the online method:

Login data: sqlplus "/as sysdba"

Disable data: shutdown immediate;

Then start the data: startup;

An error was reported during startup:

ORA-01113: File 1 requires media recovery

ORA-01110: Data File 1: 'd: \ ORADATA \ gjjj1_1.dmp'

Then shut down the database: shutdown immediate;

Enable the database: startup mount;

Then: recover datafile 'd: \ ORADATA \ gjjj1_1.dmp ';

I recovered a file and a file, that is to say, after I restored the file, I closed the database and restarted it. This was done for about 7 or 8 times. Later, I can restore all the database files at a time, so that I don't need to enable or close the database 7 or 8 times.