1 | 问题: SQL> alter database open; alter database open * ERROR at line 1: ORA-01113: file 6 needs media recovery ORA-01110: data file 6: '/u01/app/oracle/oradata/ts_042_16_5.dbf'
|
2 | 解决办法 首先将对应报错的数据文件脱机 SQL> alter database datafile '/u01/app/oracle/oradata/ts_042_16_5.dbf' offline;
Database altered.
其次recover这个数据文件 SQL> alter database recover datafile '/u01/app/oracle/oradata/ts_042_16_5.dbf';
Database altered.
然后将该数据文件联机上线 SQL> alter database datafile '/u01/app/oracle/oradata/ts_042_16_5.dbf' online;
Database altered.
|
3 | 验证: SQL> alter database open;
Database altered. SQL> alter tablespace ts_042_16_5 online;---------------将该表空间ts_042_16_5联机上线。
Tablespace altered. SQL> select file#,status from v$datafile;
FILE# STATUS ---------- ------- 1 SYSTEM 2 ONLINE 3 ONLINE 4 ONLINE 5 ONLINE 6 ONLINE |
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30606702/viewspace-2074887/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30606702/viewspace-2074887/