Ora-01113: file 2 requires media recovery
Corrupted file or missing date file:
Operation flow
1 、 shutdown immediate
2 、 startup mount
3. Recover datafile'd:\'
4 、 alter database open
C:\ Documents and Settings\ Administrator > sqlplus / nolog
SQL*Plus: Release 10.2.0.1.0-Production on Wednesday May 29 11:38:24 2019
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL > conn / as sysdba
Connected.
SQL > shutdown immediate
ORA-01109: the database is not open
The database has been uninstalled.
The ORACLE routine has been closed.
SQL > startup mount
The ORACLE routine has been started.
Total System Global Area 1.7834E+10 bytes
Fixed Size 2232320 bytes
Variable Size 961114112 bytes
Database Buffers 1.6861E+10 bytes
Redo Buffers 9732096 bytes
The database is loaded.
SQL > recover datafile'd:\'
ORA-01179: file d:\ does not exist
SQL > recover datafile'D:\ oracle\ product\ 10.2.0\ oradata\ orcl\ UNDOTBS01.DBF'
Complete the media recovery.
SQL > alter database open
Alter database open
*
An error occurred on line 1:
ORA-01113: file 4 requires media recovery
ORA-01110: data file 4: d:\ ORACLE\ PRODUCT\ 10.2.0\ ORADATA\ ORCL\ USERS01.DBF'
SQL > recover datafile'D:\ ORACLE\ PRODUCT\ 10.2.0\ ORADATA\ ORCL\ USERS01.DBF'
Complete the media recovery.
SQL > alter database open
Alter database open
*
An error occurred on line 1:
ORA-01113: file 5 requires media recovery
ORA-01110: data file 5: d:\ ORACLE\ PRODUCT\ 10.2.0\ ORADATA\ ORCL\ EXAMPLE01.DBF'
SQL > recover datafile'D:\ ORACLE\ PRODUCT\ 10.2.0\ ORADATA\ ORCL\ EXAMPLE01.DBF'
Complete the media recovery.
SQL > alter database open
The database has changed.
SQL > exit
From Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-64bit Production
With the Partitioning, OLAP and Data Mining options disconnected
C:\ Documents and Settings\ Administrator > sqlplus
SQL*Plus: Release 10.2.0.1.0-Production on Wednesday May 29 11:42:35 2019
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Please enter a user name: ecology
Enter the password:
Connect to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-64bit Production
With the Partitioning, OLAP and Data Mining options
SQL >