SQL> startup
mountoracle instance started.
total System Global Area 57124108 bytes
Fixed Size 70924 bytes
VARiable Size 40198144 bytes
Database Buffers 16
777216 bytes
redo Buffers 77824 bytes
Database mounted.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'F:ORACLEORADATALHGSYSTEM01.DBF'
[sql]
SQL> select file_n
ame from dba_data_files;
www.js-code
.COM FILE_NAME
------------------------------------------------------------------------------------------------------------------------------------------------------
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_users_8050fkdh_.dbf
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_8050fk3w_.dbf
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_8050fkc6_.dbf
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_8050fk2z_.dbf
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_example_8050jhm7_.dbf
于控制文件:
[sql]
SQL> select name from v$controlfile;
NAME
------------------------------------------------------------------------------------------------------------------------------------------------------
/u01/app/oracle/oradata/ORCL/controlfile/o1_mf_8050hgfp_.ctl
/u01/app/oracle/flash_recovery_area/ORCL/controlfile/o1_mf_8050hgqh_.ctl
于日志文件:
[ht
ML]
SQL> select member from v$logfile;
MEMBER
------------------------------------------------------------------------------------------------------------------------------------------------------
/u01/app/oracle/oradata/ORCL/onlinelog/o1_mf_3_8050hq4s_.log
/u01/app/oracle/flash_recovery_area/ORCL/onlinelog/o1_mf_3_8050hs2h_.log
/u01/app/oracle/oradata/ORCL/onlinelog/o1_mf_2_8050hm84_.log
/u01/app/oracle/flash_recovery_area/ORCL/onlinelog/o1_mf_2_8050ho5o_.log
/u01/app/oracle/oradata/ORCL/onlinelog/o1_mf_1_8050hh
n1_.log
/u01/app/oracle/flash_recovery_area/ORCL/onlinelog/o1_mf_1_8050hkdv_.log