Node where RAC Archive log is written incorrectly

Node where RAC Archive log is written incorrectly

Multiple customers have asked several times that archive logs of node2 In the RAC environment are written to the archive path of node1.

This problem causes some customers to be unable to read logs correctly when using OGG.

What causes this problem?

Search for and test. If the following conditions are found, archive log does not record the correct node location.

Test Environment

Linux + 11.2.0.4 RAC

Node1

Alter system set log_archive_dest_1 = 'location =/home/Oracle/archive_log/valid_for = (all_logfiles, all_roles) 'sid = 'orcl1' scope = spfile;

Node2

Alter system set log_archive_dest_1 = 'location =/home/oracle/archive_log/valid_for = (all_logfiles, all_roles) 'sid = 'orcl2 'scope = spfile;

Case 1

When node2 instance is disabled, execute alter system archive log current on node1;

Writes the archive log of node2 to the path of node1.

----------- 10.2.0.5 test --------------

Note: nascds14 is node 1 and nascds15 is node 2.

[Oracle @ nascds14 ~] $ Ls-l/u01/app/database/dbs/
-Rw-r ----- 1 oracle oinstall 9897472 Dec 1 arch1_66_827742538.dbf
-Rw-r ----- 1 oracle oinstall 2048 Dec 1 arch1_67_827742538.dbf
-Rw-r ----- 1 oracle oinstall 1024 Dec 1 arch1_68_827742538.dbf
[Oracle @ nascds14 ~] $ Sqlplus/as sysdba
SQL> alter system archive log current;
System altered.
[Oracle @ nascds14 ~] $ Ls-l/u01/app/database/dbs/
-Rw-r ----- 1 oracle oinstall 9897472 Dec 1 arch1_66_827742538.dbf
-Rw-r ----- 1 oracle oinstall 2048 Dec 1 arch1_67_827742538.dbf
-Rw-r ----- 1 oracle oinstall 1024 Dec 1 arch1_68_827742538.dbf
-Rw-r ----- 1 oracle oinstall 11776 Dec 1 arch1_69_827742538.dbf
-Rw-r ----- 1 oracle oinstall 128512 Dec 1 arch2_101_827742538.dbf <node2 logs are generated on node1.
[Oracle @ nascds14 ~] $ Date
Mon Dec 1 09:56:01 CST 2014
$ Sqlplus/as sysdba
Connected:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0-Production
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
[Oracle @ nascds15 ~] $ Ls-l/u01/app/database/dbs/
-Rw-r ----- 1 oracle oinstall 6144 Dec 1 arch2_100_827742538.dbf
-Rw-r ----- 1 oracle oinstall 17412608 Dec 1 arch2_98_827742538.dbf
-Rw-r ----- 1 oracle oinstall 1536 Dec 1 arch2_99_827742538.dbf
[Oracle @ nascds15 ~] $ Ls-l/u01/app/database/dbs/
-Rw-r ----- 1 oracle oinstall 6144 Dec 1 arch2_100_827742538.dbf
-Rw-r ----- 1 oracle oinstall 17412608 Dec 1 arch2_98_827742538.dbf
-Rw-r ----- 1 oracle oinstall 1536 Dec 1 arch2_99_827742538.dbf

----------- 11.2.0.4 test --------------

Node2 instance closed, log generation result

When node2 instance is disabled, execute alter system archive log current on node1;

It also writes the archive log of node2 to the path of node1.

--- Node2 ---

SQL> create table test1 as select * from dba_users;

Create table test1 as select * from dba_users;

SQL> shutdown abort

Shutdown abort

ORACLE instance shut down.

--- Node1 ---

SQL> alter system archive log current;

--- Node1 ---

[Oracle @ node111g archive_log] $ ls-al 2 *

-Rw ------- 1 oracle asmadmin 148992 December 19 11:22 2_176_864642458.dbf

-Rw ------- 1 oracle asmadmin 1024 December 19 11:22 2_177_864642458.dbf <node2 logs are generated on node1.

--- Node2 ---

[Oracle @ node211g archive_log] $ ls-ctrl

-Rw ------- 1 oracle asmadmin 1024 December 19 10:44 2_173_864642458.dbf

-Rw ------- 1 oracle asmadmin 1872896 December 19 11:18 2_174_864642458.dbf

-Rw ------- 1 oracle asmadmin 15360 December 19 11:18 2_175_864642458.dbf

The following are the test results and four windows are enabled at the same time.

For more details, please continue to read the highlights on the next page:

1 2 Next Page