A few small commands that 12C DG DGMGRL must remember
[root@roidb01 ~] # su-oracle
Last login: Thu Nov 23 20:32:31 CST 2017 on pts/1
$dgmgrl /
DGMGRL for Linux: Version 12.1.0.2.0-64bit Production
Copyright (c) 2000, 2013, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Connected as SYSDG.
DGMGRL > help
The following commands are available:
Add Adds a member to the broker configuration
Connect Connects to an Oracle database instance
Convert Converts a database from one type to another
Create Creates a broker configuration
Disable Disables a configuration, a member, or fast-start failover
Edit Edits a configuration or a member
Enable Enables a configuration, a member, or fast-start failover
Exit Exits the program
Failover Changes a standby database to be the primary database
Help Displays description and syntax for a command
Quit Exits the program
Reinstate Changes a database marked for reinstatement into a viable standby
Rem Comment to be ignored by DGMGRL
Remove Removes a configuration or a member
Show Displays information about a configuration or a member
Shutdown Shuts down a currently running Oracle database instance
Sql Executes a SQL statement
Start Starts the fast-start failover observer
Startup Starts an Oracle database instance
Stop Stops the fast-start failover observer
Switchover Switches roles between a primary and standby database
Validate Performs an exhaustive set of validations for a database
Use "help" to see syntax for individual commands
DGMGRL > show configuration
Configuration-dg_config
Protection Mode: MaxProtection
Members:
Orcl-Primary database
Orcldg-Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS (status updated 51 seconds ago)
DGMGRL > show database orcl
Database-orcl
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance (s):
Orcl
Database Status:
SUCCESS
DGMGRL > show database verbose orcl
Database-orcl
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance (s):
Orcl
Properties:
DGConnectIdentifier = 'orcl'
ObserverConnectIdentifier =''
LogXptMode = 'sync'
RedoRoutes =''
DelayMins ='0'
Binding = 'optional'
MaxFailure ='0'
MaxConnections ='1'
ReopenSecs = '300'
NetTimeout = '10'
RedoCompression = 'DISABLE'
LogShipping = 'ON'
PreferredApplyInstance =''
ApplyInstanceTimeout ='0'
ApplyLagThreshold ='0'
TransportLagThreshold ='0'
TransportDisconnectedThreshold = '30'
ApplyParallel = 'AUTO'
StandbyFileManagement = 'AUTO'
ArchiveLagTarget ='0'
LogArchiveMaxProcesses ='4'
LogArchiveMinSucceedDest ='1'
DbFileNameConvert =''
LogFileNameConvert =''
FastStartFailoverTarget =''
InconsistentProperties ='(monitor)'
InconsistentLogXptProps ='(monitor)'
SendQEntries ='(monitor)'
LogXptStatus ='(monitor)'
RecvQEntries ='(monitor)'
StaticConnectIdentifier ='(DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=roidb01) (PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=orcl_DGMGRL) (INSTANCE_NAME=orcl) (SERVER=DEDICATED)'
StandbyArchiveLocation ='+ DATADG/arch'
AlternateLocation =''
LogArchiveTrace ='0'
LogArchiveFormat = 'log_%t_%s_%r_%d.arc'
TopWaitEvents ='(monitor)'
Database Status:
SUCCESS
DGMGRL > help show
Displays information about a configuration or a member
Syntax:
SHOW CONFIGURATION [VERBOSE]
SHOW CONFIGURATION WHEN PRIMARY IS
SHOW {BACKUP_APPLIANCE | DATABASE | FAR_SYNC} [VERBOSE]
[]
SHOW INSTANCE [VERBOSE] []
[ON {DATABASE | FAR_SYNC}]
SHOW FAST_START FAILOVER
You can't remember these commands clearly, but be sure to remember to help, remember helpbacks! It's absolutely easy to call for help at a critical moment!
