Re: Opinion of a backup and recovery strategy.

g3000 wrote:

> 1. Oracle8i ( 8.1.7 ) database.
> 2. 4 Applications in one database.
> 3. Each app is in its own tablespace and schema.
>
> Question
>
> What could I do to backup each app so as when I need to restore one I
> can do so without considering the state of the other applications?
>
> TSPITR is not an option because of the need for a clone database.
> I need to be able to restore the same backup many times if need be.

ALTER TABLESPACE <tablespace_name> BEGIN BACKUP; ALTER TABLESPACE <tablespace_name> END BACKUP;

Fill in the rest by reading the documentation.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)