兩個有趣的REDOLOGERROR處理方法

兩個有趣的REDOLOGERROR處理方法系統(tǒng)環(huán)境：操作系統(tǒng)：AIX-5300數(shù)據(jù)庫：Oracle10g(10.2.0.1.0)案例描述：數(shù)據(jù)庫(歸檔模式）非當前日志組被破壞，但由于破壞方式不

兩個有趣的REDO LOG ERROR處理方法

系統(tǒng)環(huán)境：

操作系統(tǒng)： AIX-5300

數(shù)據(jù)庫： Oracle 10g(10.2.0.1.0)

案例描述：

數(shù)據(jù)庫(歸檔模式）非當前日志組被破壞，但由于破壞方式不同，，在解決問題的方式稍有不同，很有意思.

案例1：非當前日志組文件被刪除

SQL> select member from v$logfile;

MEMBER

--------------------------------------------------------------------------------------------------------

/dsk1/oradata/prod/redo03a.log

/dsk1/oradata/prod/redo02a.log

/dsk1/oradata/prod/redo01a.log

/dsk2/oradata/prod/redo01b.log

/dsk2/oradata/prod/redo02b.log

/dsk2/oradata/prod/redo03b.log

6 rows selected.

刪除非當前日志組：

[oracle@aix211 ~]$cd /dsk1/oradata/prod/

[oracle@aix211 prod]$ls

control02.ctl redo01a.log redo02a.log redo03a.log

[oracle@aix211 prod]$rm redo01a.log

[oracle@aix211 prod]$cd /dsk2/oradata/prod/

[oracle@aix211 prod]$ls

redo01b.log redo02b.log redo03b.log

[oracle@aix211 prod]$rm redo01b.log

關(guān)閉數(shù)據(jù)庫，并重新啟動：

SQL> shutdown abort

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 1258291200 bytes

Fixed Size 2020552 bytes

Variable Size 318769976 bytes

Database Buffers 922746880 bytes

Redo Buffers 14753792 bytes

Database mounted.

ORA-00313: open failed for members of log group 1 of thread 1

ORA-00312: online log 1 thread 1: '/dsk1/oradata/prod/redo01a.log'

ORA-00312: online log 1 thread 1: '/dsk2/oradata/prod/redo01b.log'

告警日志：（提示：日志組文件找不到，無法讀取）

Errors in file /u01/app/oracle/admin/prod/udump/prod_ora_536600.trc:

ORA-00313: open failed for members of log group 1 of thread 1

ORA-00312: online log 1 thread 1: '/dsk2/oradata/prod/redo01b.log'

ORA-27037: unable to obtain file status

IBM AIX RISC System/6000 Error: 2: No such file or directory

Additional information: 3

ORA-00312: online log 1 thread 1: '/dsk1/oradata/prod/redo01a.log'

ORA-27037: unable to obtain file status

IBM AIX RISC System/6000 Error: 2: No such file or directory

Additional information: 3

Completed: alter database clear logfile group 1

Mon May 26 10:02:36 2014

alter database open

Mon May 26 10:02:36 2014

Block change tracking file is current.

解決方法：

SQL> select * from v$log;

GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM

---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------

1 1 452 52428800 2 YES INACTIVE 806225 26-MAY-14

3 1 451 52428800 2 YES INACTIVE 803970 26-MAY-14

2 1 453 52428800 2 NO CURRENT 806237 26-MAY-14

由于是非當前日志組，并且已經(jīng)完成歸檔：

SQL> alter database clear logfile group 1;

Database altered.

打開數(shù)據(jù)庫成功：

SQL> alter database open;

Database altered.

SQL> select * from v$log;

GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM

---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------

聲明：本網(wǎng)頁內(nèi)容旨在傳播知識，若有侵權(quán)等問題請及時與本網(wǎng)聯(lián)系，我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com