Recovering from incomplete cold backup

From: Rick Denoire <100.17706_at_germanynet.de>
Date: Sat, 11 Jan 2003 01:20:50 +0100
Message-ID: <j4ou1vgi4a9lbl2t2p7p9858cjcppjqgdo@4ax.com>

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? The missing datafile probably did not change at all (I mean its content, it has a different SCN of course) and it is the only datafile on its own tablespace, which I would willingly get rid of in this clone DB because it is not important in this situation.

Using Oracle 8.1.7 / Solaris 7.

Thanks
Rick Denoire Received on Fri Jan 10 2003 - 18:20:50 CST