DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: All online logs needed archiving ?

  1. #1
    Join Date
    Sep 2000
    Posts
    103
    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

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828

    Talking

    Hello

    Check the contenst of thsi file for more info
    C:\oracle\admin\ilgcs\bdump\ilgcsALRT.LOG

    regards
    hrishy

  3. #3
    Join Date
    Sep 2000
    Posts
    103
    Hi hrishy,

    But that's the contents of my alert log file. I just cut and pasted it here.

    Thanks
    pst

  4. #4
    Join Date
    Jun 2001
    Location
    Charlotte, NC
    Posts
    27
    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.

  5. #5
    Join Date
    Sep 2000
    Posts
    103

    Question

    My archive dest has over 17GB left. I dont understand why it's happening.

    pst

  6. #6
    Join Date
    Oct 2000
    Location
    Halifax, Nova Scotia
    Posts
    197
    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

  7. #7
    Join Date
    Jun 2001
    Location
    Charlotte, NC
    Posts
    27
    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
  •  


Click Here to Expand Forum to Full Width