Dear All,

O.S.: Windows 2000 Server

Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production

I have a Dataguard Setup with managed recovery.

Yesterday i got the below error in alert.log of Primary:

Creating archive destination LOG_ARCHIVE_DEST_2: 'fnostby'
Creating archive destination LOG_ARCHIVE_DEST_1: 'F:\ORACLE\ORADATA\FNO\ARCH\LOG_114727.ARC'
Wed Oct 18 17:52:10 2006
ARC4: Completed archiving log 4 thread 1 sequence 14724
ARC4: Evaluating archive log 5 thread 1 sequence 14725
ARC4: Unable to archive log 5 thread 1 sequence 14725
Log actively being archived by another process
ARC4: Evaluating archive log 1 thread 1 sequence 14726
ARC4: Unable to archive log 1 thread 1 sequence 14726
Log actively being archived by another process
ARC4: Evaluating archive log 2 thread 1 sequence 14727
ARC4: Unable to archive log 2 thread 1 sequence 14727
Log actively being archived by another process
ARC4: Evaluating archive log 5 thread 1 sequence 14725
ARC4: Unable to archive log 5 thread 1 sequence 14725
Log actively being archived by another process
ARC4: Evaluating archive log 1 thread 1 sequence 14726
ARC4: Unable to archive log 1 thread 1 sequence 14726
Log actively being archived by another process
ARC4: Evaluating archive log 2 thread 1 sequence 14727
ARC4: Unable to archive log 2 thread 1 sequence 14727
Log actively being archived by another process
Wed Oct 18 17:53:26 2006
ARC3: I/O error 3114 archiving log 5 to 'fnostby'
Wed Oct 18 17:53:26 2006
Errors in file e:\oracle\admin\fno\bdump\fno_arc3_1964.trc:
ORA-03114: not connected to ORACLE

ARC3: Completed archiving log 5 thread 1 sequence 14725
ARC3: Evaluating archive log 1 thread 1 sequence 14726
ARC3: Unable to archive log 1 thread 1 sequence 14726
Log actively being archived by another process



ARC4: I/O error 3115 archiving log 4 to 'fnostby'
Thu Oct 26 17:12:18 2006
Errors in file e:\oracle\admin\fno\bdump\fno_arc4_1952.trc:
ORA-03115: unsupported network datatype or representation


ARC4: Evaluating archive log 2 thread 1 sequence 14962
ARC4: Beginning to archive log 2 thread 1 sequence 14962
Creating archive destination LOG_ARCHIVE_DEST_2: 'fnostby'
Thu Oct 26 17:17:19 2006
LGWR: Detected ARCH process failure
LGWR: Detected ARCH process failure
LGWR: STARTING ARCH PROCESSES
Thu Oct 26 17:17:19 2006
ARC2: Evaluating archive log 1 thread 1 sequence 14960
ARC2: Unable to archive log 1 thread 1 sequence 14960
Log actively being archived by another process
ARC2: Evaluating archive log 5 thread 1 sequence 14961
ARC2: Unable to archive log 5 thread 1 sequence 14961
Log actively being archived by another process


After which the Log shipping stopped to the Standby Location and archives are not generated on the Primary Site Also.

However after i cancel the managed recovery on STandby database and defer the log_archive_dest_state_2 on primary database, it starts generating archives on primary.

Please advise as to how to got about resolving this issue, so that things return to normal state.