We use SQL-BackTrack by BMC to do hot backups directly into the ADSM
storage pools.  The archive logs are backed up by SQL-BackTrack and can be
configured to either delete the archive logs after backup or rename them.
SQL-BackTrack has the ability to "test" recoveries without actually
recovering the files.  SQL-BackTrack also does cold backups and exports.







"Kelly, Patrick C." <PKELLY AT WCB.STATE.ND DOT US> on 07/30/99 08:49:21 AM

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

To:   ADSM-L AT VM.MARIST DOT EDU
cc:    (bcc: Wendy Cooper/HQ/SunglassHut)
Subject:  Backing up Oracle with ADSM




Hi everybody,
I am looking for some suggestions on backing up Oracle databases using
ADSM.
The way we do it now, is to shutdown the database nightly and do a cold
backup. Works good but causes about 3hrs of downtime. What I would like to
do is shut the database down for a cold backkup weekly and then backup the
archive logs periodically throughout the week.
Has anyone had experience doing this? More importantly has anyone had
success recovering from this type of backup. I have seen how fussy Oracle
can be after a restore and I need to have my bases covered.
Thanks in advance
Pat Kelly
pkelly AT wcb.state.nd DOT us