Changing apply instance using dgmgrl

I want to move my apply instance from BHU_1 to BHU_2 on BHU_A database. I have been using a different approach and you need to connect to multiple sessions/servers to perform this task. I found an easiest way to change it.

Please find the current status of the apply instance.

DGMGRL> show database 'BHU_A';

Database - BHU_A

  Role:            PHYSICAL STANDBY

  Intended State:  APPLY-ON

  Transport Lag:   0 seconds

  Apply Lag:       0 seconds

  Real Time Query: OFF

  Instance(s):

    BHU_1 (apply instance)

    BHU_2

Database Status:

SUCCESS

If we want move the apply instance, we need to stop the recover process. So I am stopping the recover process on the node#1(BHU_1)

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

Succeeded.

Enabling recover process and asking the system to start the apply process on the node#2

DGMGRL> edit database 'BHU_A' set state='APPLY-ON' with apply instance ='BHU_2';

Succeeded.

Now let us look the status of apply instance

DGMGRL> show database 'BHU_A';

Database - BHU_A

  Role:            PHYSICAL STANDBY

  Intended State:  APPLY-ON

  Transport Lag:   0 seconds

  Apply Lag:       0 seconds

  Real Time Query: OFF

  Instance(s):

    BHU_1

    BHU_2 (apply instance)

Database Status:

SUCCESS

Checking the status of the data guard.

DGMGRL> show configuration;

Configuration - DG_BHU

  Protection Mode: MaxAvailability

  Databases:

    BHU_B - Primary database

    BHU_A - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS

Happy learning!!!!!!!!