Re: Recovering from incomplete cold backup

Hello Rick,
There's a very simple solution for unneeded datafile removal. connect internal in SQLplus; then:
> startup mount
> Alter database datafile 'xxx' offline drop;
> Alter database open ;

If Oracle still demands a recover :
> recover UNTIL CANCEL
> CANCEL

Good luck;

     Roelof Schierbeek

R.Schierbeek, DBA
e-mail: info_at_byteNOSPMlife.com
www : www.bytelife.com
----- Original Message -----
From: Rick Denoire <100.17706_at_germanynet.de> Newsgroups: comp.databases.oracle.server Sent: Saturday, January 11, 2003 1:20 AM Subject: Recovering from incomplete cold backup
> I shut down the DB and copied all files but one that I forgot.
>
> I issued a "backup controlfile to trace" and edited the output to
> produce a script allowing me the make a clone DB with a different
> name, but of course opening the clone DB failed.
>
> Then I hot copied the missing file and retried the operation.
> Oracle demands now to recover this very data file. At this point, I
> got stuck.
>
> What are my chances to get the clone DB open and running?
Received on Sat Jan 11 2003 - 10:11:03 CST