Re: Backing up an ORACLE database on AIX

Item Subject: Backing up an ORACLE database on AIX
     Linnea, here is what we do
     ADSM server has scheduled nightly incrementals with includes for all
     file systems (-oracle related with open/active files)
     then we have a cron job on the machine that shuts down the oracle db,
     calls an ARCHIVE (where you can specify management class of your
     choice) of all the oracle data... that way monthly you can plop into a
     mgmtclass of 365 days and 1/4ly for blah and yearly for blah

     you could set a cron job to issue a bunch of incrementals and have
     them plop into the default mgmtclass with excludes of all your oracle
     file systems, then kick off another cron job to close your DB... issue
     a bunch of archives (default to no delete) with -ARCHMc=blah with file
     specs of your oracle file systems & -subdir=y (on both inc's & arc's),
     then restart your DB. if you are backing up oracle nightly and want to
     keep 3 copies specify a mgmtclass with a life span of 3 or 4 days...

     Hope this helps...
     later
          Dwight



______________________________ Reply Separator _________________________________
Subject: Backing up an ORACLE database on AIX
Author:  ADSM-L at unix,sh/DD.RFC-822=ADSM-L AT VM.MARIST DOT EDU
Date:    5/1/96 3:47 PM


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