Data Guard enable/edit database/configuration commands Oracle Tips by Burleson Consulting December 9, 2011

Oracle Data GuardChapter 10 - Oracle 10g:  New Features of Data Guard

Data Guard Broker improvements

The Data Guard Broker has several new commands to manage in 10g and beyond. They are as follows:  add database, edit database, remove database, disable database, enable database, edit instance, and edit configuration.

Some of these commands are replacements for obsolete commands.

• DISABLE DATABASE replaces DISABLE RESOURCE
   

• ENABLE DATABASE replaces ENABLE RESOURCE
   

• EDIT DATABASE replaces ALTER RESOURC
   

• EDIT CONFIGURATION replaces ALTER CONFIGURATION

The Data Guard broker has added support for RAC databases. RAC databases allow multiple instances to access a single, shared database.

A RAC database can be configured and supported in a Data Guard configuration using the GUI or the command line interface. The DGMGRL commands and GUI pages can be used for a RAC database, just as they are used for a single instance database.

The broker only supports the sending of all redo log files to one instance on the standby database. The Oracle instance can be a single instance database or a RAC database, but in either case, only one instance will act as the receiving instance and the apply instance.

10g Data Guard Supplemental Logging

Supplemental Logging enhancements are aimed at improving streams and other data sharing facilities.