Database Reference
In-Depth Information
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 0 seconds ago)
Apply Lag: 0 seconds (computed 0 seconds ago)
Apply Rate: 1.22 MByte/s
Real Time Query: OFF
Instance(s):
CDBFSDCB
Database Status:
SUCCESS
The below example extends the file system scenario, and there are two databases in the configuration. Connect to
the current primary database and query the state of the configuration:
DGMGRL> show configuration
Configuration - fsconfig
Protection Mode: MaxPerformance
Databases:
CDBFSDCA - Primary database
CDBFSDCB - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
The Data Guard broker returned success: there are no known problems that could prevent a switchover from
succeeding. Just to be safe you can query the database for its readiness to switch roles:
DGMGRL> validate database "CDBFSDCB"
Database Role: Physical standby database
Primary Database: CDBFSDCA
Ready for Switchover: Yes
Ready for Failover: Yes (Primary Running)
Flashback Database Status:
CDBFSDCA: Off
CDBFSDCB: Off
Current Log File Groups Configuration:
Thread # Online Redo Log Groups Standby Redo Log Groups
(CDBFSDCA) (CDBFSDCB)
1 3 2
Future Log File Groups Configuration:
Thread # Online Redo Log Groups Standby Redo Log Groups
(CDBFSDCB) (CDBFSDCA)
1 3 2
 
Search WWH ::




Custom Search