Babu,

There is an error in you statement, change reuse database to set database
not reuse set database.

Regards,
Ruth
----- Original Message -----
From: "Babu Nagarajan" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Tuesday, April 30, 2002 11:32 AM
Subject: Re: Database Recover - Tablespace from a Cold backup


Database Recover - Tablespace from a Cold backupit will work. provided your
backups are consistent

do a backup controlfile to trace, edit that to remove unwanted datafiles,
change "Reuse database " to "reuse set database", give a new db name and
change "noresetlogs" to "resetlogs"

babu
----- Original Message -----
From: Olson, David
To: LazyDBA.com Discussion
Sent: Tuesday, April 30, 2002 9:55 AM
Subject: Database Recover - Tablespace from a Cold backup




Due to a programming issue, I need to restore a table from a cold backup.
I could restore the whole database, close to 50G, but it will take hours to
get it off of tape. I'm looking for ways to restore the need tablespace
with out having to restore the whole database, if that's possible.

Here is what I was thinking of trying:

Restore the datafiles for the System, Rollback, temp and the
needed tablespace.

Create a new databse with the restored files

export the needed table.

Does this sound like it will work? Or do I need to restore the whole
database?

Thanks,
Dave



Oracle LazyDBA home page