-
Hi
in my alert log file i m getting this error.
ARC0: Failed to archive log# 12 seq# 22410
later this gets archived..
full text is as below :
Wed Nov 07 10:23:43 2001
Beginning log switch checkpoint up to RBA [0x578b.2.10], SCN: 0x0000.01effd03
Wed Nov 07 10:23:43 2001
Thread 1 advanced to log sequence 22411
Wed Nov 07 10:23:43 2001
ARC1: Beginning to archive log# 12 seq# 22410
Wed Nov 07 10:23:43 2001
Current log# 13 seq# 22411 mem# 0: J:\ORACLE\P62\ORIGLOGA\LOG_G13M1.DBF
Current log# 13 seq# 22411 mem# 1: K:\ORACLE\P62\MIRRLOGA\LOG_G13M2.DBF
Wed Nov 07 10:23:44 2001
ARC0: Beginning to archive log# 12 seq# 22410
Wed Nov 07 10:23:44 2001
ARC0: Failed to archive log# 12 seq# 22410
Wed Nov 07 10:23:46 2001
Completed checkpoint up to RBA [0x578a.2.10], SCN: 0x0000.01effc62
Wed Nov 07 10:24:00 2001
ARC1: Completed archiving log# 12 seq# 22410
Tell me what could be the reason..
--------------------------
The Time has come ....
-
well..chk under bkground dump directory for ARC0 text dump...it shld tell u somethg..
how many archive destination u configured?
ngwh,
Singapore.
-
destinations
ok, i will check that and revert.
i hv only one destination where the files are archived.
--------------------------
The Time has come ....
-
after checking
hey,
i checked it but no trace file is generated for this.
NOW WHAT ?
this is happening today again. i saw the alert file.
--------------------------
The Time has come ....
-
your posting from alert log is not that concise, it only shows the log # 12 which is used by ARCH process and log # 13 which is your current redo log.
You need to post at least from log sequence 10 up to log seq 15. For us to see how fast your log switches occurred and how many redo logs you have in your system, etc.
Anyway do you at least 3 redo logs?
Does your redo logs have enough size in order not have a frequent log switches?
Have you set your LOG_CHECKPOINT_INTERVAL much less than the size of your redo logs?
Or you have used time-based interval(using LOG_CHECKPOINT_TIMEOUT other than zero)?
-
please also post your parameter settings for anything relating to udump, bdump destinations and archive log formats/destinations.
thanks,
Magnus
-
Config
Hi,
My config is as below :
4 log groups of 2 files each
logfile size 20mb
LOG_CHECKPOINT_INTERVAL = 300000
OS Block Size = 512
(I found this from LEBSZ col in x$kccle.
now my 300000 * 512 > 20 mb.
more detailed log is as below :
ARC1: Beginning to archive log# 14 seq# 22632
Thread 1 advanced to log sequence 22633
Fri Nov 09 03:02:37 2001
Current log# 11 seq# 22633 mem# 0: J:\ORACLE\P62\ORIGLOGA\LOG_G11M1.DBF
Current log# 11 seq# 22633 mem# 1: K:\ORACLE\P62\MIRRLOGA\LOG_G11M2.DBF
Fri Nov 09 03:02:58 2001
ARC1: Completed archiving log# 14 seq# 22632
Fri Nov 09 03:02:58 2001
ARC0: Beginning to archive log# 11 seq# 22633
Fri Nov 09 03:02:59 2001
Beginning log switch checkpoint up to RBA [0x586a.2.10], SCN: 0x0000.01f4ec45
Fri Nov 09 03:02:59 2001
Thread 1 advanced to log sequence 22634
Fri Nov 09 03:02:59 2001
ARC1: Beginning to archive log# 11 seq# 22633
Fri Nov 09 03:02:59 2001
Current log# 12 seq# 22634 mem# 0: K:\ORACLE\P62\ORIGLOGB\LOG_G12M1.DBF
ARC1: Failed to archive log# 11 seq# 22633
Current log# 12 seq# 22634 mem# 1: J:\ORACLE\P62\MIRRLOGB\LOG_G12M2.DBF
Fri Nov 09 03:03:01 2001
ARC0: Completed archiving log# 11 seq# 22633
Fri Nov 09 03:03:01 2001
Completed checkpoint up to RBA [0x5869.2.10], SCN: 0x0000.01f4eac0
Fri Nov 09 03:03:17 2001
Completed checkpoint up to RBA [0x586a.2.10], SCN: 0x0000.01f4ec45
Fri Nov 09 03:03:29 2001
Beginning log switch checkpoint up to RBA [0x586b.2.10], SCN: 0x0000.01f4ed9e
Thread 1 advanced to log sequence 22635
Fri Nov 09 03:03:29 2001
ARC1: Beginning to archive log# 12 seq# 22634
Fri Nov 09 03:03:29 2001
Current log# 13 seq# 22635 mem# 0: J:\ORACLE\P62\ORIGLOGA\LOG_G13M1.DBF
Current log# 13 seq# 22635 mem# 1: K:\ORACLE\P62\MIRRLOGA\LOG_G13M2.DBF
Fri Nov 09 03:03:31 2001
ARC1: Completed archiving log# 12 seq# 22634
Fri Nov 09 03:03:51 2001
Beginning log switch checkpoint up to RBA [0x586c.2.10], SCN: 0x0000.01f4eef6
Thread 1 advanced to log sequence 22636
Fri Nov 09 03:03:51 2001
Current log# 14 seq# 22636 mem# 0: K:\ORACLE\P62\ORIGLOGB\LOG_G14M1.DBF
Current log# 14 seq# 22636 mem# 1: J:\ORACLE\P62\MIRRLOGB\LOG_G14M2.DBF
Fri Nov 09 03:03:52 2001
ARC1: Beginning to archive log# 13 seq# 22635
Fri Nov 09 03:03:54 2001
Completed checkpoint up to RBA [0x586b.2.10], SCN: 0x0000.01f4ed9e
Fri Nov 09 03:04:15 2001
ARC1: Completed archiving log# 13 seq# 22635
Fri Nov 09 03:04:15 2001
Beginning log switch checkpoint up to RBA [0x586d.2.10], SCN: 0x0000.01f4f031
Fri Nov 09 03:04:15 2001
ARC0: Beginning to archive log# 14 seq# 22636
Fri Nov 09 03:04:15 2001
Thread 1 advanced to log sequence 22637
Fri Nov 09 03:04:15 2001
ARC1: Beginning to archive log# 14 seq# 22636
ARC1: Failed to archive log# 14 seq# 22636
Fri Nov 09 03:04:15 2001
Current log# 11 seq# 22637 mem# 0: J:\ORACLE\P62\ORIGLOGA\LOG_G11M1.DBF
Current log# 11 seq# 22637 mem# 1: K:\ORACLE\P62\MIRRLOGA\LOG_G11M2.DBF
Fri Nov 09 03:04:17 2001
ARC0: Completed archiving log# 14 seq# 22636
Fri Nov 09 03:04:18 2001
Completed checkpoint up to RBA [0x586c.2.10], SCN: 0x0000.01f4eef6
Fri Nov 09 03:04:36 2001
Completed checkpoint up to RBA [0x586d.2.10], SCN: 0x0000.01f4f031
Fri Nov 09 03:04:36 2001
Beginning log switch checkpoint up to RBA [0x586e.2.10], SCN: 0x0000.01f4f241
Fri Nov 09 03:04:36 2001
ARC1: Beginning to archive log# 11 seq# 22637
Thread 1 advanced to log sequence 22638
Fri Nov 09 03:04:37 2001
Current log# 12 seq# 22638 mem# 0: K:\ORACLE\P62\ORIGLOGB\LOG_G12M1.DBF
Current log# 12 seq# 22638 mem# 1: J:\ORACLE\P62\MIRRLOGB\LOG_G12M2.DBF
Fri Nov 09 03:04:51 2001
ARC1: Completed archiving log# 11 seq# 22637
IMP : sometimes i m getting checkpoint not completed error also.
help me !!!
--------------------------
The Time has come ....
-
vijay8282
I thought I answered your question regarding this in another thread? What is the problem now?
-
why i m posting here
Hi Pando,
yes u answered at another thread. actually i started both threads at the same time. so if someone is asking for details in a thread i need to reply.
moreover as i cannot shutdown my server immediately i m trying to gather as much info as i can.
i am posting for no other reson. as u know v hv to take lot of precautions while doing anything on prod server.
thanks for all ur help. i hope u won't mind.
--------------------------
The Time has come ....
-
i dont mind but everyone is gonna tell you the samething anywayz
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
|