归档问题
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
