WIN2K+ORACLE817 归档方式
ORACLE_SID = ORACLE8
近日发觉ALRT.LOG 中有如下报错信息:
Mon Jun 12 10:56:47 2006
ARC1: Beginning to archive log# 1 seq# 180825
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.
ARC1: Completed archiving log# 1 seq# 180825
Mon Jun 12 10:57:09 2006
Thread 1 advanced to log sequence 180827
Current log# 4 seq# 180827 mem# 0: D:\ORACLE\ORADATA\ORACLE8\REDO04.LOG
Mon Jun 12 10:57:09 2006
ARC0: Beginning to archive log# 6 seq# 180826
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.
ARC0: Completed archiving log# 6 seq# 180826
好像是归档文件格式有问题,初始化文件中归档格式定义如下:
log_archive_format = %%ORACLE_SID%%T%TS%S.ARC
察看了一下数据库中当前的日志情况:
SVRMGR> select group#,thread#,sequence#,members,archived,status from v$log;
GROUP# THREAD# SEQUENCE# MEMBERS ARC STATUS
---------- ---------- ---------- ---------- --- ----------------
1 1 180825 1 YES INACTIVE
2 1 180823 1 YES INACTIVE
3 1 180824 1 YES INACTIVE
4 1 180827 1 NO CURRENT
5 1 180822 1 YES INACTIVE
6 1 180826 1 YES ACTIVE
6
SVRMGR>
又提取了数据库中归档目录下的所生成的归档文件名如下:
ORACLE8T001S80825.ARC
ORACLE8T001S80826.ARC
发觉在归档文件中的文件名中相应序列号中少了最高的一位 1,对log_archive_format 参数也作过更改,去掉T%TS只加%S,但是alrt.log 中报错依旧。
请教各位大师此问题该如何解决?