iSelfSchooling.com  Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Problem Solver

    .Home      .Subscribe     .Login      .Start Learning      .Certification      .Cancel      .Password Reminder      .Password Change     .Sign out

 

. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       .Email2aFriend    |

 

Oracle 11g New Features

Online Oracle Training

 

DATAGUARD BROKER - How to create and configure data guard broker

 

 

Assumption:

My database name: mydb

My primary database (SID): mydb_p

My standby database (SID): mydb_s

 

To use the dataguard broker, make sure that the dg_broker_start parameter was set to TRUE on both Primary and Standby sites:

SQL> Alter system set dg_broker_start=True scope=both;

 


On any servers (primary or standby):

# dgmgrl sys/oracle@mydb_p   -- on primary


DGMGRL> create configuration 'dg_mydb' as
> primary database is 'mydb_p'
> connect identifier is mydb_p;


DGMGRL> Add database 'mydb_s' as
> connect identifier is mydb_s 
> maintained as physical;

 

To enable the configuration and see the output do the following commands.
DGMGRL> enable configuration;
DGMGRL> show configuration

Switchover to your standby database:
Notice with switchover, your standby becomes primary and your primary becomes standby:

DGMGRL> switchover to 'mydb_s';


Failover to your standby:

Notice that with the failover, your old primary no longer syncing and your standby become primary.

DGMGRL> failover to 'mydb_s';
Failover to standby succeeded.


Make sure to enable FLAHBACK ON.
SQL> alter database flashback on;
SQL> Alter System set Log_archive_dest_2='Service=to_primary LGWR AFFIRM SYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)db_unique_name=primary';
SQL> Alter database set primary database to maximize availability;
# dgmgrl sys/oracle@mydb_p
DGMGRL> show configuration; --If a configuration is displayed then remove it.

 

To remove your configuration:
DGMGRL> remove configuration;
 

 

To edit configuration for each databases:
DGMGRL> show database verbose mydb_p;

DGMGRL> edit database PRIMARY set property LogXptMode='SYNC';
DGMGRL> edit database STANDBY set property LogXptMode='SYNC';
DGMGRL> edit configuration set protection mode as MaxAvailability;
DGMGRL> enable fast_start failover;
DGMGRL> show configuration;

To start observer:
DGMGRL> start observer;
 

 

 

Good Luck!

 

Google
 
Web web site