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

Post a Comment

Popular posts from this blog

Silent Installation

Some times there are problems using installation with GUI, the reason can be: 1. Firewall 2. Unix security 3. Client software (missing or not working( and maybe some more reasons If your environment is cooperative helping you solve this - it is simple - go for it. But if you are on your own and can't reach "the right guys" - do it yourself " Silently " Look for the proper response file fits for your needs in /database/response/ Edit it and run the following command: $ ./runInstaller -force -invPtrLoc /oraInst.loc -silent -noconfig -ignoreSysPrereqs -responseFile /database/response/enterprise.rsp You can also run the installer without a response file as mentioned in Metalink Note 782918.1 $ ./runInstaller -silent -force -debug \ FROM_LOCATION="/mount/dvd/database/stage/products.xml" \ ORACLE_HOME="/u01/app/oracle/product/11.1.0/db_1" \ ORACLE_HOME_NAME="Ora11gDb1" ORACLE_BASE="/u01/app/oracle" \ TOPLEVEL_COMPONENT='{&q
Read more

Data Guard - Changing IP Addresses

Image
When changing IP of a host we should update/recheck the following places: /etc/hosts or DNS listener.ora tnsnames.ora Database parameters (local_listener, remote_listener) Data Guard configuration This document is also relevant when changing the IP address of the connection between the hosts, other than the original IP addresses we used during the installation. When installation is done using the hostname and not the IP address, most of the changes are not relevant except for /etc/hosts. In this document, I will describe how to change the Data Guard Broker configuration. Dataguard configuration Show the environment DGMGRL> show configuration Configuration - dr   Protection Mode: MaxAvailability   Members:   pdb7 - Primary database     fdb7 - Far sync instance       sdb7 - Physical standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS   (status updated 351 seconds ago) Show detailed information of the Primary
Read more

Fixing & Registering ORACLE_HOMES in Central Inventory

Central Inventory location is determined by oraInst.loc located in: HP/Solaris /var/opt/oracle/oraInst.loc Linux /etc/oraInst.loc Windows \\HKEY_LOCAL_MACHINE\Software\Oracle\inst_loc To check if all oracle homes are registered within the Central Inventory run the following command: ${ORACLE_HOME}/oui/bin/opatch lsinventory -all Invoking OPatch 10.2.0.3.0 Oracle interim Patch Installer version 10.2.0.3.0 Copyright (c) 2005, Oracle Corporation. All rights reserved.. Oracle Home : /software/oracle/OEM10gR2/agent10g Central Inventory : /software/oracle/oraInventory from : /var/opt/oracle/oraInst.loc OPatch version : 10.2.0.3.0 OUI version : 10.2.0.3.0 OUI location : /software/oracle/OEM10gR2/agent10g/oui Log file location : /software/oracle/OEM10gR2/agent10g/cfgtoollogs/opatch/opatch....log Lsinventory Output file location : /software/oracle/OEM10gR2/agent10g/cfgtoollogs/....lsinventory.....txt ----------------------------------... List of Oracle Homes:
Read more