12CDGDGMGRL必须要记住的几个小命令-创新互联

[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！！！关键时刻喊救命绝对好用哈！！！

另外有需要云服务器可以了解下创新互联scvps.cn，海内外云服务器15元起步，三天无理由+7*72小时售后在线，公司持有idc许可证，提供“云服务器、裸金属服务器、高防服务器、香港服务器、美国服务器、虚拟主机、免备案服务器”等云主机租用服务以及企业上云的综合解决方案，具有“安全稳定、简单易用、服务可用性高、性价比高”等特点与优势，专为企业上云打造定制，能够满足用户丰富、多元化的应用场景需求。

标题名称：12CDGDGMGRL必须要记住的几个小命令-创新互联
本文来源：https://www.cdcxhl.com/article12/djeedc.html

成都网站建设公司_创新互联，为您提供网站导航、品牌网站设计、建站公司、网站制作、用户体验、商城网站

广告

声明：本网站发布的内容（图片、视频和文字）以用户投稿、用户转载内容为主，如果涉及侵权请尽快告知，我们将会在第一时间删除。文章观点不代表本网站立场，如需处理请联系客服。电话：028-86922220；邮箱：631063699@qq.com。内容未经允许不得转载，或转载时需注明来源： 创新互联