Linnea Nichols wrote:
>
> To: [email protected] <adsm-l AT vm.marist DOT edu>
>
> FROM: Linnea T. Nichols (703)324-2708 US5RNFRN AT ibmmail DOT com
> Systems Programming Mgr LNICHO AT co.fairfax.va DOT us
> Fairfax County Department of Information Technology
> Subject: Backing up an ORACLE database on AIX
> We are trying to set up a backup scenario for an ORACLE database on an
> AIX box. What we want to do is to have the backup performed at a set
> time as determined by this system's administrator, and not have it use
> an ADSM scheduled backup. When the backup is kicked off, we would like
> to have it do a regular incremental backup using a STANDARD mgmt class,
> excluding the ORACLE database, and then do a selective backup on the
> ORACLE database, using a different mgmt class. We've been trying to
> figure out how to do this using the INCLUDE/EXCLUDE statements and have
> gotten stuck. What would be the best way to do this? (We've read the
> Redbook on backuping up databases -- it's good, but we can't find an
> answer to our problem.
>
> * "We are all faced with a series of great opportunities *
> * brilliantly disguised as impossible situations" C. Swindoll*
> Linnea
Linnea,
We too have this problem, it would be nice to be able to
over-ride the INCL/EXCL list, i.e. point to a second one for such
an occasion.
We are using ADSMPIPE to backup our oracle databases, but like
you on a users application we need to take a non database and
then a database backup, i.e. :- excluding the oracle files on the
non database backup but then including them on the database
backup.
How we get round it is, say your system has "/, /usr, /home and
/oracle", we define the non database schedule using the OBJECTS
parm, "OBJECTS=/, /usr, /home", then we cron a job, to run
adsmpipe jobs, to backup /oracle.
I hope this is of some help, we have raised this problem with
CALL-AIX some time ago, but they say ADSM is working as designed,
although you can over-ride other parameters in the client options
files.
Surely to over-ride the INCLEXCL seems like a good option to add
in further releases.
|