In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
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.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.