错误信息:
ORA-00376:file xx cannot be read at this time
ORA-01110:data file xx:'/?/?.dbf'
问题诊断:tablespace被损坏
解决方法:
--检查datafile是否是online状态
select *
from dba_data_files;
--如果online_status=recover,则
recover datafile '/?/?.dbf';
--然后
alter database datafile '/?/?.dbf' online;
--检查undo表空间的online_status状态值,如果online_status=recover,则
recover datafile '/?/undotbs201.dbf';
--然后
alter database datafile '/?/undotbs201.dbf' online;
ORA-00376:file xx cannot be read at this time
ORA-01110:data file xx:'/?/?.dbf'
问题诊断:tablespace被损坏
解决方法:
--检查datafile是否是online状态
select *
from dba_data_files;
--如果online_status=recover,则
recover datafile '/?/?.dbf';
--然后
alter database datafile '/?/?.dbf' online;
--检查undo表空间的online_status状态值,如果online_status=recover,则
recover datafile '/?/undotbs201.dbf';
--然后
alter database datafile '/?/undotbs201.dbf' online;