I have setup a centralized backup RMAN catalog with a standard set of scripts parameterized for database name. I use one cron - alerts through e-mail. Also, in terms of DR it is better. Think about it - could write that RMAN catalog to a backup site nightly running a secondary rman catalog. Then if things go SOUTH - get it - Florida (hehe) - SORRY I HAVE BEEN IN DATA CLEANSING PURGATORY!!!! =20 Anyway, if things go south you just need your tapes, your catalog is ready to restore. It is a ##$$ easier to maintain.=20 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of DENNIS WILLIAMS Sent: Tuesday, February 01, 2005 2:06 PM To: Oracle-L Subject: RMAN - Local vs. central backup script We use RMAN on Oracle9i to back up to disk. No SAN or MML, but use an RMAN catalog. I use cron to initiate the backup (Unix servers). In revising the system, I'm trying to decide whether it is better to use the cron on each server, or just trigger backups centrally, from servers where the RMAN catalogs reside. It seems like most of the advantages go to the local script. You are always running the same RMAN executable as the database. Has anyone else looked at this issue and care to share any thoughts? =20 Dennis Williams DBA Lifetouch, Inc. ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ -- //www.freelists.org/webpage/oracle-l BEGIN-ANTISPAM-VOTING-LINKS ------------------------------------------------------ Teach CanIt if this mail (ID 22916873) is spam: Spam: https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Ds&i=3D22916873&m=3De915= 7b98c 4ac Not spam: https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Dn&i=3D22916873&m=3De915= 7b98c 4ac Forget vote: https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Df&i=3D22916873&m=3De915= 7b98c 4ac ------------------------------------------------------ END-ANTISPAM-VOTING-LINKS -- //www.freelists.org/webpage/oracle-l