Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Daniel Fink
Sent: Tuesday, August 31, 2004 11:25 AM
To: oracle-l_at_freelists.org
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.
>
-- 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_at_freelists.org 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 -----------------------------------------------------------------Received on Tue Aug 31 2004 - 10:34:02 CDT
![]() |
![]() |