-
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
-
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?
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|