Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

A few small commands that 12C DG DGMGRL must remember

2025-01-17 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

[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

You can't remember these commands clearly, but be sure to remember to help, remember helpbacks! It's absolutely easy to call for help at a critical moment!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report