Hi All,

I have a Primary database running on 8.1.6 in ARCHIVELOG mode.
There is standby database configured for Primary database.
Primary database has three redo logfile with 2 members each located at different drives size 5mb.
I often get following error while redo logs getting arched [/b] and it terminates instance[/b]

I have marked in bold few lines from my alert log file. This also happens if I manually swith log file.



---------------------------------------------------------------------------------
Thread 1 advanced to log sequence 78
Current log# 3 seq# 78 mem# 0: /data/oradata/ora4/redo03.log
Current log# 3 seq# 78 mem# 1: /opt/oracle/data2/ora4/logfile/redo03m.log
Mon Aug 19 14:53:54 2002
ARC0: Beginning to archive log# 2 seq# 77
ARC0: Completed archiving log# 2 seq# 77
Mon Aug 19 15:09:07 2002
Thread 1 advanced to log sequence 79
Current log# 1 seq# 79 mem# 0: /data/oradata/ora4/redo01.log
Current log# 1 seq# 79 mem# 1: /opt/oracle/data2/ora4/logfile/redo01m.log
Mon Aug 19 15:09:07 2002
ARC0: Beginning to archive log# 3 seq# 78
ARC0: RFS network connection lost at host 'STDB'
ARC0: Error 3113 creating standby archivelog file at host 'STDB'
ARC0: Error 3113 creating archivelog file 'STDB'
ARC0: Failed to archive log# 3 seq# 78
ARCH: Archival stopped, error occurred. Will continue retrying
Mon Aug 19 15:09:08 2002
---------------------------------------------------------------------------------

Archive destination also exists ....

Even if I do bulk which is not so big.. say of 4000 records in one go..
by executing insert into x select * from y .. I get error..

---------------------------------------------------------------------------------
Mon Aug 19 15:09:29 2002
ARC0: Beginning to archive log# 3 seq# 78
ARC0: Archiving not possible: No available destinations
ARC0: Failed to archive log# 3 seq# 78
ARCH: Archival stopped, error occurred. Will continue retrying
Mon Aug 19 15:09:29 2002
ORACLE Instance orcl - Archival Error
ARCH: Connecting to console port...
Mon Aug 19 15:09:29 2002
ORA-16014: log 3 sequence# 78 not archived, no available destinations
ORA-00312: online log 3 thread 1: '/data/oradata/ora4/redo03.log'
ORA-00312: online log 3 thread 1: '/opt/oracle/data2/ora4/logfile/redo03m.log'
ARCH: Connecting to console port...
ARCH:
ORA-16014: log 3 sequence# 78 not archived, no available destinations
ORA-00312: online log 3 thread 1: '/data/oradata/ora4/redo03.log'
ORA-00312: online log 3 thread 1: '/opt/oracle/data2/ora4/logfile/redo03m.log'
Mon Aug 19 15:15:53 2002
ORACLE Instance orcl - Can not allocate log, archival required
Mon Aug 19 15:15:53 2002
ARCH: Connecting to console port...
Thread 1 cannot allocate new log, sequence 81
All online logs needed archiving
Current log# 2 seq# 80 mem# 0: /data/oradata/ora4/redo02.log
Current log# 2 seq# 80 mem# 1: /opt/oracle/data2/ora4/logfile/redo02m.log
Mon Aug 19 15:15:53 2002
ARC0: Beginning to archive log# 3 seq# 78
Mon Aug 19 15:15:54 2002
Errors in file /opt/oracle/data2/ora4/bdump/orcl_arc0_880.trc:
ORA-00600: internal error code, arguments: [kcrrmario.1], [], [], [], [], [], [], []
ARC0: terminating instance due to error 600
Instance terminated by ARC0, pid = 880
Mon Aug 19 15:18:09 2002
---------------------------------------------------------------------------------


Please help me to solve problem.

Thanks

Sameer

[Edited by Sameer on 08-19-2002 at 11:47 AM]