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

rpr wrote:
> 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.

thanks for the reply, I eventually got around it once I had a chance to think a little more clearly :-)

cheers Received on Tue Nov 18 2003 - 09:13:21 CST