| Recover [message #464442] |
Thu, 08 July 2010 02:02  |
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 #464505 is a reply to message #464489] |
Thu, 08 July 2010 04:04  |
John Watson
Messages: 8962
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 #464553 is a reply to message #464547] |
Thu, 08 July 2010 06:15 |
 |
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
