 | |
Lost partition containing indexes
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Lost partition containing indexes -
07-08-2003
, 10:04 AM
#2
| |||
| |||
|
|
I've lost the partition containing all of the oracle indexes due to a drive failure. Is it possible to get oracle up without this and rebuild the indexes? Anyone have pointers to docs describing how to recover from something like this? TIA. |
--
Niall Litchfield
Oracle DBA
Audit Commission UK
#3
| |||
| |||
|
|
I have an oracle backup, but not a filesystem backup for the indexes. I sort of assumed that the oracle backups just contained the data for the DB, not necessarily the indexes. |
They contain backups for datafiles. Indexes are located in datafiles.
Next question: do you have an export. The export has the create index
statement. imp indexfile=<any filename> will get them out the dump.
Other than that you are lost.
Sybrand Bakker, Senior Oracle DBA
To reply remove -verwijderdit from my e-mail address
#4
| |||
| |||
|
|
On Tue, 8 Jul 2003, Niall Litchfield wrote: "Donald Thompson" <dlt (AT) checkmysigforemail (DOT) com> wrote in message news:Pine.LNX.4.52.0307080902150.24034 (AT) junior (DOT) lunanet.biz... I've lost the partition containing all of the oracle indexes due to a drive failure. Is it possible to get oracle up without this and rebuild the indexes? Anyone have pointers to docs describing how to recover from something like this? TIA. Do you have a backup? I have an oracle backup, but not a filesystem backup for the indexes. I sort of assumed that the oracle backups just contained the data for the DB, not necessarily the indexes. |
crash means that you can perform a recovery. This is what I was getting at.
As it sounds like you have not performed a recovery before I'd strongly
advise you to call Oracle support and get them to talk you through it.
On the other hand if you have *only* lost indexes (i.e. all the tables are
there) then Sybrands suggestion could also make sense. you would drop the
tablespaces that are unavailable, create new ones and recreate the indexes
in the new tablespaces. This doesn't require backup and recovery, but you do
lose all objects in those lost datafiles, so you better be sure you don't
have required objects in them that cannot be recreated.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
#5
| |||
| |||
|
|
"Donald Thompson" <dlt (AT) checkmysigforemail (DOT) com> wrote in message news:Pine.LNX.4.52.0307080921050.25177 (AT) junior (DOT) lunanet.biz... On Tue, 8 Jul 2003, Niall Litchfield wrote: "Donald Thompson" <dlt (AT) checkmysigforemail (DOT) com> wrote in message news:Pine.LNX.4.52.0307080902150.24034 (AT) junior (DOT) lunanet.biz... I've lost the partition containing all of the oracle indexes due to a drive failure. Is it possible to get oracle up without this and rebuild the indexes? Anyone have pointers to docs describing how to recover from something like this? TIA. Do you have a backup? I have an oracle backup, but not a filesystem backup for the indexes. I sort of assumed that the oracle backups just contained the data for the DB, not necessarily the indexes. A valid backup and all the archive logs from that time to the time of the crash means that you can perform a recovery. This is what I was getting at. As it sounds like you have not performed a recovery before I'd strongly advise you to call Oracle support and get them to talk you through it. On the other hand if you have *only* lost indexes (i.e. all the tables are there) then Sybrands suggestion could also make sense. you would drop the tablespaces that are unavailable, create new ones and recreate the indexes in the new tablespaces. This doesn't require backup and recovery, but you do lose all objects in those lost datafiles, so you better be sure you don't have required objects in them that cannot be recreated. |
select owner, index_name, tablespace_name from dba_indexes to be sure
they all were where you thought (it seems inevitable that some are in
the user default ts or, gulp, system ts).
See:
http://metalink.oracle.com/metalink/...id= 1020181.6
And rename any user indices that have SYS... for a name when you get
the scripts out.
jg
--
@home.com is bogus.
http://www.signonsandiego.com/news/u..._1c9sciqa.html
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.