D:\ORADATA\ORCL\TEST03.DBF ONLINE YES NAME---STATUS FUZ--- ---D:\ORADATA\ORCL\GULL01.DBF ONLINE YES 已选择7行。 SQL>alterdatabaseopen;alterdatabaseopen*第1行出现错误: ORA-01113: 文件6需要介质恢复 ORA-01110: 数据文件6:'D:\ORADATA\ORCL\TEST03.DBF'SQL>alterdatabasedatafile6endbackup...
照样需要介质恢复datafile4,5才可以启动。 sys@CISCOSYS>alterdatabaseopen;alterdatabaseopen*ERROR at line1: ORA-01113:file5needs media recovery ORA-01110:datafile5:'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\ST' 1. 2. 3. 4. 5. 6.
ORA-01113: file 6 needs media recovery ORA-01110: data file 6: '/u02/oradata/orcl/zydl.dbf' 就应该直接执行 SQL> recover datafile '/u02/oradata/orcl/zydl.dbf'; Media recovery complete. SQL> alter database open; Database altered. 即可打开数据库 如果是startup启动数据哭的时候遇到 类似nee...
SQL> alter database datafile '/u01/app/oracle/oradata/orcl/test01.dbf' online; alter database datafile '/u01/app/oracle/oradata/orcl/test01.dbf' online * ERROR at line 1: ORA-01113: file 2 needs media recovery ORA-01110: data file 2: '/u01/app/oracle/oradata/orcl/test01.dbf' SQ...
alter database datafile '/u01/app/oracle/oradata/orcl/test01.dbf' online * ERROR at line 1: ORA-01113: file 2 needs media recovery ORA-01110: data file 2: '/u01/app/oracle/oradata/orcl/test01.dbf' SQL> recover datafile '/u01/app/oracle/oradata/orcl/test01.dbf'; ...