RE: Recover a table from cold backup-noarchivelog

If all you're doing is exporting the table, no harm in changing the
parameter to use just SYSTEM and the R0 rollback in the SYSTEM tablespace
that you created in order to create additional tablespaces. But I did leave
that instruction out of my off the top of my head instruction list. (Don't
forget to change it back, and it really depends how large your UNDO
containers are whether it is worth the change.)

mwf

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Daniel Fink
Sent: Tuesday, August 31, 2004 11:25 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Recover a table from cold backup-noarchivelog


IIRC, you also need to restore the rollback/undo tablespace files. I know
they are not needed for recovery, but I think that Oracle
expects them. I think this is what killed our first attempt at recovery,
many many moons ago. I don't think you need TEMP however.

GUPTA, DEEPENDER wrote:
> If we know the default tablespace of the table then can't we just restore
> the associated datafiles, system datafile, temp datafile and control files
> and then startup mount the database.
> Then "offline drop" all other datafiles apart from the above mentioned
files
> and then open the database and take the export of the table.
>

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: