12CDGDGMGRL必須要記住的幾個(gè)小命令-創(chuàng)新互聯(lián)

[root@roidb01 ~]# su - oracle

成都網(wǎng)站設(shè)計(jì)、成都網(wǎng)站制作、外貿(mào)網(wǎng)站建設(shè)的開發(fā)，更需要了解用戶，從用戶角度來建設(shè)網(wǎng)站，獲得較好的用戶體驗(yàn)。成都創(chuàng)新互聯(lián)多年互聯(lián)網(wǎng)經(jīng)驗(yàn)，見的多，溝通容易、能幫助客戶提出的運(yùn)營建議。作為成都一家網(wǎng)絡(luò)公司，打造的就是網(wǎng)站建設(shè)產(chǎn)品直銷的概念。選擇成都創(chuàng)新互聯(lián)，不只是建站，我們把建站作為產(chǎn)品，不斷的更新、完善，讓每位來訪用戶感受到浩方產(chǎn)品的價(jià)值服務(wù)。

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！?。￡P(guān)鍵時(shí)刻喊救命絕對好用哈?。?！

另外有需要云服務(wù)器可以了解下創(chuàng)新互聯(lián)scvps.cn，海內(nèi)外云服務(wù)器15元起步，三天無理由+7*72小時(shí)售后在線，公司持有idc許可證，提供“云服務(wù)器、裸金屬服務(wù)器、高防服務(wù)器、香港服務(wù)器、美國服務(wù)器、虛擬主機(jī)、免備案服務(wù)器”等云主機(jī)租用服務(wù)以及企業(yè)上云的綜合解決方案，具有“安全穩(wěn)定、簡單易用、服務(wù)可用性高、性價(jià)比高”等特點(diǎn)與優(yōu)勢，專為企業(yè)上云打造定制，能夠滿足用戶豐富、多元化的應(yīng)用場景需求。

標(biāo)題名稱：12CDGDGMGRL必須要記住的幾個(gè)小命令-創(chuàng)新互聯(lián)
本文來源：http://muchs.cn/article12/djeedc.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供網(wǎng)站導(dǎo)航、品牌網(wǎng)站設(shè)計(jì)、建站公司、網(wǎng)站制作、用戶體驗(yàn)、商城網(wǎng)站

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來源： 創(chuàng)新互聯(lián)

外貿(mào)網(wǎng)站制作