I'm not going to look into it for time reasons, but will state that the
letters in your archive log format string... probably %S indicate that
you have a 'fixed' length format. This warning apparently has been
around awhile as your sequence # is 230632, and it is warning you that
30632 is about to be overwritten. (and probably doesn't even exist
anymore physically).
The solution would be to use the lower case s (look it up), and allow
for more digits to fit in the archive log file name, (variable length
filename).
Then 230633 will fit.
It is only a warning. If you are aware of what is happening then you
are probably backing up correctly. However, you may also be
overwriting old archives needed for recovery... which oracle is not sure
of but wants to let you know of the situation.
-----Original Message-----
From: Skika Abdelali
[mailto:oracledba-ezmlmshield-x55513016.[Email address protected]
Sent: Monday, January 30, 2006 8:29 AM
To: LazyDBA Discussion
Subject: Error to creat an archivelog file
Hello,
Can some one help me to solve this error!!!
Database mounted in Exclusive Mode.
Completed: alter database mount
Sat Jan 28 00:27:20 2006
alter database open
ARCH: Beginning to archive log# 1 seq# 230632
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.
ARCH: Error 19504 creating archivelog file
'D:\ORACLE\ORADATA\ARCHIVE\C_30632.ARC'
ARCH: Archiving not possible: error count exceeded
ARCH: Failed to archive log# 1 seq# 230632
ORA-16014 signalled during: alter database open ...
Shutting down instance (immediate)
License high water mark = 2
Mon Jan 30 10:19:10 2006
alter database close normal
ORA-1109 signalled during: alter database close normal...
Dump file d:\oracle\admin\bdump\SIDALRT.LOG
I'm using a Win2K server with oracle 8.1.7
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page