DG standby db recovery mode idle, and lag for days.
877440Feb 22 2013 — edited Feb 24 2013We have a RAC 2 node primary and 2 node RAC standby qa environment in redhat linux.
two nights ago, some maintenance caused primary down, and db failed over to standby. and now I found out by dgmgrl the following error:
DGMGRL> show configuration
Configuration - oraqa_dg
Protection Mode: MaxPerformance
Databases:
orasqa - Primary database
Error: ORA-16810: multiple errors or warnings detected for the database
oraqa - (*) Physical standby database
Warning: ORA-16829: fast-start failover configuration is lagging
Fast-Start Failover: ENABLED
Configuration Status:
ERROR
DGMGRL> failover to oraqa
Performing failover NOW, please wait...
Error: ORA-16600: not connected to target standby database for failover
Failed.
Unable to failover
DGMGRL> switchover to oraqa
Performing switchover NOW, please wait...
Error: ORA-16810: multiple errors or warnings detected for the database
Failed.
Unable to switchover, primary database is still "orasqa"
I started recover managed standby database using current logfile disconnect;
and see one one node MRP process running, but other node not.
and recover mode is idle ,and no media recovery based on alert logs.
LOGS TIME
---------------- ------------------------
Last applied : 21-FEB-13:01:16:34
Last received : 21-FEB-13:01:16:34
NAME VALUE UNIT
-------------------------------- ---------------------------------------------------------------- ---------------------------------------------
apply finish time day(2) to second(3) interval
apply lag day(2) to second(0) interval
estimated startup time 32 second
transport lag day(2) to second(0) interval
Time Computed: 02/22/2013 15:23:10
How do I get the media recovery started?
Another issue I found out through crsctl stat res, the db on standby shows intermedia status.
ora.oraqa.db
1 ONLINE INTERMEDIATE oracle02 Mounted (Closed)
2 ONLINE INTERMEDIATE oracle03 Mounted (Closed)
Please advice what I can do from this point.
Thanks in advance.