-
Hi,
My alert.log file has the following error :
Fri Jul 20 12:41:26 2001
ARC0: Beginning to archive log# 1 seq# 232
kccrsz: expanded controlfile section 11 from 55 to 111 records
requested to grow by 55 record(s); added 4 block(s) of records
ARC0: Completed archiving log# 1 seq# 232
Fri Jul 20 12:41:29 2001
Thread 1 advanced to log sequence 234
Current log# 3 seq# 234 mem# 0: C:\ORACLE\ORADATA\ILGCS\ILGCS_G3_M1.LOG
Current log# 3 seq# 234 mem# 1: D:\ORACLE\ORADATA\ILGCS\ILGCS_G3_M2.LOG
Fri Jul 20 12:41:29 2001
ARC0: Beginning to archive log# 2 seq# 233
ARC0: Completed archiving log# 2 seq# 233
Fri Jul 20 12:42:46 2001
Thread 1 advanced to log sequence 235
Current log# 4 seq# 235 mem# 0: C:\ORACLE\ORADATA\ILGCS\ILGCS_G4_M1.LOG
Current log# 4 seq# 235 mem# 1: D:\ORACLE\ORADATA\ILGCS\ILGCS_G4_M2.LOG
Fri Jul 20 12:42:46 2001
ARC0: Beginning to archive log# 3 seq# 234
Fri Jul 20 12:42:47 2001
Thread 1 advanced to log sequence 236
Current log# 1 seq# 236 mem# 0: C:\ORACLE\ORADATA\ILGCS\ILGCS_G1_M1.LOG
Current log# 1 seq# 236 mem# 1: D:\ORACLE\ORADATA\ILGCS\ILGCS_G1_M2.LOG
Fri Jul 20 12:42:47 2001
ARC1: Beginning to archive log# 3 seq# 234
ARC1: Failed to archive log# 3 seq# 234
ARC1: Beginning to archive log# 4 seq# 235
Fri Jul 20 12:43:12 2001
Thread 1 advanced to log sequence 237
Current log# 2 seq# 237 mem# 0: C:\ORACLE\ORADATA\ILGCS\ILGCS_G2_M1.LOG
Current log# 2 seq# 237 mem# 1: D:\ORACLE\ORADATA\ILGCS\ILGCS_G2_M2.LOG
Thread 1 cannot allocate new log, sequence 238
All online logs needed archiving
Current log# 2 seq# 237 mem# 0: C:\ORACLE\ORADATA\ILGCS\ILGCS_G2_M1.LOG
Current log# 2 seq# 237 mem# 1: D:\ORACLE\ORADATA\ILGCS\ILGCS_G2_M2.LOG
Fri Jul 20 12:43:34 2001
PMON: terminating instance due to error 473
Instance terminated by PMON, pid = 1576
Dump file C:\oracle\admin\ilgcs\bdump\ilgcsALRT.LOG
I get the end of communication channel error.
Can you tell me why this is happening ?
Thanks a lot
pst
-
Hello
Check the contenst of thsi file for more info
C:\oracle\admin\ilgcs\bdump\ilgcsALRT.LOG
regards
hrishy
-
Hi hrishy,
But that's the contents of my alert log file. I just cut and pasted it here.
Thanks
pst
-
Originally posted by pst
Hi,
My alert.log file has the following error :
Fri Jul 20 12:41:26 2001
ARC0: Beginning to archive log# 1 seq# 232
kccrsz: expanded controlfile section 11 from 55 to 111 records
requested to grow by 55 record(s); added 4 block(s) of records
ARC0: Completed archiving log# 1 seq# 232
Fri Jul 20 12:41:29 2001
Thread 1 advanced to log sequence 234
Current log# 3 seq# 234 mem# 0: C:\ORACLE\ORADATA\ILGCS\ILGCS_G3_M1.LOG
Current log# 3 seq# 234 mem# 1: D:\ORACLE\ORADATA\ILGCS\ILGCS_G3_M2.LOG
Fri Jul 20 12:41:29 2001
ARC0: Beginning to archive log# 2 seq# 233
ARC0: Completed archiving log# 2 seq# 233
Fri Jul 20 12:42:46 2001
Thread 1 advanced to log sequence 235
Current log# 4 seq# 235 mem# 0: C:\ORACLE\ORADATA\ILGCS\ILGCS_G4_M1.LOG
Current log# 4 seq# 235 mem# 1: D:\ORACLE\ORADATA\ILGCS\ILGCS_G4_M2.LOG
Fri Jul 20 12:42:46 2001
ARC0: Beginning to archive log# 3 seq# 234
Fri Jul 20 12:42:47 2001
Thread 1 advanced to log sequence 236
Current log# 1 seq# 236 mem# 0: C:\ORACLE\ORADATA\ILGCS\ILGCS_G1_M1.LOG
Current log# 1 seq# 236 mem# 1: D:\ORACLE\ORADATA\ILGCS\ILGCS_G1_M2.LOG
Fri Jul 20 12:42:47 2001
ARC1: Beginning to archive log# 3 seq# 234
ARC1: Failed to archive log# 3 seq# 234
ARC1: Beginning to archive log# 4 seq# 235
Fri Jul 20 12:43:12 2001
Thread 1 advanced to log sequence 237
Current log# 2 seq# 237 mem# 0: C:\ORACLE\ORADATA\ILGCS\ILGCS_G2_M1.LOG
Current log# 2 seq# 237 mem# 1: D:\ORACLE\ORADATA\ILGCS\ILGCS_G2_M2.LOG
Thread 1 cannot allocate new log, sequence 238
All online logs needed archiving
Current log# 2 seq# 237 mem# 0: C:\ORACLE\ORADATA\ILGCS\ILGCS_G2_M1.LOG
Current log# 2 seq# 237 mem# 1: D:\ORACLE\ORADATA\ILGCS\ILGCS_G2_M2.LOG
Fri Jul 20 12:43:34 2001
PMON: terminating instance due to error 473
Instance terminated by PMON, pid = 1576
Dump file C:\oracle\admin\ilgcs\bdump\ilgcsALRT.LOG
I get the end of communication channel error.
Can you tell me why this is happening ?
Thanks a lot
pst
Your archive log destination has filled up. You need to backup the archive log files to a new location and then remove the archive log files which have been backed up from the archive log destination.
-
My archive dest has over 17GB left. I dont understand why it's happening.
pst
-
Has your archiving process stopped for some reason.
In Server Manager type
ARCHIVE LOG LIST
this will show you if you auto acrhiving is still enable
If it is not type
ARCHIVE LOG START
Don't be afraid to try something new. Amateurs built the Ark, professionals built the Titanic
-
Originally posted by pst
Hi,
My alert.log file has the following error :
Fri Jul 20 12:41:26 2001
ARC0: Beginning to archive log# 1 seq# 232
kccrsz: expanded controlfile section 11 from 55 to 111 records
requested to grow by 55 record(s); added 4 block(s) of records
ARC0: Completed archiving log# 1 seq# 232
Fri Jul 20 12:41:29 2001
Thread 1 advanced to log sequence 234
Current log# 3 seq# 234 mem# 0: C:\ORACLE\ORADATA\ILGCS\ILGCS_G3_M1.LOG
Current log# 3 seq# 234 mem# 1: D:\ORACLE\ORADATA\ILGCS\ILGCS_G3_M2.LOG
Fri Jul 20 12:41:29 2001
ARC0: Beginning to archive log# 2 seq# 233
ARC0: Completed archiving log# 2 seq# 233
Fri Jul 20 12:42:46 2001
Thread 1 advanced to log sequence 235
Current log# 4 seq# 235 mem# 0: C:\ORACLE\ORADATA\ILGCS\ILGCS_G4_M1.LOG
Current log# 4 seq# 235 mem# 1: D:\ORACLE\ORADATA\ILGCS\ILGCS_G4_M2.LOG
Fri Jul 20 12:42:46 2001
ARC0: Beginning to archive log# 3 seq# 234
Fri Jul 20 12:42:47 2001
Thread 1 advanced to log sequence 236
Current log# 1 seq# 236 mem# 0: C:\ORACLE\ORADATA\ILGCS\ILGCS_G1_M1.LOG
Current log# 1 seq# 236 mem# 1: D:\ORACLE\ORADATA\ILGCS\ILGCS_G1_M2.LOG
Fri Jul 20 12:42:47 2001
ARC1: Beginning to archive log# 3 seq# 234
ARC1: Failed to archive log# 3 seq# 234
ARC1: Beginning to archive log# 4 seq# 235
Fri Jul 20 12:43:12 2001
Thread 1 advanced to log sequence 237
Current log# 2 seq# 237 mem# 0: C:\ORACLE\ORADATA\ILGCS\ILGCS_G2_M1.LOG
Current log# 2 seq# 237 mem# 1: D:\ORACLE\ORADATA\ILGCS\ILGCS_G2_M2.LOG
Thread 1 cannot allocate new log, sequence 238
All online logs needed archiving
Current log# 2 seq# 237 mem# 0: C:\ORACLE\ORADATA\ILGCS\ILGCS_G2_M1.LOG
Current log# 2 seq# 237 mem# 1: D:\ORACLE\ORADATA\ILGCS\ILGCS_G2_M2.LOG
Fri Jul 20 12:43:34 2001
PMON: terminating instance due to error 473
Instance terminated by PMON, pid = 1576
Dump file C:\oracle\admin\ilgcs\bdump\ilgcsALRT.LOG
I get the end of communication channel error.
Can you tell me why this is happening ?
Thanks a lot
pst
Was a big transaction being performed at the time you received this error message? Also this error usually occurs when your online redo logs are to small. The problem is caused because the log writer process is trying to write to one of the online redo logs which has not completed the process of being archived. The best resoultion is to either increase the size of your online redo logs are add more redo log groups. You could also manually archive the logs by using the command archive log all and also check and make sure that archive_log_start is set to true in the init file.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|