?
Solved

Erased REDO01.LOG and REDO03.LOG by mistake!

Posted on 2004-10-20
3
Medium Priority
?
1,671 Views
Last Modified: 2008-07-28
Please, help me.
I use Oracle 9.2 and don't find svrmgr utility

By mistake, I erased these two files:
E:\ORACLE\ORADATA\OEA1\REDO01.LOG
E:\ORACLE\ORADATA\OEA1\REDO03.LOG

But E:\ORACLE\ORADATA\OEA1\REDO02.LOG is still there.

Now I have an error on Oracle when trying to connect as any user:
ORA-01033: ORACLE initialization or shutdown in progress

I checked on
<OracleBase>\admin\<OracleSID>\bdump\alert<ORacleSID>.log

And it says:

Wed Oct 20 12:20:59 2004
Errors in file e:\oracle\admin\oea1\bdump\oea1_lgwr_3328.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'E:\ORACLE\ORADATA\OEA1\REDO01.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

ORA-313 signalled during: alter database open...

What can I do? I can't recuperate REDO01.LOG or REDO03.LOG and don' like to re-install Oracle again...
Please, help!
0
Comment
Question by:Rosa2003
3 Comments
 
LVL 23

Assisted Solution

by:paquicuba
paquicuba earned 1000 total points
ID: 12361648
ALTER DATABASE ADD LOGFILE GROUP 1
( ‘D:\oracle\oradata\target\redo01.log’ ) size 500k;

If you want to recover the information you must perform an incomplete recovery
0
 
LVL 78

Accepted Solution

by:
slightwv (䄆 Netminder) earned 1000 total points
ID: 12361741
first:  a re-install of oracle is not necessary. just possible drop and recreate of the database.

second svrmgr no longer exists.  use: sqlplus /nolog

perform the following:

connect / as sysdba
startup mount
select * from v$log;

--look for which one marked 'current'
--hopfully it will be #2

if #2 is current:
  alter database drop logfile group <remaining groups>;
then as paquicuba, just re-add them

if #1 or #3 was current, then an incomplete recovery is needed.

0
 
LVL 1

Author Comment

by:Rosa2003
ID: 12361991
Thank you very much. That's what I did (and worked!):

sqlplus /nolog
connect / as sysdba
alter database drop logfile group 1;
ALTER DATABASE ADD LOGFILE GROUP 1 ( ‘E:\oracle\oradata\oea1\redo01.log’ ) size 500k;

0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses
Course of the Month17 days, 12 hours left to enroll

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question