Hello @,
i am receiving following notification in my primary db alert
******************************************************************
LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2
******************************************************************
LNS: Standby redo logfile selected for thread 1 sequence 19008 for destination LOG_ARCHIVE_DEST_2
Tue May 13 21:27:37 2014
Thread 1 advanced to log sequence 19009 (LGWR switch)
Current log# 1 seq# 19009 mem# 0: M:\ORACLE\PRODUCT\11.2.0\ORADATA\WDEGPRO\REDO01.RDO
Current log# 1 seq# 19009 mem# 1: N:\ORACLE\PRODUCT\11.2.0\ORADATA\WDEGPRO\REDO01_1.RDO
Tue May 13 21:27:37 2014
******************************************************************
LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2
******************************************************************
LNS: Standby redo logfile selected for thread 1 sequence 19009 for destination LOG_ARCHIVE_DEST_2
Tue May 13 21:27:37 2014
Archived Log entry 36429 added for thread 1 sequence 19008 ID 0x36b84d24 dest 1:
Tue May 13 21:54:14 2014
Thread 1 advanced to log sequence 19010 (LGWR switch)
Current log# 2 seq# 19010 mem# 0: M:\ORACLE\PRODUCT\11.2.0\ORADATA\WDEGPRO\REDO02.RDO
Current log# 2 seq# 19010 mem# 1: N:\ORACLE\PRODUCT\11.2.0\ORADATA\WDEGPRO\REDO02_1.RDO
Tue May 13 21:54:15 2014
******************************************************************
LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2
******************************************************************
LNS: Standby redo logfile selected for thread 1 sequence 19010 for destination LOG_ARCHIVE_DEST_2
Tue May 13 21:54:15 2014
Archived Log entry 36431 added for thread 1 sequence 19009 ID 0x36b84d24 dest 1:
=======
both standby and primary db are in maximum performance mode and delay of 180 mins.
db version : 11.2.0.1
i started redo apply in standby using
" alter database recover managed standby database disconnect from session;"
i tried " alter system archive log current" and "alter system switch logfile;" in primary db.
it doesent changes the status of standby redo logfile in standby database;
i tried SELECT GROUP#,THREAD#,SEQUENCE#,ARCHIVED,STATUS FROM V$STANDBY_LOG; ------ in standby db and output is
GROUP# THREAD# SEQUENCE# ARC STATUS
---------- ---------- ---------- --- ----------
7 1 19010 YES ACTIVE
8 0 0 YES UNASSIGNED
9 0 0 YES UNASSIGNED
.. it remains same for multiple thread# (19006 ..... to 19010)
why i am getting this ..
******************************************************************
LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2
******************************************************************
thanks in advance
Regards
Gold