12C DG DGMGRL必須要記住的幾個小命令

[root@roidb01 ~]# su - oracle

Last login: Thu Nov 23 20:32:31 CST 2017 on pts/1

<roidb01:orcl:/home/oracle>$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 <command>" 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 <database name>;

  SHOW { BACKUP_APPLIANCE | DATABASE | FAR_SYNC } [VERBOSE] 

    <object name> [<property name>];

  SHOW INSTANCE [VERBOSE] <instance name> [<property name>]

    [ON { DATABASE | FAR_SYNC } <object name>];

  SHOW FAST_START FAILOVER;

這些命令可以記不清，但是一定要記住幫助，記住help！！！關鍵時刻喊救命絕對好用哈！！！