Re: Why is on-line backup one tablespace a time?

Dino Hsu wrote:
>
> Dear all,
>
> I read chapter 12 Overview of Backup and Reovery of Jason Couchman. An
> on-line backup is performed with one tablespace a time with:
> alter tablespace <ts> begin backup;
> make backup of datafiles with OS copy command
> alter tablespace <ts> end backup;
> These tablespace backups are not required to happen at the same time,
> and the database is still open. I wonder how these tablespace backups
> can be synchronized. Anyone comment on this? Thanks in advance.
>
> Dino

Synchronized Backups?

Look into big buck$ storage solutions from EMC and NetApp.

Otherwise - 2 words:

cold backup

Provided that the database is closed cleanly - the datafiles are all consistent.
The degree of difficulty is less - probably a good place to start from and add complexity later.

Paul Received on Tue Aug 28 2001 - 01:26:19 CDT