dgmgrl - Data Guard Manager Utility

ADD - Adds a standby database to the broker configuration.

DGMGRL> ADD DATABASE db_name [AS CONNECT IDENTIFIER IS conn_identifier] [MAINTAINED AS {PHYSICAL|LOGICAL}];

DGMGRL> ADD DATABASE 'testdb' AS CONNECT IDENTIFIER IS testdb MAINTAINED AS PHYSICAL;
DGMGRL> ADD DATABASE 'logdb' AS CONNECT IDENTIFIER IS logdb MAINTAINED AS LOGICAL;

DGMGRL> ADD DATABASE 'devdb' AS CONNECT IDENTIFIER IS devdb.foo.com;

CONNECT - Connects to an Oracle database instance.

DGMGRL> CONNECT username/password[@connect_identifier]

DGMGRL> CONNECT sys;

DGMGRL> CONNECT sys@test;

DGMGRL> CONNECT sys/pwd;

DGMGRL> CONNECT sys/pwd@dwh;

$dgmgrl connect sys

CONVERT - Converts a database from one type to another (from 11g).

DGMGRL> CONVERT DATABASE database_name TO {SNAPSHOT STANDBY|PHYSICAL STANDBY};

DGMGRL> CONVERT DATABASE 'devdb' to SNAPSHOT STANDBY;

DGMGRL> CONVERT DATABASE 'devdb' to PHYSICAL STANDBY;

CREATE - Creates a broker configuration.

DGMGRL> CREATE CONFIGURATION config_name AS PRIMARY DATABASE IS db_name CONNECT IDENTIFIER IS conn_ident;

DGMGRL> CREATE CONFIGURATION 'dg' AS PRIMARY DATABASE IS 'prod' CONNECT IDENTIFIER IS prod.foo.com;

DGMGRL> CREATE CONFIGURATION 'dg_test' AS PRIMARY DATABASE IS 'test' CONNECT IDENTIFIER IS test;

DISABLE - Disables a configuration, a database, or fast-start failover.

DGMGRL> DISABLE CONFIGURATION;

DGMGRL> DISABLE DATABASE database_name;

DGMGRL> DISABLE FAST_START FAILOVER [FORCE | CONDITION condition];

DGMGRL> DISABLE CONFIGURATION;

DGMGRL> DISABLE DATABASE 'devdb';
DGMGRL> DISABLE FAST_START FAILOVER;

EDIT - Edits a configuration, database, or instance.

DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS {MaxProtection|MaxAvailability|MaxPerformance};

DGMGRL> EDIT CONFIGURATION SET PROPERTY property_name = value;

DGMGRL> EDIT DATABASE database_name SET PROPERTY property_name = value;

DGMGRL> EDIT DATABASE database_name RENAME TO new database_name;

DGMGRL> EDIT DATABASE database_name SET STATE = state [WITH APPLY INSTANCE = instance_name];

DGMGRL> EDIT INSTANCE instance_name [ON DATABASE database_name] SET AUTO PFILE [={init_file_path|OFF}];

DGMGRL> EDIT INSTANCE instance_name [ON DATABASE database_name] SET PROPERTY property_name = value;

DGMGRL> EDIT INSTANCE * ON DATABASE database_name SET PROPERTY property_name = value;

DGMGRL> EDIT DATABASE 'devdb' SET PROPERTY 'LogArchiveFormat'='log_%t_%s_%r_%d.arc';

DGMGRL> EDIT DATABASE 'prodb' SET PROPERTY 'LogXptMode'='SYNC';

DGMGRL> EDIT DATABASE 'devdb' SET STATE='READ-ONLY';

DGMGRL> EDIT DATABASE 'devdb' SET STATE='OFFLINE';

DGMGRL> EDIT DATABASE 'devdb' SET STATE='APPLY-OFF';

DGMGRL> EDIT DATABASE devdb SET STATE=TRANSPORT-OFF;

