CASE1:
测试场insert 操作时报错。
ORA-01110: data file 4: '/home/XXX/data/XXX_01.dbf'
。先查看了下DB状态,是OPEN。DF,看空间大小,也没满。从dba_data_files中找出这个DBF对应的TABLESPACE,去dba_tablespaces中看了下它的状态。为READ ONLY!
有点慌。。快速查看了所有的表空间哪些是READ ONLY的。有140个!
跑个脚本改过来。
set head off pages 0 lines 200 feedback off
SPOOL alter_tablespaces.sql
select 'ALTER TABLESPACE ' || tablespace_name || ' READ WRITE;'
from dba_tablespaces
where status='READ ONLY';
SPOOL off
@alter_tablespaces
------------------------------
SQL> shutdown immediate;
ORA-01116: error in opening database file 8
ORA-01110: data file 8: '/home/oracle/ad_test/t1.dbf'
ORA-27041: unable to open file
SQL> SELECT name, error FROM v$datafile JOIN v$r