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

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