Re: creating db copy from online backup problems...

Hi,
  In case Niall has not replied with details about his solution : Here is what i think :

1. Put the temp files offline using : alter database datafile '...<name> ' offline. You can use the file number here too but good practice to stick to name.
2. Open the database.
3. Drop the temp tablespace
4. CReate a new temp tablespace.

If step 2 does not succeed because another file needs recovery then if is a temp file then put it offline and try to open and so on. Of course it is very important to make sure it is really temp. good luck

Glen A Stromquist <glen_stromquist_at_nospam.yahoo.com> wrote in message news:<K4Rtb.60065$jy.46712_at_clgrps13>...
> Niall Litchfield wrote:
>
> > If it really is a temp tablespace (contents temporary) just drop and
> > recreate, there is nothing of value in it.
> >
> snipped
>
> I can't open the database to drop it, I'm tempted to shutdown the prod
> and just do a consistent cold backup and copy the whole works over and
> recreate the controlfile, but I'd like to know what went wrong here.
>
> btw - 8.1.7.4 on W2K advanced server, both at same patchset.
Received on Mon Nov 17 2003 - 10:59:41 CST