Home » RDBMS Server » Backup & Recovery » Recover (Oracle10g)
Recover [message #464442] Thu, 08 July 2010 02:02 Go to next message
subbu_tce
Messages: 98
Registered: July 2007
Location: pune
Member
Hi,
One of my tablespace got corrupted which is specifically ment for index only.How to recover this.Plz provide me the step.
Re: Recover [message #464447 is a reply to message #464442] Thu, 08 July 2010 02:12 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Is this a problem on a production database, or is it a college homework question?
[edit - spelling]

[Updated on: Thu, 08 July 2010 02:13]

Report message to a moderator

Re: Recover [message #464461 is a reply to message #464447] Thu, 08 July 2010 02:35 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If it is an index, drop and recreate it.

Regards
Michel
Re: Recover [message #464489 is a reply to message #464447] Thu, 08 July 2010 03:31 Go to previous messageGo to next message
subbu_tce
Messages: 98
Registered: July 2007
Location: pune
Member
May i know in which college they are giving such type of homework?
Re: Recover [message #464505 is a reply to message #464489] Thu, 08 July 2010 04:04 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Every college that teaches Oracle DB Admin should be asking you this! The reason I asked is that the stated policy of Orafaq (I don't have the reference to hand) is that questions regarding homework should be answered with hints that will encourage the questioner to learn, whereas questions regarding operational problems should be answered in a more factual manner. Your question is very brief, making it look like a homework question - if it were a real problem, I would have expected more detail. So here is a homework-type answer:

You need to decide whether the damaged data should be restored and recovered, or (as Michel suggests) re-created. To make this decision, you would need consider (among other things) time scales, and whether your application can function (temporarily) without the indexes. If you can open the database and rebuild, what will the effects be on SELECTs and DMLs while this is in progress? What will you do with constraints? Or would it be better to shutdown, and restore/recover in mount mode?
Re: Recover [message #464547 is a reply to message #464505] Thu, 08 July 2010 05:53 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Quote:
If it is an index, drop and recreate it.

Regards
Miche

It is not an index.Its a tablespace.
Quote:
One of my tablespace got corrupted which is specifically ment for index

sriram Smile
Re: Recover [message #464553 is a reply to message #464547] Thu, 08 July 2010 06:15 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes but the corruption is in an index I think as 1) it is detected and 2) the tablespace is used for indexes.

Regards
Michel
Previous Topic: How to recover DB using RMAN if my target and catalog both are lost?
Next Topic: Incomplete recovery failed - ORA-00279
Goto Forum:
  


Current Time: Fri Mar 29 07:26:30 CDT 2024