Re: Online Backup Script

Hi Fender,

You might want to apply another approach.

The meaning of alter tablespace .... begin backup ............... end backup is to shorten the period of time a tablespace is offline. When you now put all tablespaces in backup mode this will increase the offline period for a tablespace.

What you should consider is:

alter tablespace system begin backup;

host tar -vcf /dev/rmt/1mn systemdatafile

alter tablespace system end backup;

alter tablespace data1 begin backup;

host tar -vcf /dev/rmt/1mn datadatafile

alter tablespace data1 end backup;

etc.....

This reduces tablespace offline time. And users can go on working like nothing is going on.

Greetings,

John

Fender <nospam.efender_at_ix.netcom.com> schreef in berichtnieuws 8fc4ct$i42$1_at_slb2.atl.mindspring.net...
> 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