Re: Need Help about Tablespace Backup and Recovery

From: Cheng-Jih Chen <cjc_at_interport.net>
Date: 14 Jul 1998 11:48:57 -0400
Message-ID: <6oful9$k32$1@interport.net>

In article <6oebfh$8ol_at_is1.vtc.edu.hk>, Collin Leung <collinl_at_vtc.edu.hk> wrote:

>I have a database and it will service more than one application. Each
>application will use one tablespace to store the data. For example, if one
>of the tablespace need a 'POINT IN TIME' recovery, what I need to do is
>recovery that tablespace ONLY and it CANNOT affect other tablespace. What I
>try to do is user Oracle 8 recovery manager's recovery feature. However, I
>can't successfully have a 'POINT IN TIME' recovery. Any suggestion will be
>help. Many Thanks

Get another computer, and perform a point in time recovery of the full database on that. Arguably, you can not include the other tablespaces, but this involves pain and suffering, so it's easier just to recover the whole thing.

After you have a point in time image, export the application's objects, take that dump file to the first computer, and import back in. You may want to nuke all the application's objects on the first machine before doing the import, of course.

--
Millennial Thought For The Day.
Russian Strategic Rocket Forces: Y2K Compliant? Received on Tue Jul 14 1998 - 10:48:57 CDT