Dear All,

I experienced a strange situation with my database not showing the archiving of the log files in my alert log. The reason precisely was because one of the drives did not have any space in it (in which archived log files were written). With archivelogs multiplexing in place, presuming that since the log files were written in two places, the database did not hang. As there were no entries in the alert log since the drive ran out of space, I wanted to give the command 'alter system archive log all' to ensure that all the files were archived and Oracle gave the message that all the files have been archived(ora-00272). Then I proceeded further by giving the command 'alter system archive log current'. Now after this command, Oracle gave an entry in the alert log for the archiving of the current log file. Now I would like to know if someone else has faced this situation and if I should bother about the missing entries in the alert log for the files that Oracle says has been archived.

Regards,

K.Diwakar


Pasting a portion of the alert log with the missing entries


Sat Sep 07 01:06:03 2002
Thread 1 advanced to log sequence 1622
Current log# 6 seq# 1622 mem# 0: D:\ORACLE\ORADATA\DSM2\REDO06.LOG
Sat Sep 07 01:06:03 2002
ARC0: Beginning to archive log# 1 seq# 1621
ARC0: Completed archiving log# 1 seq# 1621
Sat Sep 07 06:03:08 2002
Thread 1 advanced to log sequence 1623
Current log# 7 seq# 1623 mem# 0: D:\ORACLE\ORADATA\DSM2\REDO07.LOG
Sat Sep 07 06:03:08 2002
ARC0: Beginning to archive log# 6 seq# 1622
ARC0: Completed archiving log# 6 seq# 1622
Sat Sep 07 08:39:29 2002








Mon Sep 09 15:15:28 2002
Thread 1 advanced to log sequence 1642
Current log# 1 seq# 1642 mem# 0: D:\ORACLE\ORADATA\DSM2\REDO03.LOG
Mon Sep 09 15:15:28 2002
ARCH: Beginning to archive log# 5 seq# 1641
Mon Sep 09 15:15:28 2002