How to handle temporary tablespace (locally managed) during restoration from a hot backup?

Home -> Community -> Usenet -> c.d.o.server -> How to handle temporary tablespace (locally managed) during restoration from a hot backup?

From: Jeffrey Yee <jeffyee_at_hotmail.com>
Date: 13 Jul 2003 22:58:21 -0700
Message-ID: <ec4cec95.0307132158.19349895@posting.google.com>

Hi,

I realise that temporary tablespace tempfile (locally managed) cannot use the alter tablespace begin backup command. Therefore, I wonder what would be the best way to recover the tempfile.

Lets assume a disk crash happen, and all datafiles and tempfiles are now missing. After the disk is fix, I would restore all the hot backup datafiles to its original location and allow roll forward & roll back from the archive log files. But I can't think of what to do, to recover the tempfile.

Please advice. Thank you in advance.

Best Regards,
Jeffrey Yee Received on Mon Jul 14 2003 - 00:58:21 CDT