Solved

Erased REDO01.LOG and REDO03.LOG by mistake!

Posted on 2004-10-20
3
1,607 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 250 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 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 250 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

911 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now