问题说明:
数据库处于NOARCHIVELOG,用户daniel已连接,表空间USER使用的数据文件'/u01/app/oracle/oradata/orcl/users01.dbf' 被错误删除,该表空间中有一个表t1.
SQL> select * from t1;
select * from t1
*
ERROR at line 1:
ORA-00376: file 4 cannot be read at this time
ORA-01110: data file 4: '/u01/app/oracle/oradata/orcl/users01.dbf'
查看数据文件状态:
select name, status from v$datafile;
NAME
--------------------------------------------------------------------------------
STATUS
-------
/u01/app/oracle/oradata/orcl/users01.dbf
RECOVER
select * from v$recover_file;
FILE# ONLINE ONLINE_
---------- ------- -------
ERROR CHANGE#
----------------------------------------------------------------- ----------
TIME
---------
4 OFFLINE OFFLINE
558276
07-FEB-10
解决:
SQL> recover datafile '/u01/app/oracle/oradata/orcl/users01.dbf'
;Media recovery complete.
SQL> alter database datafile '/u01/app/oracle/oradata/orcl/users01.dbf' online;
Database altered.
SQL> select * from t1;
no rows selected
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22021749/viewspace-626997/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22021749/viewspace-626997/