-
automatic archive failed
hi all,
My Database(8.1.7.4/win 2000) is in auto archive log mode and will just periodically stop.Logs have to be manually archived and shutdown database reenable auto archiving of logs.
Current Settings:
log_archive_dest = e:\oraarch\bp000000
log_archive_format = "ARCH%S.arc"
log_archive_start = true
SVRMGR> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination e:\oraarch\bp000000
Oldest online log sequence 13557
Next log sequence to archive 13558
Current log sequence 13559
My Alert.log file
================
Sun Oct 15 09:25:18 2006
Thread 1 advanced to log sequence 13552
Current log# 1 seq# 13552 mem# 0: D:\ORADATA\BP000000\REDO01A.ORA
Current log# 1 seq# 13552 mem# 1: E:\ORADATA\BP000000\REDO01B.ORA
Sun Oct 15 15:32:44 2006
Thread 1 advanced to log sequence 13553
Current log# 2 seq# 13553 mem# 0: D:\ORADATA\BP000000\REDO02A.ORA
Current log# 2 seq# 13553 mem# 1: E:\ORADATA\BP000000\REDO02B.ORA
Sun Oct 15 21:13:16 2006
Thread 1 cannot allocate new log, sequence 13554
All online logs needed archiving
Current log# 2 seq# 13553 mem# 0: D:\ORADATA\BP000000\REDO02A.ORA
Current log# 2 seq# 13553 mem# 1: E:\ORADATA\BP000000\REDO02B.ORA
Mon Oct 16 09:03:43 2006
Plese give some workaround.how to recover from this problem.
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
|