| 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 #564420 is a reply to message #564413] |
Thu, 23 August 2012 11:04  |
John Watson
Messages: 8960
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 #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>
|
|
|
|
| Re: Ora Errors [message #564759 is a reply to message #564756] |
Tue, 28 August 2012 07:43 |
John Watson
Messages: 8960
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 |
|
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 #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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
