Hi all,
I just wanted a little insight on the following entries of my alert log file;
-----------------------------------------------------------------------------------------------------------------------------------
ARC0: Beginning to archive log# 3 seq# 51809
ARC0: Failed to archive log# 3 seq# 51809
Tue Oct 01 09:32:37 2002
ARC4: Beginning to archive log# 3 seq# 51809
ARC4: Failed to archive log# 3 seq# 51809
ARC4: Beginning to archive log# 4 seq# 51810
Tue Oct 01 09:32:37 2002
ARC0: Beginning to archive log# 4 seq# 51810
ARC0: Failed to archive log# 4 seq# 51810
Tue Oct 01 09:32:40 2002
Completed checkpoint up to RBA [0xca62.2.10], SCN: 0x0000.02bfbd05
Tue Oct 01 09:32:41 2002
ARC3: Completed archiving log# 3 seq# 51809
-----------------------------------------------------------------------------------------------------------------------------------
ARC0 failed to archive log seq#51809 at first, then ARC4 tried to archive the same log seq# and it failed again but then the same archiver process (ARC4) started archiving next seq# and failed again. After a few seconds ARC0 successfully archives 51809. Similarly rest of the seq# get archived to after a few tries by one archiver or the other. This behavior is not regular, it appears off and on, most of the times there is no failing, and everything proceeds normally.
I was wondering if any of you can explain the following points to help improve my concepts,
* Is FAILING temporarily any threat?
* What could be the reason for it?
* If the first archiver fails (ARC0) and then the second (ARC4) fails too, why does it try to archive the next seq# rather than finishing the previous one?
* Any reason for this inconsistency?
Thanks & Regards,
Hussain Ahmed Qadri
DBA
SKMCH&RC