DGMGRL> EDIT DATABASE devdb SET STATE=TRANSPORT-ON;

DGMGRL> EDIT DATABASE prodb SET STATE='LOG-TRANSPORT-OFF';

DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXPROTECTION;

DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;

DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXPERFORMANCE;

ENABLE - Enables a configuration, a database, or fast-start failover.

DGMGRL> ENABLE CONFIGURATION;

DGMGRL> ENABLE DATABASE database_name;

DGMGRL> ENABLE FAST_START FAILOVER [CONDITION condition];

DGMGRL> ENABLE CONFIGURATION;

DGMGRL> ENABLE DATABASE 'devdb';

DGMGRL> ENABLE FAST_START FAILOVER;

EXIT - Exits the program.

DGMGRL> EXIT;

FAILOVER - Changes a standby database to be the primary database.

DGMGRL> FAILOVER TO standby_database_name [IMMEDIATE]

DGMGRL> FAILOVER TO "testdb";

HELP - Displays description and syntax for a command.

DGMGRL> HELP [command];

DGMGRL> HELP REINSTATE

QUIT - Exits the program.

DGMGRL> QUIT;

REINSTATE - Changes a database marked for reinstatement into a viable standby.

DGMGRL> REINSTATE DATABASE database_name;

DGMGRL> REINSTATE DATABASE orcl;

REM - Comment to be ignored by DGMGRL.

DGMGRL> REM [comment];

REMOVE - Removes a configuration, database, or instance.

DGMGRL> REMOVE CONFIGURATION [PRESERVE DESTINATIONS];

DGMGRL> REMOVE DATABASE database_name [PRESERVE DESTINATIONS];

DGMGRL> REMOVE INSTANCE instance_name [ON DATABASE database_name];

DGMGRL> REMOVE CONFIGURATION;

DGMGRL> REMOVE DATABASE 'devdb';
DGMGRL> REMOVE INSTANCE inst1 ON DATABASE racdb;

SHOW - Displays information about a configuration, database, or instance.

DGMGRL> SHOW CONFIGURATION [VERBOSE];

DGMGRL> SHOW DATABASE [VERBOSE] db_name [property_name];

DGMGRL> SHOW INSTANCE [VERBOSE] instance_name [property_name] [ON DATABASE db_name];

DGMGRL> SHOW FAST_START FAILOVER;

DGMGRL> SHOW CONFIGURATION;

DGMGRL> SHOW CONFIGURATION VERBOSE;

DGMGRL> SHOW DATABASE 'devdb';

DGMGRL> SHOW DATABASE VERBOSE 'test';

DGMGRL> SHOW DATABASE 'dwhdb' 'StatusReport';

DGMGRL> SHOW DATABASE 'dwhdb' 'LogXptStatus';

DGMGRL> SHOW DATABASE 'dwhdb' 'InconsistentProperties';

DGMGRL> SHOW INSTANCE inst1;

DGMGRL> SHOW INSTANCE VERBOSE inst3;

DGMGRL> SHOW FAST_START FAILOVER;

SHUTDOWN - Shuts down a currently running Oracle instance.

DGMGRL> SHUTDOWN [NORMAL | IMMEDIATE | ABORT];

DGMGRL> SHUTDOWN;

START - Starts the fast-start failover observer.

DGMGRL> START OBSERVER [FILE=observer_configuration_file];

DGMGRL> START OBSERVER;

STARTUP - Starts an Oracle database instance.

DGMGRL> STARTUP [RESTRICT] [FORCE] [PFILE=filespec] [MOUNT | OPEN [READ ONLY|READ WRITE]] [NOMOUNT];

DGMGRL> STARTUP;

STOP - Stops the fast-start failover observer.

DGMGRL> STOP OBSERVER;

SWITCHOVER - Switches roles between a primary and standby database.

DGMGRL> SWITCHOVER TO standby_database_name;

DGMGRL> SWITCHOVER TO "standby";