Home » RDBMS Server » Backup & Recovery » how to recover the database from this errorsORA-00313 ORA-00312 ORA-27046 OSD-04012 (9i,xp)
how to recover the database from this errorsORA-00313 ORA-00312 ORA-27046 OSD-04012 [message #330946] Tue, 01 July 2008 21:56 Go to next message
imraan
Messages: 21
Registered: June 2008
Location: ayangudi
Junior Member
my problem is i connect as a user to the database and created the table, then i connected as sys user I have 2 logfile group and each have one member,the current logfile name is redo2.
I open the redo2 in the os level and delete the some of contents in it,then i switch logfile using the command alter system switch logfile,the below error is happened.

ORA-03113: end-of-file on communication channel

and then i shut the database then i issue the command startup but oracle sends the following error

ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: 'D:\ORACLE\ORADATA\IMRAN\REDO2.LOG'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch (OS 5238251).

help me how to recover from these errors.

thanks.

[Updated on: Tue, 01 July 2008 23:42]

Report message to a moderator

Re: how to recover the database from this errorsORA-00313 ORA-00312 ORA-27046 OSD-04012 [message #330947 is a reply to message #330946] Tue, 01 July 2008 22:08 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
invoke dbca & create a new database or restore from backups.

Report message to a moderator

Re: how to recover the database from this errorsORA-00313 ORA-00312 ORA-27046 OSD-04012 [message #330954 is a reply to message #330946] Tue, 01 July 2008 23:07 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
But why did you do that?

Regards
Michel

Report message to a moderator

Re: how to recover the database from this errorsORA-00313 ORA-00312 ORA-27046 OSD-04012 [message #330973 is a reply to message #330947] Tue, 01 July 2008 23:52 Go to previous messageGo to next message
imraan
Messages: 21
Registered: June 2008
Location: ayangudi
Junior Member
@But why did you do that?

just to learn to recover, like these kind of situation arises,so i corrupted the logfile.

[Updated on: Tue, 01 July 2008 23:55]

Report message to a moderator

Re: how to recover the database from this errorsORA-00313 ORA-00312 ORA-27046 OSD-04012 [message #330974 is a reply to message #330973] Tue, 01 July 2008 23:53 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
imraan wrote on Tue, 01 July 2008 21:52
just to learn when this kind of situation arises


So what have you learned from fatal termination of a DB?
Follow & execute tested & documented restoration plan or send out your resume hoping to find another sucker who will hire you.

[Updated on: Tue, 01 July 2008 23:55] by Moderator

Report message to a moderator

Re: how to recover the database from this errorsORA-00313 ORA-00312 ORA-27046 OSD-04012 [message #330978 is a reply to message #330973] Wed, 02 July 2008 00:03 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
imraan wrote on Wed, 02 July 2008 06:52
@But why did you do that?

just to learn to recover, like these kind of situation arises,so i corrupted the logfile.

In this case, read:
User-Managed Backup and Recovery Guide
Chapter 6 User-Managed Media Recovery Scenarios

Regards
Michel

[Updated on: Wed, 02 July 2008 00:03]

Report message to a moderator

Previous Topic: recovery from loss of control files
Next Topic: Need Help in Oracle Export/Import?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 25 20:46:26 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.