12C DG DGMGRL必须要记住的几个小命令
admin
2023-04-25 03:01:04
0次


[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;


这些命令可以记不清,但是一定要记住帮助,记住help!!!关键时刻喊救命绝对好用哈!!!


相关内容

热门资讯

空调连续工作多久需要停机休息 空调连续工作的时间取决于多个因素,包括空调的型号、功率、使用环境和维护情况等。一般来说,空调可以连续...
空调哪个符号是除湿的 空调除湿功能通常用一个水滴形状的符号表示。不同品牌和型号的空调遥控器可能会有所差异,但一般来说,除湿...
格力空调多长时间加一次氟利昂 1、一般情况下,空调对氟利昂的使用量是非常小的,所以在空调使用了四年左右的时候再考虑加也没问题。2、...
空调用多长时间需要加氟一次 一般情况下是五年。当出现以下这几种情况时,空调才需要加氟。1、空调的室内机和室外机各有两个接口,当接...
格调生活·C标思享荟:卡萨帝在... 9月12日的郑州龙湖金融岛,夜风轻拂,灯光璀璨。“C标时刻共传奇——卡萨帝思享荟暨20周年品牌盛典郑...
品牌价值破千亿、高端份额持续领... 9月12日,“C标时刻共传奇——卡萨帝思享荟暨20周年品牌盛典郑州站”在郑州龙湖金融岛举办。2026...
空调主板坏了修800还是换新的 空调主板坏了是修还是换新,需要考虑多个因素,以下是一些建议:1. 维修成本:如果维修费用较低,比如 ...
空调开多久需要休息多长时间 问题:空调开多久需要休息多长时间回答:1、在使用空调的过程中,一般空调开7~8个小时左右需要休息2~...
中央空调多长时间清洗一次 1、一般空调开机前清洗一次即可,空调开机中间时段再清洗一次,空调关机时清洗一次,这样比较合理。2、空...
中央空调氟利昂多久加一次 看空调制热和制冷程度,很多人的观点认为氟利昂必须一年放一次,其实这个观点是错误的,理解上面有点偏差,...