How can i recover my db [message #517027] |
Thu, 21 July 2011 20:25 |
andy huang
Messages: 498 Registered: July 2011
|
Senior Member |
|
|
Dear all,
My db have no any backup, Yesterday, the current redo file have bad,the alert.log contain as flowing:
ORA-00333: redo log read error block 2 count 8192
How can i revover my db?
[EDITED by LF: fixed topic title typo; was "revover"]
[Updated on: Fri, 22 July 2011 00:42] by Moderator Report message to a moderator
|
|
|
|
|
|
|
|
|
Re: How can i revover my db [message #517048 is a reply to message #517047] |
Fri, 22 July 2011 02:09 |
|
Michel Cadot
Messages: 68672 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
No, not at all, it allows you to export your data before you recreate the database.
It is a very advanced option that requires experienced and skilled people, this is why I advised you to hire someone that knows what he/she does.
Regards
Michel
[Updated on: Fri, 22 July 2011 02:09] Report message to a moderator
|
|
|
Re: How can i revover my db [message #517049 is a reply to message #517048] |
Fri, 22 July 2011 02:24 |
andy huang
Messages: 498 Registered: July 2011
|
Senior Member |
|
|
Hi,
I set the parameters _allow_resetlogs_corruption=true in pfile,and startup my db using the pfile,my db can open and run well.
startup pfile='C:\pfileora.ora' and then alter database open resetlogs, the db can open.
|
|
|
Re: How can i revover my db [message #517050 is a reply to message #517049] |
Fri, 22 July 2011 02:40 |
John Watson
Messages: 8941 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Your database may well have corruptions, in user data and/or the data dictionary, as a result of this. It could fall over sny time. Therefore, export it immediately.
(Feel free to say "thank you")
|
|
|
|
|
|