Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> redolog file missing
Hello All
By mistake I deleted REDO02.LOG and REDO03.LOG from
%OracleHome\oradata\"database" director REDO01.LOG is still there.
I cannot start the database. The error I get is
ORA-00313 Open failed for members of log group 2 of thread 1
ORA-00312 online log2 thread 1 '%OracleHome\oradata\"database"\redo02.log
what I did
1)startup mount
2)Check the active log file
SELECT GROUP#, ARCHIVED, STATUS FROM V$LOG;
But when I am trying to do
alter system switch logfile;
I have the following error message:
ORA-01109:database not opened
thanks
Received on Wed Feb 11 2004 - 15:54:19 CST