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

[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

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