ASMCMD> pwd 
+data/woravr/password 

ASMCMD> pwcopy pwdworavr.314.5141100038 /tmp 
copying +data/woravr/password/pwdworavr.314.5141100038 -> /tmp/pwdworavr.314.5141100038 

[oracle@west02]$ scp -p /tmp/pwdworavr.314.5141100038 oracle@east01:/u01/app/oracle/product/19c/db_1/dbs/orapwworavrdr1 
[oracle@west02]$ scp -p /tmp/pwdworavr.314.5141100038 oracle@east02:/u01/app/oracle/product/19c/db_1/dbs/orapwworavrdr2 

Step 3: Configure Standby Redo Logs 

Standby redo logs are essential for real-time redo apply and protection modes like Maximum Availability and Maximum Protection. The recommended number of standby redo log files is: 

Formula(Maximum number of logfiles + 1) × Maximum number of threads 

  

For this configuration: (2 + 1) × 2 = 6 standby redo logs 

Verify Current Online Redo Log Configuration 

SQL> SELECT b.thread#, a.group#, a.member, b.bytes 
FROM v$logfile a, v$log b 
WHERE a.group# = b.group#; 

THREAD#     GROUP# MEMBER                              BYTES 
---------- ---------- ----------------------------------- ---------- 
            1          2 +DATA/woravr/redo02.log             209715200 
            1          1 +DATA/woravr/redo01.log             209715200 
            2          3 +DATA/woravr/redo03.log             209715200 
            2          4 +DATA/woravr/redo04.log             209715200 

Create Standby Redo Logs for Thread 1 

SQL> ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 
      GROUP 5 ('+DATA/woravr/redo05.log') SIZE 200M, 
      GROUP 6 ('+DATA/woravr/redo06.log') SIZE 200M, 
      GROUP 7 ('+DATA/woravr/redo07.log') SIZE 200M; 

Database altered. 

Create Standby Redo Logs for Thread 2 

SQL> ALTER DATABASE ADD STANDBY LOGFILE THREAD 2 
      GROUP 8  ('+DATA/woravr/redo08.log') SIZE 200M, 
      GROUP 9  ('+DATA/woravr/redo09.log') SIZE 200M, 
      GROUP 10 ('+DATA/woravr/redo10.log') SIZE 200M; 

Database altered. 

Verify Standby Redo Log Creation 

SQL> SELECT b.thread#, a.group#, a.member, b.bytes 
FROM v$logfile a, v$standby_log b 
WHERE a.group# = b.group#; 

THREAD#   GROUP#MEMBER                              BYTES 
---------- ---------- ----------------------------------- ---------- 
          1          5 +DATA/woravr/redo05.log             209715200 
          1          6 +DATA/woravr/redo06.log             209715200 
          1          7 +DATA/woravr/redo07.log             209715200 
          2          8 +DATA/woravr/redo08.log             209715200 
          2          9 +DATA/woravr/redo09.log             209715200 
          2         10 +DATA/woravr/redo10.log             209715200 

6 rows selected. 

Step 4: Verify Archive Mode 

SQL> ARCHIVE LOG LIST; 

Database log mode              Archive Mode 
Automatic archival             Enabled 
Archive destination            +FRA 
Oldest online log sequence     10 
Next log sequence to archive   11 
Current log sequence           11 

Step 5: Configure Primary Database Initialization Parameters 

Data Guard requires specific initialization parameters to enable redo transport, log apply services, and file name conversion between sites. 

Backup Current Parameter File 

SQL> CREATE PFILE='/home/oracle/initworavr.ora.bkp_vr' FROM SPFILE; 

File created. 

Set Essential Data Guard Parameters 

SQL> ALTER SYSTEM SET db_unique_name='woravr' SCOPE=SPFILE SID='*'; 
SQL> ALTER SYSTEM SET LOG_ARCHIVE_CONFIG='DG_CONFIG=(woravr,woravrdr)' SCOPE=BOTH SID='*'; 
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=+FRA VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=woravr' SCOPE=BOTH SID='*'; 
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE=woravrdr LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=woravrdr' SCOPE=BOTH SID='*'; 
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_1=ENABLE SCOPE=BOTH SID='*'; 
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE SCOPE=BOTH SID='*'; 

Deprecation NoticeThe FAL_CLIENT parameter is deprecated in Oracle 19c but included here for reference. FAL_SERVER remains active for fetch archive log operations. 

Configure FAL and File Name Conversion 

SQL> ALTER SYSTEM SET fal_client=woravr SCOPE=BOTH SID='*'; 
SQL> ALTER SYSTEM SET fal_server=woravrdr SCOPE=BOTH SID='*'; 
SQL> ALTER SYSTEM SET DB_FILE_NAME_CONVERT='+DATA_DG','+DATA' SCOPE=SPFILE SID='*'; 
SQL> ALTER SYSTEM SET LOG_FILE_NAME_CONVERT='+DATA_DG','+DATA' SCOPE=SPFILE SID='*'; 
SQL> ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=AUTO SCOPE=BOTH SID='*';