Test Case Overview

Test Case Steps

Test Case Summary

 

Test Case Overview

The current solution designed and deployed three separate environments:

  • A production 2-node Oracle RAC prdrac comprising RAC VMs prdrac01 and prdrac02
  • A production Oracle Far Sync prdfs with VM prdfs
  • A disaster recovery 2-node Oracle RAC prddg comprising RAC VMs prddg01 and prddg02

The test case is to validate the functionality of the on-premises production Oracle RAC, Oracle Far Sync, and Oracle Data Guard RAC setup

  • Switch online redo log files on the production RAC prdrac
  • Generate and send redo to the Oracle Far Sync prdfs synchronously
  • Oracle Far Sync prdfs in turn sends the redo to the DR RAC prddg asynchronously
     

Test Case Steps

 

1.  On production RAC cluster prdrac, switch log files a couple of times to generate archive log files:

 

oracle@prdrac01:prdrac01:/home/oracle> sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Thu Aug 2 23:28:16 2018

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL>

 

SQL> archive log list

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence     115

Next log sequence to archive   122

Current log sequence           122

SQL>

 

SQL> alter system switch logfile;

System altered.

SQL> alter system switch logfile;

System altered.

SQL> alter system switch logfile;

System altered.

 

SQL> archive log list

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence     118

Next log sequence to archive   125

Current log sequence           125

SQL>

 

2. Check the prdrac01 alert log file to see if thread1 has been advanced to log sequence 125.

oracle@prdrac01:prdrac01:/u01/admin/prdrac01/diag/rdbms/prdrac/prdrac01/trace> tail -1000 alert_prdrac01.log

...

2018-08-02T23:31:51.067725-07:00

Thread 1 advanced to log sequence 122 (LGWR switch)

  Current log# 2 seq# 122 mem# 0: +REDO_DG/prdrac/group02_redo01.log

  Current log# 2 seq# 122 mem# 1: +REDO_DG/prdrac/group02_redo02.log

2018-08-02T23:31:51.599632-07:00

Archived Log entry 278 added for T-1.S-121 ID 0x473cae16 LAD:1

2018-08-02T23:41:22.801940-07:00

LGWR: Standby redo logfile selected for thread 1 sequence 123 for destination LOG_ARCHIVE_DEST_2

2018-08-02T23:41:22.829973-07:00

Thread 1 advanced to log sequence 123 (LGWR switch)

  Current log# 3 seq# 123 mem# 0: +REDO_DG/prdrac/group03_redo01.log

  Current log# 3 seq# 123 mem# 1: +REDO_DG/prdrac/group03_redo02.log

2018-08-02T23:41:22.876590-07:00

Archived Log entry 280 added for T-1.S-122 ID 0x473cae16 LAD:1

2018-08-02T23:41:24.185547-07:00

LGWR: Standby redo logfile selected for thread 1 sequence 124 for destination LOG_ARCHIVE_DEST_2

2018-08-02T23:41:24.214406-07:00

Thread 1 advanced to log sequence 124 (LGWR switch)

  Current log# 4 seq# 124 mem# 0: +REDO_DG/prdrac/group04_redo01.log

  Current log# 4 seq# 124 mem# 1: +REDO_DG/prdrac/group04_redo02.log

2018-08-02T23:41:24.246212-07:00

Archived Log entry 282 added for T-1.S-123 ID 0x473cae16 LAD:1

2018-08-02T23:41:25.770813-07:00

LGWR: Standby redo logfile selected for thread 1 sequence 125 for destination LOG_ARCHIVE_DEST_2

2018-08-02T23:41:25.832979-07:00

Thread 1 advanced to log sequence 125 (LGWR switch)

  Current log# 5 seq# 125 mem# 0: +REDO_DG/prdrac/group05_redo01.log

  Current log# 5 seq# 125 mem# 1: +REDO_DG/prdrac/group05_redo02.log

2018-08-02T23:41:25.899474-07:00

Archived Log entry 285 added for T-1.S-124 ID 0x473cae16 LAD:1

oracle@prdrac01:prdrac01:/u01/admin/prdrac01/diag/rdbms/prdrac/prdrac01/trace>

 

 

3. On production far sync prdfs, check the alert log file to see if the log sequence 125 reached far sync.

 

oracle@prdfs:prdfs:/home/oracle> sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Thu Aug 2 23:44:26 2018

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL>

 

SQL> select process, client_process, sequence#, status from v$managed_standby;

PROCESS   CLIENT_P  SEQUENCE# STATUS

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

DGRD      N/A               0 ALLOCATED

ARCH      ARCH            123 CLOSING

DGRD      N/A               0 ALLOCATED

