oracle data guard 備庫出現錯誤
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE cancel
alter database open read only
Fri Nov 09 10:08:37 2018
Read of datafile '/ORA/db/oradata/TX/temp01.dbf' (fno 201) header failed with ORA-01203
Rereading datafile 201 header failed with ORA-01203
Errors in file /ORA/db/diag/rdbms/lg_st/TX/trace/LG_dbw0_450588.trc:
ORA-01186: file 201 failed verification tests
ORA-01122: database file 201 failed verification check
ORA-01110: data file 201: '/ORA/db/oradata/TX/temp01.dbf'
ORA-01203: wrong incarnation of this file - wrong creation SCN
File 201 not verified due to error ORA-01122
Fri Nov 09 10:08:37 2018
執行
select s.name tbsname,t.name,(t.bytes/1024/1024) bytes,status
from v$tablespace s,v$tempfile t
where s.ts# = t.ts#;
出現 ORA-01122 及 ORA-01110 錯誤
這是tmep 文件 失效
解決方是 新增一個datafile 並且砍掉原本
SQL> alter tablespace temp add tempfile '/ORA/db/oradata/TX/temp01_01.dbf' size 100m autoextend on;
Tablespace altered.
SQL> alter tablespace temp drop tempfile '/ORA/db/oradata/TX/temp01.dbf';
Tablespace altered.
SQL>
SQL>
解決完成
執行
select s.name tbsname,t.name,(t.bytes/1024/1024) bytes,status
from v$tablespace s,v$tempfile t
where s.ts# = t.ts#;
出現 新增的 datafile
alert.log 內容
Fri Nov 09 10:26:34 2018
alter tablespace temp add tempfile '/ORA/db/oradata/TX/temp01_01.dbf' size 100m autoextend on
Completed: alter tablespace temp add tempfile '/ORA/db/oradata/TX/temp01_01.dbf' size 100m autoextend on
Fri Nov 09 10:27:21 2018
alter tablespace temp drop tempfile '/ORA/db/oradata/TX/temp01.dbf'
Errors in file /ORA/db/diag/rdbms/lg_st/TX/trace/LG_ora_451105.trc:
ORA-01122: database file 201 failed verification check
ORA-01110: data file 201: '/ORA/db/oradata/TX/temp01.dbf'
ORA-01203: wrong incarnation of this file - wrong creation SCN
Errors in file /ORA/db/diag/rdbms/lg_st/TX/trace/LG_ora_451105.trc:
ORA-01258: unable to delete temporary file /ORA/db/oradata/TX/temp01.dbf
Completed: alter tablespace temp drop tempfile '/ORA/db/oradata/TX/temp01.dbf'
回覆刪除alter database tempfile '/ORA/db/oradata/LG/temp01.dbf' drop including datafiles;
alter tablespace temp add tempfile '/ORA/db/oradata/LG/temp01.dbf' size 100M reuse;