Online Backup Script

I'm creating my first online (hot) backup script and have a couple questions. The basic format of the script is:

• begin svrmgrl <<EOD connect internal alter system checkpoint; alter system switch logfile; alter system archive log all;

alter tablespace system begin backup;
alter tablespace rbs begin backup;
alter tablespace user begin backup;
exit
EOD
# tar to DLT with no rewind

tar -vcf /dev/rmt/1mn <datafile list>

svrmgrl <<EOD
connect internal
alter system checkpoint;
alter system switch logfile;
alter system archive log all;

alter tablespace system end backup;
alter tablespace rbs end backup;
alter tablespace user end backup;
exit
EOD
# tar to DLT with append & rewind

tar -vrf /dev/rmt/1m <control file list> <archive log dir> --- end

I'll add error checking and logging later, but does the basic format look OK? Are the checkpoint, switch logfile and archive log all good practice, or unnecessary? Any feedback is appreciated.

Thanks,

Eric
nospam.efender_at_ix.netcom.com
remove nospam to reply via e-mail Received on Wed May 10 2000 - 00:00:00 CDT