ARCH      ARCH             53 CLOSING

ARCH      ARCH            124 CLOSING

ARCH      ARCH            122 CLOSING

RFS       Archival          0 IDLE

RFS       LGWR            125 IDLE

RFS       UNKNOWN           0 IDLE

RFS       UNKNOWN           0 IDLE

RFS       Archival          0 IDLE

RFS       UNKNOWN           0 IDLE

LNS       LNS             125 WRITING

RFS       UNKNOWN           0 IDLE

LNS       LNS              54 WRITING

RFS       LGWR             54 IDLE

RFS       UNKNOWN           0 IDLE

DGRD      N/A               0 ALLOCATED

18 rows selected.

SQL>

 

oracle@prdfs:prdfs:/u01/admin/prdfs/diag/rdbms/prdfs/prdfs/trace> tail -f alert_prdfs.log

2018-08-02T23:41:25.484659-07:00

RFS[18]: Selected log 17 for T-1.S-125 dbid 1195133974 branch 980770134

2018-08-02T23:41:25.488938-07:00

TT04: Standby redo logfile selected for thread 2 sequence 54 for destination LOG_ARCHIVE_DEST_2

2018-08-02T23:41:25.542534-07:00

Archived Log entry 226 added for T-1.S-124 ID 0x473cae16 LAD:1

2018-08-02T23:41:25.615574-07:00

TT02: Standby redo logfile selected for thread 1 sequence 125 for destination LOG_ARCHIVE_DEST_2

2018-08-02T23:41:25.638263-07:00

Archived Log entry 227 added for T-2.S-53 ID 0x473cae16 LAD:1

oracle@prdfs:prdfs:/u01/admin/prdfs/diag/rdbms/prdfs/prdfs/trace>

 

 

 

4. On DR RAC prddg, check for any archive gap.

 

oracle@prddg01:prddg01:/home/oracle> sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Thu Aug 2 23:35:08 2018

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL>

 

SQL> select process, client_process, sequence#, status from v$managed_standby;

PROCESS   CLIENT_P  SEQUENCE# STATUS

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

DGRD      N/A               0 ALLOCATED

ARCH      ARCH            118 CLOSING

DGRD      N/A               0 ALLOCATED

ARCH      ARCH             53 CLOSING

ARCH      ARCH            121 CLOSING

ARCH      ARCH            124 CLOSING

MRP0      N/A             125 APPLYING_LOG

RFS       Archival          0 IDLE

RFS       LGWR             54 IDLE

RFS       LGWR            125 IDLE

RFS       UNKNOWN           0 IDLE

RFS       UNKNOWN           0 IDLE

RFS       UNKNOWN           0 IDLE

13 rows selected.

SQL>

 

SQL> select thread#, max (sequence#) from v$log_history group by thread#;

   THREAD# MAX(SEQUENCE#)

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

         1            124

         2             53

SQL>

 

SQL> select * from gv$archive_gap;

no rows selected

SQL>

 

5. Check the alert log file to see if log sequence 125 reached the physical standby database.

oracle@prddg01:prddg01:/u01/admin/prddg01/diag/rdbms/prddg/prddg01/trace> tail -100 alert_prddg01.log

...

Media Recovery Waiting for thread 2 sequence 54 (in transit)

2018-08-02T23:41:25.544827-07:00

Recovery of Online Redo Log: Thread 2 Group 27 Seq 54 Reading mem 0

  Mem# 0: +REDO_DG/prddg/standby_group27_redo01.log

  Mem# 1: +REDO_DG/prddg/standby_group27_redo02.log

Media Recovery Waiting for thread 1 sequence 125 (in transit)

2018-08-02T23:41:25.722528-07:00

Recovery of Online Redo Log: Thread 1 Group 18 Seq 125 Reading mem 0

  Mem# 0: +REDO_DG/prddg/standby_group18_redo01.log

  Mem# 1: +REDO_DG/prddg/standby_group18_redo02.log

2018-08-03T00:34:04.483536-07:00

oracle@prddg01:prddg01:/u01/admin/prddg01/diag/rdbms/prddg/prddg01/trace>

 

 

Test Case Summary

 

This test case was able to successfully validate the functionality of the on-premises production Oracle RAC, Oracle Far Sync, and Oracle Data Guard RAC setup

  • By switching online redo log files on the production RAC prdrac
  • Generating and send redo to the Oracle Far Sync prdfs synchronously
  • Oracle Far Sync prdfs in turn sends the redo to the DR RAC prddg asynchronously
  • There are no gaps in the archive logs on the DR RAC prddg.
check-circle-line exclamation-circle-line close-line
Scroll to top icon