Problem:
Cause:
Reason in my case is that the DR host is shutdown and primary can not connect to it.
Fix:
Start the DR host and things start looking normal again.
Dataguard is show multiple error:
ORA-16810 ORA-16737 ORA-16662 DGM-17016
Error: ORA-16810: multiple errors or warnings detected for the database
Error: ORA-16662: network timeout when contacting a database
DGM-17016: failed to retrieve status for database "db1tesd"
DGMGRL> connect sys
Password:
Connected as SYSDG.
DGMGRL> show configuration
Configuration - db1tes_dg
Protection Mode: MaxPerformance
Members:
db1tesp - Primary database
Error: ORA-16810: multiple errors or warnings detected for the database
db1tesd - Physical standby database
Error: ORA-16662: network timeout when contacting a database
Fast-Start Failover: DISABLED
Configuration Status:
ERROR (status updated 428 seconds ago)
DGMGRL>
DGMGRL> show database db1tesp
Database - db1tesp
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
db1tesp1
Error: ORA-16737: the redo transport service for standby database "db1tesd" has an error
db1tesp2
Error: ORA-16737: the redo transport service for standby database "db1tesd" has an error
Database Status:
ERROR
DGMGRL>
DGMGRL>
DGMGRL> show database db1tesd
Database - db1tesd
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: (unknown)
Apply Lag: (unknown)
Average Apply Rate: (unknown)
Real Time Query: OFF
Instance(s):
db1tesd1
Database Status:
DGM-17016: failed to retrieve status for database "db1tesd"
ORA-16662: network timeout when contacting a database
DGMGRL>
Cause:
Reason in my case is that the DR host is shutdown and primary can not connect to it.
Fix:
Start the DR host and things start looking normal again.
No comments:
Post a Comment