歸檔問題
2024-07-21 02:40:26
供稿：網友
Oracle6.1.6.3+AIX4.3.3 數據庫為OPS模式，雙節點
環境
sp_node1/#oslevel -r
4330-02
oracle參數
log_archive_start = true
log_archive_dest_1 = "location=/archive1/arch MANDATORY REOPEN"
log_archive_dest_2 = "location=/archive2/arch MANDATORY REOPEN"
log_archive_format = arch_%t_%s.arc
版本
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle8i EnterPRise Edition Release 8.1.6.3.0, 64 bit - ProdUCti
PL/SQL Release 8.1.6.3.0 - Production
CORE 8.1.6.0.0 Production
TNS for IBM/AIX RISC System/6000: Version 8.1.6.3.0 - Production
NLSRTL Version 3.4.0.0.0 - Production
SQL>
查看模式
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /archive2/arch
Oldest online log sequence 960
Next log sequence to archive 961
Current log sequence 961
SQL>
節點一歸檔情況
SQL> select status,fail_date,error,destination from v$archive_dest;
STATUS FAIL_DATE
--------- ---------
ERROR
-----------------------------------------------------------------
DESTINATION
---------------------------------------------------------------------------
-----
VALID
/archive1/arch
ERROR 08-OCT-04
ORA-19504: failed to create file ""
/archive2/arch
STATUS FAIL_DATE
--------- ---------
ERROR
-----------------------------------------------------------------
DESTINATION
---------------------------------------------------------------------------
-----
INACTIVE
INACTIVE
STATUS FAIL_DATE
--------- ---------
ERROR
-----------------------------------------------------------------
DESTINATION
---------------------------------------------------------------------------
-----
INACTIVE
節點二歸檔情況
SQL> select status,fail_date,error,destination from v$archive_dest;
STATUS FAIL_DATE
--------- ---------
ERROR
-----------------------------------------------------------------
DESTINATION
---------------------------------------------------------------------------
-----
VALID
/archive1/arch
VALID
/archive2/arch
STATUS FAIL_DATE
--------- ---------
ERROR
-----------------------------------------------------------------
DESTINATION
---------------------------------------------------------------------------
-----
INACTIVE
INACTIVE
STATUS FAIL_DATE
--------- ---------
ERROR
-----------------------------------------------------------------
DESTINATION
---------------------------------------------------------------------------
-----
INACTIVE
問題一：為何兩個實例里archive log list只顯示第二個目標路徑？
問題二：參數里有MANDATORY，為何第一個實例只歸檔成功第一個目標目錄也能繼續運行，而第二個實例更是希奇，有時只歸檔成功一個目錄也能繼續運行，有時確報錯不能運行，為何？
問題三：第二個實例中成功歸檔目錄中出現了第一個線程的歸檔日志
實例二的歸檔文件
-rw-r----- 1 oracle dba 16236544 Oct 08 10:47 arch_2_386.arc
-rw-r----- 1 oracle dba 115712 Oct 08 08:11 arch_1_959.arc
-rw-r----- 1 oracle dba 16777728 Oct 07 16:14 arch_2_385.arc
-rw-r----- 1 oracle dba 3845632 Oct 06 11:00 arch_2_384.arc
-rw-r----- 1 oracle dba 644608 Oct 06 05:33 arch_1_958.arc
-rw-r----- 1 oracle dba 2033664 Oct 06 05:33 arch_2_383.arc
-rw-r----- 1 oracle dba 16777728 Oct 06 02:44 arch_2_382.arc
并且arch_1_959.arc這個文件在第一個實例的歸檔目錄中也存在，只是時間不同，而arch_1_958.arc這個文件在第一個實例的歸檔目錄反而沒有，為何？
實例一的歸檔文件
-rw-r----- 1 oracle dba 16777728 Oct 08 08:11 arch_1_960.arc
-rw-r----- 1 oracle dba 115712 Oct 06 10:59 arch_1_959.arc
-rw-r----- 1 oracle dba 1181184 Jun 20 17:52 arch_1_855.arc
-rw-r----- 1 oracle dba 881152 Jun 18 14:35 arch_1_854.arc
-rw-r----- 1 oracle dba 3442176 Jun 16 16:28 arch_1_853.arc
-rw-r----- 1 oracle dba 898048 Jun 14 17:51 arch_1_852.arc
-rw-r----- 1 oracle dba 848896 Jun 12 15:19 arch_1_851.arc
-rw-r----- 1 oracle dba 1013760 Jun 10 15:16 arch_1_850.arc
-rw-r----- 1 oracle dba 918528 Jun 08 15:50 arch_1_849.arc
-rw-r----- 1 oracle dba 1007616 Jun 06 17:56 arch_1_848.arc
-rw-r----- 1 oracle dba 2203136 Jun 04 14:30 arch_1_847.arc
-rw-r----- 1 oracle dba 3304448 Jun 02 10:55 arch_1_846.arc
-rw-r----- 1 oracle dba 9686528 May 31 14:30 arch_1_845.arc
-rw-r----- 1 oracle dba 16777728 May 30 11:41 arch_1_844.arc
-rw-r----- 1 oracle dba 16777728 May 28 21:51 arch_1_843.arc
-rw-r----- 1 oracle dba 12576768 May 26 15:08 arch_1_842.arc
-rw-r----- 1 oracle dba 16777728 May 24 05:50 arch_1_841.arc
-rw-r----- 1 oracle dba 7873024 May 22 10:33 arch_1_840.arc
-rw-r----- 1 oracle dba 16777728 May 20 18:03 arch_1_839.arc
-rw-r----- 1 oracle dba 16777728 May 19 07:23 arch_1_838.arc
-rw-r----- 1 oracle dba 825856 May 17 20:51 arch_1_837.arc
-rw-r----- 1 oracle dba 11508736 May 17 19:30 arch_1_836.arc
