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