Re: Online Backup question - Thanks

<sybrandb_at_yahoo.com> schrieb im Newsbeitrag news:a1d154f4.0402240740.7651599_at_posting.google.com... > "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.

Thanks, Sybrand, I will check about this.

Greetings, Jan Received on Wed Feb 25 2004 - 02:23:49 CST