Re: Online Backup question

"Jan Gelbrich" <j_gelbrich_at_westfalen-blatt.de> wrote in message news:<c1f1g2$1gkuji$1_at_ID-93924.news.uni-berlin.de>...
> 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

As in scenario 1 all tablespaces are in backup mode, scenario 1 will generate more redo during online backup (because during online backup *complete* blocks are logged). Scenario 1 is usually adviced against. On another note: why do you still use this kind of scripting? RMAN is far more robust and more intelligent.

Sybrand Bakker
Senior Oracle DBA Received on Tue Feb 24 2004 - 09:40:27 CST