oracle18c修改sga大小,12C DG DGMGRL必须要记住的几个小命令

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