Home » RDBMS Server » Backup & Recovery » How can i recover my db (11g windos)
How can i recover my db [message #517027] Thu, 21 July 2011 20:25 Go to next message
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 #517029 is a reply to message #517027] Thu, 21 July 2011 20:30 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>My db have no any backup,
Why not. Do you not care about your data?

>How can i revover my db?
Backups are how you recover DB from disaster.

Do you have a recent FULL export?
Re: How can i revover my db [message #517032 is a reply to message #517029] Thu, 21 July 2011 21:31 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Hi,
The data is important for user,but they have never backup db. and there is no export data also.
Re: How can i revover my db [message #517041 is a reply to message #517032] Fri, 22 July 2011 00:46 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And I bet your database is in NOARCHIVELOG mode.

So now you have to call Oracle (prefered option) or an experienced consultant (but maybe he/she can't do anything) to get your data back.

There is also the Google option:
http://www.google.com/search?hl=en&source=hp&q=oracle+corrupt+redo+log&aq=2s&aqi=g1g-s9&aql=&oq=oracle+corrup ted+

Regards
Michel

[Updated on: Fri, 22 July 2011 00:47]

Report message to a moderator

Re: How can i revover my db [message #517044 is a reply to message #517041] Fri, 22 July 2011 01:33 Go to previous messageGo to next message
Markwillium
Messages: 13
Registered: December 2010
Location: India
Junior Member
You have another option, try any third party oracle database recovery software. You can get help from google to search oracle database recovery software..
Re: How can i recover my db [message #517046 is a reply to message #517027] Fri, 22 July 2011 01:57 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
There is the _allow_resetlogs_corruption parameter, but please do not think I am recommending that you use this.

[update: typo]

[Updated on: Fri, 22 July 2011 01:58]

Report message to a moderator

Re: How can i revover my db [message #517047 is a reply to message #517044] Fri, 22 July 2011 01:59 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Hi,
The parameters _allow_resetlogs_corruption can do recover my db?
Re: How can i revover my db [message #517048 is a reply to message #517047] Fri, 22 July 2011 02:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
John Watson
Messages: 8922
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")
Re: How can i revover my db [message #517051 is a reply to message #517049] Fri, 22 July 2011 02:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You MUST export the database, create a new one and import.
It is not an option, it is MANDATORY, it seems your database works but it does not.
It just survives for a while.
Do NOT open it to users, do NOT make any work.
Just do ONE thing: EXPORT.

And plan backups for the new database which must be in ARCHIVELOG mode.

Regards
Michel
Re: How can i revover my db [message #517053 is a reply to message #517051] Fri, 22 July 2011 02:51 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Thank you,I will export my db, but it may be take a long time,because the total size of datafile more than 1TB.
Re: How can i revover my db [message #517055 is a reply to message #517053] Fri, 22 July 2011 02:56 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
That's one more reason to make backups.

Regards
Michel
Previous Topic: RMAN tablespace backup and restore
Next Topic: Archivelog backup details from RMAN
Goto Forum:
  


Current Time: Fri Mar 29 04:51:16 CDT 2024