Drop/remove Far-Sync Configurations from broker 12.1

Show current overall configuration


DGMGRL> show configuration

Configuration - dr

 Protection Mode: MaxAvailability

 Members:
 PRMRY - Primary database
   FRSNC - Far sync instance
     STNDBY - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS   (status updated 49 seconds ago)


Show current Primary redo routes settings


DGMGRL> show database PRMRY RedoRoutes
 RedoRoutes = '(LOCAL : FRSNC SYNC)'

Changing to MAXPERFORMANCE to be able  to modify the RedoRoutes

DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXPERFORMANCE;
Succeeded.

Replace Primary RedoRoutes to point to Standby instead of Far Sync


DGMGRL> edit database PRMRY set property RedoRoutes='(LOCAL : STNDBY SYNC)';
Property "redoroutes" updated

Show current Standby redo routes settings


DGMGRL> show database STNDBY RedoRoutes
 RedoRoutes = '(LOCAL : FRSNC SYNC)'

Replace Standby RedoRoutes to point to Primary instead of Far Sync


DGMGRL> edit database STNDBY set property RedoRoutes='(LOCAL : PRMRY SYNC)';
Property "redoroutes" updated

Show current Far Sync redo routes settings


DGMGRL> show far_sync FRSNC  RedoRoutes
 RedoRoutes = '(PRMRY : STNDBY ASYNC)(STNDBY : PRMRY  ASYNC)'

Replace Far Sync RedoRoutes to point to nothing


DGMGRL> edit far_sync FRSNC set property RedoRoutes='';
Property "redoroutes" updated

Show current overall configuration


DGMGRL> show configuration

Configuration - dr

 Protection Mode: MaxPerformance
 Members:
 PRMRY - Primary database
   STNDBY - Physical standby database

 Members Not Receiving Redo:
 FRSNC - Far sync instance

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS   (status updated 8 seconds ago)

Now we can disable Far Sync


DGMGRL> disable far_sync FRSNC
Disabled.

Show current overall configuration

DGMGRL> show configuration

Configuration - dr

 Protection Mode: MaxPerformance
 Members:
 PRMRY - Primary database
   STNDBY - Physical standby database

 Members Not Receiving Redo:
 FRSNC - Far sync instance (disabled)

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS   (status updated 39 seconds ago)

Setting overall protection mode to the state it was at the beginning 


DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
DGMGRL> show configuration

Configuration - dr

 Protection Mode: MaxAvailability
 Members:
 PRMRY - Primary database
   STNDBY - Physical standby database

 Members Not Receiving Redo:
 FRSNC - Far sync instance (disabled)

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS   (status updated 20 seconds ago)

Now you can remove Far Sync

DGMGRL> REMOVE FAR_SYNC FRSNC;

Show final configuration without Far Sync


DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
DGMGRL> show configuration

Configuration - dr

 Protection Mode: MaxAvailability
 Members:
 PRMRY - Primary database
   STNDBY - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS   (status updated 20 seconds ago)



Yossi

Comments

Popular posts from this blog

Fixing & Registering ORACLE_HOMES in Central Inventory

Export in Pl/Sql via DBMS_DATAPUMP

Oracle 18c - New Features for Active Data Guard