Re: backup questions

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 - 03:36:09 CDT