Re: Backup Script

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3d33dd3e$0$231$ed9e5944_at_reading.news.pipex.net...
> "Howard J. Rogers" <dba_at_hjrdba.com> wrote in message
> news:ah01n8$ala$1_at_lust.ihug.co.nz...
> <snip>
>
> > # Then, one datafile at a time, it performs the following logic....
> > # Skip if the datafile is TEMPORARY
> > # Skip if the datafile is a ROLLBACK segment
> > # Set the datafile's tablespace into hot backup mode.
> > # Check it is in hot backup mode (using v$backup).
> > # Issue a unix level cp (copy).
> > # Set the datafile's tablespace out of hot backup mode.
> > # Check it is out of hot backup mode (using v$backup).
> > # If requested, switch log files.
>
> <snip that funny unix stuff>
>
> I think that I have two issues with the logic - I certainly have one.
>
> 1. I would loop through the tablespaces putting them into backup mode only
> once and then copy the datafiles, not loop through the datafiles determine
> the tablespace and put into and out of backup mode. What happens if you
have
> 500 datafiles in one tablespace? (other than management headaches).
>

I think that's his problem, actually. I think a great deal of his logic went in to determining all the datafiles for a tablespace so you could copy them all. I haven't run this script (a Unix box not being readily to hand), so are you saying he puts the same tablespace in and out of hot backup mode for every file it contains?

Not that doing so would render the backup useless, of course.

> 2. What is the reason for skipping rollback segments? I really hope I'm
not
> being stupid here but surely you'd want to back those up as well.

Yeah, I've already talked to the author about that, and a revised version doesn't skip them (a slight misunderstanding!!).

Regards
HJR
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
>
> ******************************************
>
>
Received on Tue Jul 16 2002 - 04:28:24 CDT