[oracle@12cr2 ~]$ dgmgrl sys/oracle@newcdb
DGMGRL for Linux: Release 12.2.0.1.0 - Production on Tue Jul 4 22:41:20 2017
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Connected to "newcdb"
Connected as SYSDBA.
DGMGRL> help
The following commands are available:
@ Execute DGMGRL script file
! Host operating system command
/ Repeat the last command
-- Comment to be ignored by DGMGRL
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
host Host operating system command
migrate Migrate a pluggable database from one configuration to another.
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
set Set a property to a specified value
show Displays information about a configuration or a member
shutdown Shuts down a currently running Oracle database instance
spool store input and output of DGMGRL CLI in a file
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 <command>" to see syntax for individual commands
DGMGRL> help validate
Performs an exhaustive set of validations for a database
Syntax:
VALIDATE DATABASE [VERBOSE] <database name>;
VALIDATE DATABASE [VERBOSE] <database name> DATAFILE <datafile number>
OUTPUT=<file name>;
VALIDATE FAR_SYNC [VERBOSE] <far_sync name>
[WHEN PRIMARY IS <database name>];
DGMGRL> SHOW CONFIGURATION
Configuration - dg_newcdb
Protection Mode: MaxPerformance
Members:
newcdb - Primary database
newcdbdg - Physical standby database
frasync - Far sync instance
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS (status updated 71 seconds ago)
DGMGRL> VALIDATE DATABASE VERBOSE newcdb
Database Role: Primary database
Ready for Switchover: Yes
Flashback Database Status:
newcdb: On
Capacity Information:
Database Instances Threads
newcdb 1 1
Managed by Clusterware:
newcdb: NO
Warning: Ensure primary database's StaticConnectIdentifier property
is configured properly so that the primary database can be restarted
by DGMGRL after switchover
Temporary Tablespace File Information:
newcdb TEMP Files: 5
Data file Online Move in Progress:
newcdb: No
Transport-Related Information:
Transport On: Yes
Log Files Cleared:
newcdb Standby Redo Log Files: Cleared
DGMGRL> VALIDATE DATABASE VERBOSE newcdbdg
Database Role: Physical standby database
Primary Database: newcdb
Ready for Switchover: Yes
Ready for Failover: Yes (Primary Running)
Flashback Database Status:
newcdb : On
newcdbdg: On
Capacity Information:
Database Instances Threads
newcdb 1 1
newcdbdg 1 1
Managed by Clusterware:
newcdb : NO
newcdbdg: NO
Warning: Ensure primary database's StaticConnectIdentifier property
is configured properly so that the primary database can be restarted
by DGMGRL after switchover
Temporary Tablespace File Information:
newcdb TEMP Files: 5
newcdbdg TEMP Files: 5
Data file Online Move in Progress:
newcdb: No
newcdbdg: No
Standby Apply-Related Information:
Apply State: Running
Apply Lag: 0 seconds (computed 1 second ago)
Apply Delay: 0 minutes
Transport-Related Information:
Transport On: Yes
Gap Status: No Gap
Transport Lag: 0 seconds (computed 1 second ago)
Transport Status: Success
Log Files Cleared:
newcdb Standby Redo Log Files: Cleared
newcdbdg Online Redo Log Files: Cleared
newcdbdg Standby Redo Log Files: Available
Current Log File Groups Configuration:
Thread # Online Redo Log Groups Standby Redo Log Groups Status
(newcdb) (newcdbdg)
1 3 4 Sufficient SRLs
Future Log File Groups Configuration:
Thread # Online Redo Log Groups Standby Redo Log Groups Status
(newcdbdg) (newcdb)
1 3 2 Insufficient SRLs
Current Configuration Log File Sizes:
Thread # Smallest Online Redo Smallest Standby Redo
Log File Size Log File Size
(newcdb) (newcdbdg)
1 200 MBytes 200 MBytes
Future Configuration Log File Sizes:
Thread # Smallest Online Redo Smallest Standby Redo
Log File Size Log File Size
(newcdbdg) (newcdb)
1 200 MBytes 200 MBytes
Apply-Related Property Settings:
Property newcdb Value newcdbdg Value
DelayMins 0 0
ApplyParallel AUTO AUTO
ApplyInstances 0 0
Transport-Related Property Settings:
Property newcdb Value newcdbdg Value
LogXptMode ASYNC ASYNC
Dependency <empty> <empty>
DelayMins 0 0
Binding optional optional
MaxFailure 0 0
MaxConnections 1 1
ReopenSecs 300 300
NetTimeout 30 30
RedoCompression DISABLE DISABLE
LogShipping ON ON