Brian and friends
I do not see data replication after restart physical database that host down 3 days in other city..The primary and standby DB role does not be changed.
In dataguard11.2 (primary and physical standby DB), We startup database and restarted apply server
alter database recover managed standby database cancel;
alter database recover managed standby database using current logfile disconnect;
The physical DB is READ ONLY WITH APPLY mode pe sql in SELECT open_mode FROM V$DATABASE;
But i did not see data replication processing.
We take below reviewing in physical standby DB.
1)
select *FROM V$ARCHIVE_GAP;
no any valu return
2)
SELECT name, value, datum_time, time_computed FROM V$DATAGUARD_STATS WHERE name like 'apply lag';
shoNAME VALUE DATUM_TIME TIME_COMPUTED
--------- ------------- ------------------- -------------------
apply lag 03/25/2014 08:54:17
3) history lag value
SELECT * FROM V$STANDBY_EVENT_HISTOGRAM WHERE NAME = 'apply lag' AND COUNT > 0;
no value
4) SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS FROM V$MANAGED_STANDBY;
PROCESS STATUS THREAD# SEQUENCE# BLOCK# BLOCKS
--------- ------------ ---------- ---------- ---------- ----------
ARCH CLOSING 1 25897 120832 1301
ARCH CLOSING 1 25898 100352 710
ARCH CONNECTED 0 0 0 0
ARCH CLOSING 1 25896 350208 1353
RFSRFS IDLE 0 0 0 0
MRP0 WAIT_FOR_GAP 1 1 0 0
RFSRFS IDLE 0 0 0 0
7 rows selected.
ALso
SQL> SELECT DESTINATION, STATUS, ARCHIVED_THREAD#, ARCHIVED_SEQ# -
FROM V$ARCHIVE_DEST_STATUS -
WHERE STATUS <> 'DEFERRED' AND STATUS <> 'INACTIVE';
no DESTINATION value but status is valid. have archived _sql#
Under this situation, what do we need to do?
Thanks
new dba