| nivedita |
Posted: Jul 04, 2008 03:27:50 AM |
Total Post: 3
Joined: Mar, 2008
|
Hi All,
I am monitoring an 8i database.I saw following lines in my alert log:-
Fri Jul 04 01:36:19 2008
ARC1: Completed archiving log# 3 seq# 118932
ARC1: Beginning to archive log# 4 seq# 118933
Fri Jul 04 01:36:19 2008
kcrrga: Warning. Log sequence in archive filename wrapped
to fix length as indicated by %S in LOG_ARCHIVE_FORMAT.
Old log archive with same name might be overwritten.
Fri Jul 04 01:36:20 2008
ARC0: Beginning to archive log# 4 seq# 118933
Fri Jul 04 01:36:20 2008
ARC0: Failed to archive log# 4 seq# 118933
Fri Jul 04 01:36:20 2008
ARC1: Completed archiving log# 4 seq# 118933
The problem is with the Archiver processes.I wanna know the reason due to which arc0 has started archinving same log and than terminated after knowing that it is already being archived.
The parameter "log_archive_max_processes" has value=1.
Plz if any body knows the exact reason than tell me.
There is also a warning realated to archived files format.%S is used in archived file format which is for fixed lenght.Is it going to overwrite my archived logs soon(i dont think so,i think after 100000 files it will overwrite) as around 60 archived file are generated daily?
If anybody can tell me that i am right or wrong?
Thanks in advance. |
|
|
 Avnish |
| Posted: Jul 07, 2008 02:11:15 AM |  |
|
Total Post: 154
Joined: Dec, 2007
|
Hi
Modify the LOG_ARCHIVE_FORMAT parameter value in your init.ora file to
replace the uppercase %S with a lowercase %s.
Thanks & Regards
Avnish Yadav
|
|
|
|
|
| nivedita |
| Posted: Jul 07, 2008 04:39:31 AM | |
|
Total Post: 3
Joined: Mar, 2008
|
thanx for reply but i've asked for "after how much no of archived logs the name will be repeated??"
hope u'll understand what am asking.
Thanks anyways.
|
|
|
|
|
| Avnish |
| Posted: Jul 07, 2008 07:21:48 AM | |
|
Total Post: 154
Joined: Dec, 2007
|
Hi,
ARCH Process never overwritten archive files with same name again but when your database runing after incompelete recovery than it is trying to write the archive name which is already present in the archive dest
it happens when database is recovered in resetlog mode
and archives start generating from original sequence again
if u use %r with archive format then this problem won't occur.
don't worry about archiver process...as there are many archive processwes ..monitored by log_archive_max_processes for the job
so if one failed thn its not necesasary that Arc0 only wud be used to archive the log.
ITs oracle internal mechanism.
Thanks & Regards
Avnish Yadav
|
|
|
|
|
| nivedita |
| Posted: Jul 08, 2008 06:07:17 AM | |
|
Total Post: 3
Joined: Mar, 2008
|
|
|
|
|
| positive |
| Posted: Jul 09, 2008 11:40:53 AM | |
|
Total Post: 483
Joined: Jun, 2008
|
http://neworacledba.blogspot.com/
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
