windows2008上的数据库版本为11.2.0.4.0,数据库打开为mount状态。报错如下:
SQL> startup
ORACLE instance started.
Total System Global Area 1610612736 bytes
Fixed Size 779080 bytes
Variable Size 535043256 bytes
Database Buffers 1073741824 bytes
Redo Buffers 1048576 bytes
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'c:\app\administrator\oradata\orcl\system01.dbf'
解决方法:
SQL> RECOVER DATAFILE 'c:\app\administrator\oradata\orcl\system01.dbf'
Media recovery complete.
SQL> recover tablespace system;
Media recovery complete.
SQL> RECOVER DATABASE;
Media recovery complete.
SQL> ALTER DATABASE OPEN;
Database altered.