Home » RDBMS Server » Server Administration » Deleted REDO02.LOG (ORA-00313)
Deleted REDO02.LOG (ORA-00313) [message #224568] Wed, 14 March 2007 12:30 Go to next message
sauravsen
Messages: 2
Registered: March 2007
Location: NOIDA
Junior Member
Hi,

I have mistakenly deleted the REDO02.LOG and REDO03.LOG file.
So I am unable to connect to my database.

I have tried to connect through no log and then Shutdown and Start up. Following message has been shown
*****************************************************
*****************************************************
SQL> shutdown
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 378608760 bytes
Fixed Size 453752 bytes
Variable Size 167772160 bytes
Database Buffers 209715200 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: 'D:\ORACLE\ORADATA\ILR\REDO02.LOG'


SQL>
***************************************************
***************************************************

How may I recreate the two log files?

Regards,
Saurav Embarassed
Re: Deleted REDO02.LOG (ORA-00313) [message #224573 is a reply to message #224568] Wed, 14 March 2007 12:37 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>How may I recreate the two log files?
$ format D:
I hope you have good backups.
Re: Deleted REDO02.LOG (ORA-00313) [message #224579 is a reply to message #224568] Wed, 14 March 2007 12:52 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Try this and be advised that you are using an undocumented parameter and do it at your own risk.
http://www.orafaq.com/forum/m/195705/0/?srch=_allow_resetlogs_corruption+%3D+true#msg_195705
Re: Deleted REDO02.LOG (ORA-00313) [message #224730 is a reply to message #224579] Thu, 15 March 2007 04:42 Go to previous messageGo to next message
sauravsen
Messages: 2
Registered: March 2007
Location: NOIDA
Junior Member
Hello Mahesh,

Thanks for your help.

The last two lines was sufficient for creating log files.

*************************************
*************************************

C:\>sqlplus/nolog

SQL*Plus: Release 9.2.0.1.0 - Production on Thu Mar 15 15:02:38 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> conn sys/mypassword as sysdba
Connected.
SQL> recover database until cancel;
Media recovery complete.

SQL> alter database open resetlogs;
Database altered.

*************************************
*************************************

Regards,
Saurav
Re: Deleted REDO02.LOG (ORA-00313) [message #225193 is a reply to message #224730] Mon, 19 March 2007 01:12 Go to previous message
d.c.b.a
Messages: 44
Registered: March 2005
Location: China
Member

This is not the correct action.

You need to check whether the REDO02.LOG is current or active log file group (by query the v$log view in mount status), if so, restore the database from backup.

Else you can just clear the log file group.
Previous Topic: Adding logfile groups in ASM
Next Topic: LOB's and Disk SPace
Goto Forum:
  


Current Time: Sat Dec 10 16:49:23 CST 2016

Total time taken to generate the page: 0.07823 seconds