Re: backup questions

Thank you so much. Also how can we schedule this? SP
"nomenclature" <nom_at_tonal.net> wrote in message news:39C08DF9.9C69BC02_at_tonal.net...
> sp wrote:
> >
> > I've Oracle 8.1.5 db and I have a couple of questions:
> > 1. Is there a way to schedule online db backup?
>
> Yes.
>
> Funny question.
>
>
> > 2. Also I've a recovery catalog created. Since ours is a small db I
 want
> > to use control file instead of a new db for rman. What is the procedure
 to
> > run rman after this?
 

> > 3. What is the best way to backup in archive log mode.
>
> something like this called from crontab or equivalent:
> # begin
> su - oracle
> ORACLE_SID=sid
> export ORACLE_SID
> svrmgrl <<EOD
> connect internal
>
> alter tablespace system begin backup;
>
> host tar -vcf /dev/rmt0h /u03/oradata/sid/system01.dbf
>
> alter tablespace system end backup;
>
> alter tablespace users begin backup;
>
> host tar -vrf /dev/rmt0h /u02/oradata/sid/users01.dbf
> /u03/oradata/sid/users03.dbf
>
> alter tablespace users end backup;
>
> alter tablespace rollback begin backup;
>
> host tar -vrf /dev/rmt0h /u04/oradata/sid/rbs01.dbf
>
> alter tablespace rollback end backup;
> exit
> EOD
>
> # now backup all the control files
> tar -vrf /dev/rmt0h /u03/oradata/sid/control01.ctl
> /u02/oradata/sid/control02.ctl /u04/oradata/sid/control03.ctl
>
> exit
> EOD
Received on Thu Sep 14 2000 - 18:30:50 CDT