10.2.0.5 on windows 2008 64 bit
在primary DB上
如果是lgical stabndby
select dest_name,recovery_mode from v$archive_dest_status
1 LOG_ARCHIVE_DEST_1 IDLE
2 LOG_ARCHIVE_DEST_2 LOGICAL REAL TIME APPLY
3 LOG_ARCHIVE_DEST_3 IDLE
4 LOG_ARCHIVE_DEST_4 IDLE
5 LOG_ARCHIVE_DEST_5 IDLE
6 LOG_ARCHIVE_DEST_6 IDLE
7 LOG_ARCHIVE_DEST_7 IDLE
8 LOG_ARCHIVE_DEST_8 IDLE
9 LOG_ARCHIVE_DEST_9 IDLE
10 LOG_ARCHIVE_DEST_10 IDLE
在alter 日志里面也会体现:
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 145, T:\STANDBY_ARCHIVE\1_145_849630480.ARC
Mon Jul 21 21:45:56 China Standard Time 2014
LOGMINER: End mining logfile: T:\STANDBY_ARCHIVE\1_145_849630480.ARC
Mon Jul 21 21:45:56 China Standard Time 2014
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 146, T:\TESTDGS\STANDBY_REDO05A.L
如果是physical standby:则recovery_mode为:MANAGED REAL TIME APPLY