Add online redo log group in standby database

How to add online redo log group in standby database

1. Change the value of standby database state to "APPLY-OFF" in dgmgrl

DGMGRL> show database verbose testdgbdr;

Database - testdgbdr 

  Role:               PHYSICAL STANDBY

  Intended State:     APPLY-ON

DGMGRL> edit database testdgbdr set state='APPLY-OFF';

DGMGRL> show database verbose testdgbdr;

Database - testdgbdr 

  Role:               PHYSICAL STANDBY

  Intended State:     APPLY-OFF

2. Add online redo log group in standby database

SQL> select db_unique_name from v$database

DB_UNIQUE_NAME

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

testdgbdr 

SQL> select group#, bytes/1024/1024 MB from v$log;

    GROUP#         MB

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

         1         50

         2         50

         3         50

SQL> alter database add logfile group 4 ('/u01/app/redo/testdgb/redo04.log') SIZE 50M;

Database altered.

SQL> select group#, bytes/1024/1024 MB from v$log;

    GROUP#         MB

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

         1         50

         2         50

         3         50

         4         50

3. Change the value of standby database state to "APPLY-ON" in dgmgrl

DGMGRL> show database verbose testdgbdr;

Database - testdgbdr 

  Role:               PHYSICAL STANDBY

  Intended State:     APPLY-OFF

DGMGRL> edit database testdgbdr set state='APPLY-ON';

DGMGRL> show database verbose testdgbdr;

Database - testdgbdr 

  Role:               PHYSICAL STANDBY

  Intended State:     APPLY-ON