Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Backup Script
"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message
news:ah0oug$bbp$1_at_lust.ihug.co.nz...
> > 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?
That is what HE is saying in the documentation in the script. I think that this is what he is actually doing as well but I also can't read (much less write) unix shell scripts. He does however create a temporary .sql file so for debugging purposes he should leave that on the file system and actually take a look at what gets generated.
-- 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 - 06:06:57 CDT