Tuesday, March 2, 2010

Create a Dataguard Broker Configuration

To create a dataguard broker standby configuration for physical standby on RAC, with preferred apply instances.

dgmgrl
connect sys/
remove configuration;
create configuration 'PROD' as primary database IS 'prod' connect identifier is prod;
add database 'stby' as connect identifier is stby maintained as physical;
edit database prod set property logxptmode='ASYNC';
edit database stby set property logxptmode='ASYNC';
edit database prod set property PreferredApplyInstance='prod1';
edit database stby set property PreferredApplyInstance='stby1';
edit database prod set property MaxFailure=15;
edit database stby set property MaxFailure=15;
edit database prod set property ReopenSecs=60;
edit database stby set property ReopenSecs=60;
edit database prod set property LogArchiveMaxProcesses=10;
edit database stby set property LogArchiveMaxProcesses=10;
enable configuration;