OraFAQ Forum: Server Utilities » segment corruption--how to recover table??

Home » RDBMS Server » Server Utilities » segment corruption--how to recover table?? (10g ,WIN xp)

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

segment corruption--how to recover table?? [message #342767]

Mon, 25 August 2008 00:28

arunshrish
Messages: 74
Registered: May 2008
Location: Chennai

Member

Hi all,
I have a small doubt,

** Pls consider a scenario where some segments in a tablespace get corrupted leading to the table getting in-accessible, with the database being in the NOARCHIVE mode and logical backups taken regularly.

** Is it possible to import the table from a dump and recover the table in this case or is it possible to repair the corruption?

** I thought of importing the table with destroy=y parameter is it possible?

Thanks,
Arun

Report message to a moderator

Re: segment corruption--how to recover table?? [message #342768 is a reply to message #342767]

Mon, 25 August 2008 00:32

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>** Is it possible to import the table from a dump and recover the table in this case or is it possible to repair the corruption?

It depends.
When did corruption occur?
When was corruption detected?
How far back are exports retained?
Are you willing to accept lose of any data since corruption occurred?

>** I thought of importing the table with destroy=y parameter is it possible?

Answer above.

[Updated on: Mon, 25 August 2008 00:35] by Moderator

Report message to a moderator

Re: segment corruption--how to recover table?? [message #342770 is a reply to message #342768]

Mon, 25 August 2008 00:41

arunshrish
Messages: 74
Registered: May 2008
Location: Chennai

Member

Hi Ana,
Well, this is just an imaginary scenario that i thinked of Smile

, well suppose say after a full export, the corruption occurs, can we make use of the exported dump file and import?

Also say i am not willing to accept loss of data, what can be done?

Thanks,
Arun.

Report message to a moderator

Re: segment corruption--how to recover table?? [message #342771 is a reply to message #342767]

Mon, 25 August 2008 00:50

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Also say i am not willing to accept loss of data, what can be done?

OK, I would have prepared & had tested recovery procedures and executed these procedures.
No problems & all data was recovered.

Report message to a moderator

Re: segment corruption--how to recover table?? [message #342779 is a reply to message #342767]

Mon, 25 August 2008 01:26

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

Senior Member
Account Moderator

An export is not a backup, you can't recover from an export, the only thing you can do is to restore the data that are in the dump file.

Regards
Michel

Report message to a moderator

Re: segment corruption--how to recover table?? [message #342780 is a reply to message #342767]

Mon, 25 August 2008 01:26

lalitm_2003
Messages: 86
Registered: May 2005
Location: delhi

Member

Hi arunshrish,
Anacedent is correct.
If you are running in the database in Noarchivelog mode and have only the export dump then the recovery could not be possible to the point of failure.

Regards
Lalit

Report message to a moderator

Re: segment corruption--how to recover table?? [message #342832 is a reply to message #342767]

Mon, 25 August 2008 04:40

arunshrish
Messages: 74
Registered: May 2008
Location: Chennai

Member

Thanks Ana,Michel and Lalit.

@Michel

Quote:

An export is not a backup, you can't recover from an export, the only thing you can do is to restore the data that are in the dump file.

So Michel,does it mean that we can restore the table data and it is the least possible thing that we can do? Anyways should the destroy=y parameter be used while restoring table data by the method of import?

Report message to a moderator

Re: segment corruption--how to recover table?? [message #342843 is a reply to message #342832]

Mon, 25 August 2008 05:28

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

Senior Member
Account Moderator

"destroy" parameter is for CREATE TABLESPACE statement, it has nothing to do with schema import.

You can nothing more that importing xhat's inside the dump file. Before import, drop or truncate the tables.

Regards
Michel

Report message to a moderator

Re: segment corruption--how to recover table?? [message #342852 is a reply to message #342843]

Mon, 25 August 2008 05:57

arunshrish
Messages: 74
Registered: May 2008
Location: Chennai

Member

ok Michel, Thank you very much for the reply..

Report message to a moderator

Previous Topic:	Help me with schema backup
Next Topic:	sqlldr

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 13 16:39:04 CDT 2024