missing archive log file
405935Oct 8 2003 — edited Oct 8 2003After "shutdown abort" and startup of one oracle instance, it looks like an archive log file is missing. While I was looking around, I found that v$log showed "ARCHIVED='YES'", even though there was no archive1_347.dbf file. Since then, update activity caused a log switch, so I suspect that the missing log file is "permanently missing". Is there something I could have done to force oracle to archive sequence# 347 while the data was still in redo01.log?
rac1> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
1 1 347 104857600 1 YES INACTIVE 80328768 08-OCT-03
2 1 348 104857600 1 NO CURRENT 80373600 08-OCT-03
3 2 199 104857600 1 NO CURRENT 80373522 08-OCT-03
4 2 198 104857600 1 YES INACTIVE 80341886 08-OCT-03
rac1> select * from v$logfile;
GROUP# STATUS TYPE MEMBER
---------- ------- ------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1 STALE ONLINE /ora920rac/data/rac/redo01.log
2 ONLINE /ora920rac/data/rac/redo02.log
3 ONLINE /ora920rac/data/rac/redo03.log
4 ONLINE /ora920rac/data/rac/rac_redo2_2.log
rac1> alter system archive log sequence 347;
alter system archive log sequence 347
*
ERROR at line 1:
ORA-16013: log 1 sequence# 347 does not need archiving
ORA-00312: online log 1 thread 1: '/ora920rac/data/rac/redo01.log'
rac1> select * from v$logfile;
GROUP# STATUS TYPE MEMBER
------ ------ ------ -------
1 STALE ONLINE /ora920rac/data/rac/redo01.log
2 ONLINE /ora920rac/data/rac/redo02.log
3 ONLINE /ora920rac/data/rac/redo03.log
4 ONLINE /ora920rac/data/rac/rac_redo2_2.log
rac1> alter system archive log sequence 347;
alter system archive log sequence 347
*
ERROR at line 1:
ORA-16013: log 1 sequence# 347 does not need archiving
ORA-00312: online log 1 thread 1: '/ora920rac/data/rac/redo01.log'
% ls -l /rdbms/ora920/oradata/rac/
total 235624
drwxr-xr-x 2 ora920 dba 8192 Oct 8 09:59 ./
drwxr-xr-x 3 ora920 dba 4096 Feb 13 2003 ../
-rw-r----- 1 ora920 dba 100081152 Oct 6 16:23 archive1_344.dbf
-rw-r----- 1 ora920 dba 104857088 Oct 8 08:15 archive1_345.dbf
-rw-r----- 1 ora920 dba 35637760 Oct 8 08:44 archive1_346.dbf
-rw-r----- 1 ora920 dba 431104 Oct 8 09:59 archive1_348.dbf