Datagaurd Creation

 

Step By Step Dataguard Set up in oracle 12c RAC (RAC to RAC)

Prerequisite:

PRIMARY DB :(Node1,Node3)

1-Enable archivelog mode:SQL> archive log list ; Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 34 Next log sequence to archive 35 Current log sequence 35

2-Enable force logging mode

SQL> select force_logging from v$database;

FORCE_LOGGING

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

NO

SQL> alter database force logging;

Database altered.

SQL> select force_logging from v$database;

FORCE_LOGGING

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

YES

3- Configure Standby Redo Log (SRL) files for both the instance :

Min No of SRL= no of threads *(Group in threads +1)
SQL> set lines 200 pages 200

SQL> col MEMBER for a55 

SQL> select group#,thread#,members,status,bytes/1024/1024 from v$log;

    GROUP#    THREAD#    MEMBERS STATUS           BYTES/1024/1024
---------- ---------- ---------- ---------------- ---------------
         1          1          2 CURRENT                       50
         2          1          2 INACTIVE                      50
         3          2          2 CURRENT                       50
         4          2          2 INACTIVE                      50

In our environment we have 4 groups with 2 threads .So here number of SRL will be 
                          SRL= 2*(4+1)=10