Re: Restore from incomplete Fullbackup??

From: Howard J. Rogers <howardjr_at_www.com>
Date: Thu, 20 Sep 2001 11:02:05 +1000
Message-ID: <3ba93f58@news.iprimus.com.au>

"Roman Schicht" <a9600153_at_unet.univie.ac.at> wrote in message news:3BA8C466.E6D80038_at_unet.univie.ac.at...
> Hi, i have an incomplete offline Full-Backup from Oracle 7.3.3 (Backup
crashed)
>
> Is it possible to get data from a specific user from this backup if there
are
> some not important datafiles missing??

Yes.

>
> What must be done to be able to start the instance when some files are
missing
> which do not belong to the data that i need?
>

Try a startup. When it throws a wobbly and says that "File 8 (or whatever) needs media recovery", simply issue the 'alter database datafile 8 offline' command. Try an 'alter database open', and it now might throw a wobbly for file 15. Offline that. Repeat as long as is necessary. Eventually, the alter database command will work. Whether you can use anything that's left is a matter of chance.

Let's pray you've got a good copy of file 1 (the system data file).

Regards
HJR
> Is it possible??
>
> Kind regards
>
> Roman
>
Received on Wed Sep 19 2001 - 20:02:05 CDT