OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Ora Errors

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Ora Errors [message #564413]

Thu, 23 August 2012 09:40

haidergill
Messages: 7
Registered: August 2012
Location: Earth

Junior Member

Hi,

My colleagues Windows 7 laptop blue screened and since then the Oracle service will not start successfully: -

SQL*Plus: Release 11.2.0.1.0 Production on Thu Aug 23 11:28:55 2012

Copyright (c) 1982, 2010, Oracle. All rights reserved.

SQL> alter database open;
SP2-0640: Not connected
SQL> conn sys/****** as sysdba
Connected.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-00355: change numbers out of order
ORA-00353: log corruption near block 1542 change 4022732 time 08/23/2012
09:38:26
ORA-00312: online log 2 thread 1: 'C:\APP\EMEAL0022\ORADATA\ORCL\REDO02.LOG'

Now we are wondering how this can be rectified. We tried rman restore database to no avail as he never backedup the database. The database is used by an application. They are only meant to play around on the laptops and learn the app rather than doing critical work. Before we put him in front of the firing would it be possible to recover the DB?

Thanks
Haider

[Edit MC: hide sys password at OP's request]

[Updated on: Fri, 24 August 2012 05:55] by Moderator

Report message to a moderator

Re: Ora Errors [message #564416 is a reply to message #564413]

Thu, 23 August 2012 10:22

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Not with the standard ways, only with unsupported ones that I prefer to not post in a forum.
I advice you to either hire a consultant to recover the database or recreate one as this is just a sandbox.

Regards
Michel

Report message to a moderator

Re: Ora Errors [message #564418 is a reply to message #564416]

Thu, 23 August 2012 10:28

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Incomplete recovery might be possible.

00312, 00000, "online log %s thread %s: '%s'"
// *Cause: This message reports the filename for details of another message.
// *Action: Other messages will accompany this message. See the
// associated messages for the appropriate action to take.
bcm@bcm-laptop:~$ oerr ora 353
00353, 00000, "log corruption near block %s change %s time %s"
// *Cause: Some type of redo log corruption has been discovered. This error
// describes the location of the corruption. Accompanying errors
// describe the type of corruption.
// *Action: Do recovery with a good version of the log or do incomplete
// recovery up to the indicated change or time.
bcm@bcm-laptop:~$ oerr ora 355
00355, 00000, "change numbers out of order"
// *Cause: A change number found in the redo log is lower than a previously
// encountered change number. The log is corrupted in some way. The
// corruption may be at the earlier change or at this one.
// *Action: Do recovery with a good version of the log or do time based
// recovery up to the indicated time.

Report message to a moderator

Re: Ora Errors [message #564420 is a reply to message #564413]

Thu, 23 August 2012 11:04

John Watson
Messages: 8929
Registered: January 2010
Location: Global Village

Senior Member

If your current online logfile group is damaged, you have a problem. But there may be a way around it. Please post the results of these queries, properly formatted in [code] tags as described here How to use [code] tags and make your code easier to read

select * from v$log;
select * from v$logfile;

and also what the logfile members look like when you use the Windows DIR command.

Report message to a moderator

Re: Ora Errors [message #564512 is a reply to message #564420]

Fri, 24 August 2012 09:38

haidergill
Messages: 7
Registered: August 2012
Location: Earth

Junior Member

The sql output requested is attached. I'll get you the dir command output. Thanks for everybody's help much appreciated by me and especially by my colleague.

Attachment: Seb1.jpg
(Size: 29.65KB, Downloaded 1070 times)

Report message to a moderator

Re: Ora Errors [message #564513 is a reply to message #564512]

Fri, 24 August 2012 09:39

haidergill
Messages: 7
Registered: August 2012
Location: Earth

Junior Member

The other sql command output is attached.

Attachment: Seb2.jpg
(Size: 22.35KB, Downloaded 962 times)

Report message to a moderator

Re: Ora Errors [message #564514 is a reply to message #564513]

Fri, 24 August 2012 09:47

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: Ora Errors [message #564730 is a reply to message #564514]

Tue, 28 August 2012 04:29

haidergill
Messages: 7
Registered: August 2012
Location: Earth

Junior Member

BlackSwan wrote on Fri, 24 August 2012 09:47

Please read and follow the forum guidelines, to enable us to help you:

Sorry wilco.

Report message to a moderator

Re: Ora Errors [message #564756 is a reply to message #564730]

Tue, 28 August 2012 07:26

haidergill
Messages: 7
Registered: August 2012
Location: Earth

Junior Member

C:\app\EMEAL0022\oradata\orcl>dir
23/08/2012 14:41 <DIR> .
23/08/2012 14:41 <DIR> ..
23/08/2012 16:45 9,748,480 CONTROL01.CTL
23/08/2012 15:06 104,865,792 EXAMPLE01.DBF
23/08/2012 15:06 524,296,192 LOCAL.DBF
16/08/2012 03:24 52,429,312 REDO01.LOG
23/08/2012 11:31 52,429,312 REDO02.LOG
10/08/2012 09:45 52,429,312 REDO03.LOG
23/08/2012 15:06 713,039,872 SYSAUX01.DBF
23/08/2012 15:06 754,982,912 SYSTEM01.DBF
23/08/2012 09:36 40,902,656 TEMP01.DBF
23/08/2012 15:06 99,622,912 UNDOTBS01.DBF
23/08/2012 15:06 5,251,072 USERS01.DBF
11 File(s) 2,409,997,824 bytes
2 Dir(s) 405,942,431,744 bytes free

C:\app\EMEAL0022\oradata\orcl>

Report message to a moderator

Re: Ora Errors [message #564759 is a reply to message #564756]

Tue, 28 August 2012 07:43

John Watson
Messages: 8929
Registered: January 2010
Location: Global Village

Senior Member

It looks to me as though as though you (or someone) has tried to "restore" the online logfiles. You can't do that, you know.
I am NOT going to assist further, because you persist in ignoring the guidelines. That is very rude behaviour. You cannot expect people to download images and attemnpt to decipher unformatted copy/pastes.

Report message to a moderator

Re: Ora Errors [message #564769 is a reply to message #564759]

Tue, 28 August 2012 11:23

haidergill
Messages: 7
Registered: August 2012
Location: Earth

Junior Member

Apologies, I thought the above post complied with the guidelines. They (guidelines) mentioned formatting and indenting code blocks. As the above was output from a MS-DOS window I did not indent as you would source-code. In the interests of civility and good-manners please find the input and output indented. I tried in the editor but it would not maintain the indenting once the post was posted, therefore I am attaching a text file which is indented.

Attachment: DirCommand.txt
(Size: 0.68KB, Downloaded 1286 times)

[Updated on: Tue, 28 August 2012 11:35]

Report message to a moderator

Re: Ora Errors [message #564770 is a reply to message #564769]

Tue, 28 August 2012 11:29

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: Ora Errors [message #564780 is a reply to message #564769]

Tue, 28 August 2012 11:56

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

I tried in the editor but it would not maintain the indenting once the post was posted, therefore I am attaching a text file which is indented.

Just because you didn't read the link John provided you.

Regards
Michel

Report message to a moderator

Re: Ora Errors [message #564789 is a reply to message #564780]

Tue, 28 August 2012 12:53

haidergill
Messages: 7
Registered: August 2012
Location: Earth

Junior Member

I see, clicking the blue colour uppercase text with underlines opens another webpage. I thought it was just there to signify emphasis and not a link. Sorry.

Report message to a moderator

Previous Topic:	cpu usage by a db
Next Topic:	insufficient privileges for sys

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 13:38:02 CDT 2024