Online Backup question

Hello,

I would like to hear some opinions about online backup ordering. Which "style" is better (safe, fast) ?

This one ?

I.

ALTER TABLESPACE SYSTEM BEGIN BACKUP;
ALTER TABLESPACE RBS BEGIN BACKUP;
ALTER TABLESPACE TEMP BEGIN BACKUP;
ALTER TABLESPACE TOOLS BEGIN BACKUP;
ALTER TABLESPACE USERS BEGIN BACKUP;
and so on ...

!cp /u01/oradata/ora8/system01.dbf /var/backup
!cp /u01/oradata/ora8/system02.dbf /var/backup
!cp /u01/oradata/ora8/rbs01.dbf /var/backup
!cp /u01/oradata/ora8/rbs02.dbf /var/backup
!cp /u01/oradata/ora8/temp01.dbf /var/backup
!cp /u01/oradata/ora8/tools01.dbf /var/backup
!cp /u01/oradata/ora8/users01.dbf /var/backup
and so on ... about 15 more dbfs follow.

ALTER TABLESPACE SYSTEM END BACKUP;
ALTER TABLESPACE RBS END BACKUP;
ALTER TABLESPACE TEMP END BACKUP;
ALTER TABLESPACE TOOLS END BACKUP;
ALTER TABLESPACE USERS END BACKUP;
and so on ...

... or this one ?

II.

--Backup Setting per Tablespace
ALTER TABLESPACE SYSTEM BEGIN BACKUP;
!cp /u01/oradata/ora8/system01.dbf /var/backup
!cp /u01/oradata/ora8/system02.dbf /var/backup
ALTER TABLESPACE SYSTEM END BACKUP; ALTER TABLESPACE RBS BEGIN BACKUP;
!cp /u01/oradata/ora8/rbs01.dbf /var/backup
!cp /u01/oradata/ora8/rbs02.dbf /var/backup
ALTER TABLESPACE RBS END BACKUP; ALTER TABLESPACE TEMP BEGIN BACKUP;
!cp /u01/oradata/ora8/temp01.dbf /var/backup
ALTER TABLESPACE TEMP END BACKUP; ALTER TABLESPACE TOOLS BEGIN BACKUP;
!cp /u01/oradata/ora8/tools01.dbf /var/backup
ALTER TABLESPACE TOOLS END BACKUP; ALTER TABLESPACE USERS BEGIN BACKUP;
!cp /u01/oradata/ora8/users01.dbf /var/backup
ALTER TABLESPACE USERS END BACKUP; and so on BEGIN+cp+END...

I am very much in favor of the second style, because it minimizes the time that a tablespace is in backup mode.

I would appreciate any comments.

My system: Oracle 8.1.7.3 on AIX 5
Size of DB ca. 25 GB in total (so it is fairly small)

TIA, Jan Received on Tue Feb 24 2004 - 02:17:09 CST