| Deleted REDO02.LOG (ORA-00313) [message #224568] |
Wed, 14 March 2007 12:30  |
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 
|
|
|
|
|
|
|
|
| Re: Deleted REDO02.LOG (ORA-00313) [message #224730 is a reply to message #224579] |
Thu, 15 March 2007 04:42  |
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 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
