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

Thread: archive message in alert_log

  1. #1
    Join Date
    Nov 2000
    Posts
    440

    archive message in alert_log

    On one of my database, i have the following info when a archive log is created:


    Thu Feb 1 08:47:41 2007
    ARC1: Creating local archive destination LOG_ARCHIVE_DEST_1: '/OraArch1/0000083462_0001_558637064.arc' (thread 1 sequence 83462)
    (crn_prod)
    ARCH: Connecting to console port...
    Thu Feb 1 08:47:45 2007
    ARC1: Closing local archive destination LOG_ARCHIVE_DEST_1: '/OraArch1/0000083462_0001_558637064.arc'
    (crn_prod)
    ARCH: Connecting to console port...
    Committing creation of archivelog '/OraArch1/0000083462_0001_558637064.arc'


    Why all this info?
    Is this a auditing feature?
    I have difficulty spotting real errors because i have too much lines concerning archive log generation.

    How to get back to normal message will having a archive log creation?

    Here is a good archive log creation message on another off my database:

    Thu Feb 1 09:37:34 2007
    Thread 1 advanced to log sequence 77705
    Current log# 1 seq# 77705 mem# 0: /OraData1/oradata/juk_prod/redo1.log
    Current log# 1 seq# 77705 mem# 1: /OraData2/oradata/juk_prod/redo1.log

  2. #2
    Join Date
    Jun 2006
    Location
    Chennai, INDIA
    Posts
    72
    Hi,
    could u see any msgs like cannot allocate new log or checkpoint issues in you alert file? Is this archiving manual? Is it possible for you to post next some more lines of the message from alert file?

  3. #3
    Join Date
    Nov 2000
    Posts
    440


    Fri Feb 2 08:21:23 2007
    ARC1: Closing local archive destination LOG_ARCHIVE_DEST_1: '/OraArch1/0000083596_0001_558637064.arc'
    (crn_prod)
    ARCH: Connecting to console port...
    Committing creation of archivelog '/OraArch1/0000083596_0001_558637064.arc'
    Fri Feb 2 08:21:26 2007
    ARC1: Completed archiving thread 1 sequence 83596 (10488627305-10488740748) (crn_prod)
    ARCH: Connecting to console port...
    Fri Feb 2 08:28:08 2007
    Private_strands 18 at log switch
    Thread 1 advanced to log sequence 83598
    Current log# 4 seq# 83598 mem# 0: /OraData1/oradata/crn_prod/redo4.log
    Current log# 4 seq# 83598 mem# 1: /OraData2/oradata/crn_prod/redo4.log
    Fri Feb 2 08:28:08 2007
    ARC1: Evaluating archive thread 1 sequence 83597
    Fri Feb 2 08:28:08 2007
    ARC1: Beginning to archive thread 1 sequence 83597 (10488740748-10488824520) (crn_prod)
    ARCH: Connecting to console port...
    Fri Feb 2 08:28:08 2007
    ARC1: Creating local archive destination LOG_ARCHIVE_DEST_1: '/OraArch1/0000083597_0001_558637064.arc' (thread 1 sequence 83597)
    (crn_prod)
    ARCH: Connecting to console port...
    Fri Feb 2 08:28:12 2007
    ARC1: Closing local archive destination LOG_ARCHIVE_DEST_1: '/OraArch1/0000083597_0001_558637064.arc'
    (crn_prod)
    ARCH: Connecting to console port...
    Committing creation of archivelog '/OraArch1/0000083597_0001_558637064.arc'
    Fri Feb 2 08:28:14 2007
    ARC1: Completed archiving thread 1 sequence 83597 (10488740748-10488824520) (crn_prod)
    ARCH: Connecting to console port...
    Fri Feb 2 08:35:55 2007
    Private_strands 18 at log switch
    Thread 1 advanced to log sequence 83599
    Current log# 2 seq# 83599 mem# 0: /OraData1/oradata/crn_prod/redo2.log
    Current log# 2 seq# 83599 mem# 1: /OraData2/oradata/crn_prod/redo2.log
    Fri Feb 2 08:35:55 2007
    ARC1: Evaluating archive thread 1 sequence 83598
    Fri Feb 2 08:35:55 2007
    ARC1: Beginning to archive thread 1 sequence 83598 (10488824520-10489087706) (crn_prod)
    ARCH: Connecting to console port...
    Fri Feb 2 08:35:55 2007
    ARC1: Creating local archive destination LOG_ARCHIVE_DEST_1: '/OraArch1/0000083598_0001_558637064.arc' (thread 1 sequence 83598)
    (crn_prod)
    ARCH: Connecting to console port...
    Fri Feb 2 08:35:59 2007
    ARC1: Closing local archive destination LOG_ARCHIVE_DEST_1: '/OraArch1/0000083598_0001_558637064.arc'
    (crn_prod)
    ARCH: Connecting to console port...
    Committing creation of archivelog '/OraArch1/0000083598_0001_558637064.arc'


    I have archive log:

    -rw-r----- 1 oinstall 103133696 Feb 2 07:45 0000083591_0001_558637064.arc
    -rw-r----- 1 oinstall 103137792 Feb 2 07:51 0000083592_0001_558637064.arc
    -rw-r----- 1 oinstall 103133696 Feb 2 08:01 0000083593_0001_558637064.arc
    -rw-r----- 1 oinstall 103133696 Feb 2 08:09 0000083594_0001_558637064.arc
    -rw-r----- 1 oinstall 103133696 Feb 2 08:15 0000083595_0001_558637064.arc
    -rw-r----- 1 oinstall 103133696 Feb 2 08:21 0000083596_0001_558637064.arc
    -rw-r----- 1 oinstall 103133696 Feb 2 08:28 0000083597_0001_558637064.arc
    -rw-r----- 1 oinstall 103133696 Feb 2 08:35 0000083598_0001_558637064.arc
    drwxr-xr-x 8 oinstall 49152 Feb 2 08:45 ./
    -rw-r----- 1 oinstall 103133696 Feb 2 08:45 0000083599_0001_558637064.arc



    It is very difficult to read the alert file because of those log messages, usualy it look like this:

    Fri Feb 2 07:50:15 2007
    Thread 1 advanced to log sequence 77873
    Current log# 1 seq# 77873 mem# 0: /OraData1/oradata/juk_prod/redo1.log
    Current log# 1 seq# 77873 mem# 1: /OraData2/oradata/juk_prod/redo1.log
    Fri Feb 2 08:00:42 2007
    Thread 1 cannot allocate new log, sequence 77874
    Private strand flush not complete
    Current log# 1 seq# 77873 mem# 0: /OraData1/oradata/juk_prod/redo1.log
    Current log# 1 seq# 77873 mem# 1: /OraData2/oradata/juk_prod/redo1.log
    Thread 1 advanced to log sequence 77874
    Current log# 2 seq# 77874 mem# 0: /OraData1/oradata/juk_prod/redo2.log
    Current log# 2 seq# 77874 mem# 1: /OraData2/oradata/juk_prod/redo2.log
    Fri Feb 2 08:11:56 2007
    Thread 1 advanced to log sequence 77875
    Current log# 3 seq# 77875 mem# 0: /OraData1/oradata/juk_prod/redo3.log
    Current log# 3 seq# 77875 mem# 1: /OraData2/oradata/juk_prod/redo3.log
    Fri Feb 2 08:17:36 2007
    Thread 1 advanced to log sequence 77876
    Current log# 4 seq# 77876 mem# 0: /OraData1/oradata/juk_prod/redo4.log
    Current log# 4 seq# 77876 mem# 1: /OraData2/oradata/juk_prod/redo4.log
    Fri Feb 2 08:30:55 2007
    Thread 1 advanced to log sequence 77877
    Current log# 5 seq# 77877 mem# 0: /OraData1/oradata/juk_prod/redo5.log
    Current log# 5 seq# 77877 mem# 1: /OraData2/oradata/juk_prod/redo5.log
    Fri Feb 2 08:34:31 2007
    Thread 1 advanced to log sequence 77878
    Current log# 6 seq# 77878 mem# 0: /OraData1/oradata/juk_prod/redo6.log
    Current log# 6 seq# 77878 mem# 1: /OraData2/oradata/juk_prod/redo6.log
    Fri Feb 2 08:45:31 2007
    Thread 1 advanced to log sequence 77879
    Current log# 7 seq# 77879 mem# 0: /OraData1/oradata/juk_prod/redo7.log
    Current log# 7 seq# 77879 mem# 1: /OraData2/oradata/juk_prod/redo7.log

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