DataGuard

ACTIVE DATAGUARD COMMANDS

ENABLE CONFIGURATION; - Enables the broker to actively manage the broker configuration including 

all of its site objects and database resource objects.

DGMGRL> SHOW CONFIGURATION;

Configuration 'Sales' is

  Primary Site is 'Boston'

  Standby Site is 'San Francisco'

Current status for "Sales":

SUCCESS

ALTER CONFIGURATION SET PROTECTION MODE AS protection-mode;

Protection Mode -                 Log Transport Mode -          Require Physical Standby Database

and Standby Redo Logs?

MAXPROTECTION                                           – SYNC                                  - Yes

MAXAVAILABILITY                                        – SYNC                                                  - No

MAXPERFORMANCE                                      - ARCH or ASYNC                             - No

ALTER CONFIGURATION SET STATE = state; (ONLINE / OFFLINE)

This example connects to a remote database whose service name is prmy.

DGMGRL> CONNECT sys/change_on_install@prmy;

Connected.

The following example creates a new broker configuration named Sales with a database that will have the physical standby characteristics if the primary database transitions to the standby role in a future switchover operation.

DGMGRL> CREATE CONFIGURATION 'Sales' AS

  PRIMARY SITE IS 'Boston'

  RESOURCE IS 'Sales_db'

  HOSTNAME IS 'boston'

  INSTANCE NAME IS 'bstn'

  SERVICE NAME IS 'bstn'

    SITE IS MAINTAINED AS PHYSICAL;

DGMGRL> FAILOVER TO 'Standby2' GRACEFUL; - GRACEFUL OR FORCED

Performing failover NOW. Please wait...

Operation requires restart of site "Standby2"

Shutting down site Standby2...

database not mounted

ORACLE instance shut down.

Restarting site Standby2...

Started "Standby2" as new primary

Failover succeeded. New primary is "Standby2"

The following example uses the VERBOSE option to show complete information about the database resource object called Sales_db on the Boston site.

DGMGRL> SHOW RESOURCE VERBOSE Sales_db;

SWITCHOVER TO ‘sanfrancisco’; The name of the standby site that you want to change to the primary role