Home » RDBMS Server » Server Administration » Ora Errors
Ora Errors [message #564413] Thu, 23 August 2012 09:40 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 67294
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
Re: Ora Errors [message #564418 is a reply to message #564416] Thu, 23 August 2012 10:28 Go to previous messageGo to next message
BlackSwan
Messages: 26730
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.
Re: Ora Errors [message #564420 is a reply to message #564413] Thu, 23 August 2012 11:04 Go to previous messageGo to next message
John Watson
Messages: 8319
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.
Re: Ora Errors [message #564512 is a reply to message #564420] Fri, 24 August 2012 09:38 Go to previous messageGo to next message
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 437 times)
Re: Ora Errors [message #564513 is a reply to message #564512] Fri, 24 August 2012 09:39 Go to previous messageGo to next message
haidergill
Messages: 7
Registered: August 2012
Location: Earth
Junior Member
The other sql command output is attached.
  • Attachment: Seb2.jpg
    (Size: 22.35KB, Downloaded 346 times)
Re: Ora Errors [message #564514 is a reply to message #564513] Fri, 24 August 2012 09:47 Go to previous messageGo to next message
BlackSwan
Messages: 26730
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/
Re: Ora Errors [message #564730 is a reply to message #564514] Tue, 28 August 2012 04:29 Go to previous messageGo to next message
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.
Re: Ora Errors [message #564756 is a reply to message #564730] Tue, 28 August 2012 07:26 Go to previous messageGo to next message
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>
Re: Ora Errors [message #564759 is a reply to message #564756] Tue, 28 August 2012 07:43 Go to previous messageGo to next message
John Watson
Messages: 8319
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.
Re: Ora Errors [message #564769 is a reply to message #564759] Tue, 28 August 2012 11:23 Go to previous messageGo to next message
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.

[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 Go to previous messageGo to next message
BlackSwan
Messages: 26730
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/
Re: Ora Errors [message #564780 is a reply to message #564769] Tue, 28 August 2012 11:56 Go to previous messageGo to next message
Michel Cadot
Messages: 67294
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
Re: Ora Errors [message #564789 is a reply to message #564780] Tue, 28 August 2012 12:53 Go to previous message
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.
Previous Topic: cpu usage by a db
Next Topic: insufficient privileges for sys
Goto Forum:
  


Current Time: Sun Aug 09 20:45:43 CDT 2020