redo log deleted without arhiving yet(Urgent)
Hi, all
I am trying to move redo log file to another disk on sun solaris,
and I accidentally deleted logfile group 3, and I restored database back to last night' backup, but it still complains about the log file redo03.log, saying it needs to be archived. Please advise. Thanks.
D.F.
Oracle 9i, Sun Solaris.
SQL> select group#,sequence#,archived,status from v$log;
GROUP# SEQUENCE# ARC STATUS
---------- ---------- --- ----------------
2 38 NO INACTIVE
3 37 NO INACTIVE
4 39 NO INACTIVE
5 40 NO INVALIDATED
SQL> alter database drop logfile group 3;
alter database drop logfile group 3
*
ERROR at line 1:
ORA-00350: log 3 of thread 1 needs to be archived
ORA-00312: online log 3 thread 1:
'/opt/oracle/OraHome9i/oradata/cncarc/redo03.log'
SQL> alter system archive log all;
alter system archive log all
*
ERROR at line 1:
ORA-16038: log 3 sequence# 37 cannot be archived
ORA-00313: open failed for members of log group of thread
ORA-00312: online log 3 thread 1:
'/opt/oracle/OraHome9i/oradata/cncarc/redo03.log'