12CDGDGMGRL必须要记住的几个小命令

[root@roidb01 ~]# su - oracle

10余年的内江网站建设经验，针对设计、前端、开发、售后、文案、推广等六对一服务，响应快，48小时及时工作处理。成都营销网站建设的优势是能够根据用户设备显示端的尺寸不同，自动调整内江建站的显示方式，使网站能够适用不同显示终端，在浏览器中调整网站的宽度，无论在任何一种浏览器上浏览网站，都能展现优雅布局与设计，从而大程度地提升浏览体验。成都创新互联公司从事“内江网站设计”,“内江网站推广”以来，每个客户项目都认真落实执行。

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]