thanks for the swift reply i barley had it sent when i got the reply ,
cheers oisin,chris,adunn
{original message}
> i do all my backups by vdump and cron. The only problem is i would like to
> backup file systems but would like to leave the oracle databases out. Is
> there some way of telling vdump to back up the whole file system but leave
> out the Oracle part.
> The reason for this is the dataabases are not shutdown so there is no
point
> in tbacking them up as they will be all messed up anyway
{end original message}
Basically you cannot exclude directories from vdump which i expected'
but you can,
Suppose the top directory is /top, and has subdirs a, b , c, oracle
where oracle contains the database. Then use vdump
to backup /top/a, /top/b, /top/c.
(vdump can backup a file system OR a directory...)
{this is what i decided to do but the problem with this is if some body
makes a new directory in /top called bottom, then i have to rember to edit
the bacup scripts to include /top/bottom}
other solutions to this are,
opt1
1) stop oracle processing
2) create a clone fileset of the oracle table fileset
3) restart oracle
4) vdump the cloneset (this gives you a "stable" image of the tables
as they were when oracle was stopped)
5) when the vdump is done, remove the clone fileset (if you're in a
cron script don't forget to use the -f switch in rmfset).
opt2
Why not shut the database down, clone the fileset, up the database,
backup the clone? Then your database is in good shape for
a backup, and you don't need to worry.
opt3
Set up cron to shutdown oracle database. then have backups run. then
set up cron to startup oracle once backups have been completed.
All theese options are basically the same just worded differently, They did
not suit me as not enough backup tapes to hold all the data or not enough
time to do so.
still using dds3 tape drives that come on the machine ie 2.
thanks
darrell
darrellk_at_apion-ti.com
Received on Wed Sep 23 1998 - 17:52:47 NZST