Re: Need Help about Tablespace Backup and Recovery

From: MotoX <rat_at_tat.a-tat.com>
Date: Tue, 14 Jul 1998 07:59:20 +0100
Message-ID: <900399478.15586.0.nnrp-05.c2de712e@news.demon.co.uk>

You recover the *database*, not just a tablespace - because objects across tablespaces could be related. So no, you can't just hack off a section of you database and recover that only - unless it is read-only and you set it as such.

For separate applications - as you state - why dump them all in the same database? Seems to me they should be in separate db's. That would also solve you recover problem.

Just my take.

MotoX.

Collin Leung wrote in message <6oebfh$8ol_at_is1.vtc.edu.hk>...
>Dear all news reader,
>
>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
>
>Collin
>
>
>
Received on Tue Jul 14 1998 - 01:59:20 CDT