Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN - Local vs. central backup script

RE: RMAN - Local vs. central backup script

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Wed, 2 Feb 2005 08:24:23 -0500
Message-ID: <C9995D8C5E0DDA4A8FF9D68EE666CE0702A972D1@exchsen0a1ma>


I don't telnet to each machine every day. The shell scripts are installed on each machine, the cron schedule is set up, and things run just fine.

But I would be interested in seeing your parameterized Rman scripts you store in the catalog.

-----Original Message-----

From: Paula_Stankus_at_doh.state.fl.us [mailto:Paula_Stankus_at_doh.state.fl.us] Sent: Tuesday, February 01, 2005 4:05 PM To: thomas.mercadante_at_labor.state.ny.us; DWILLIAMS_at_LIFETOUCH.COM; oracle-l_at_freelists.org
Subject: RE: RMAN - Local vs. central backup script

Right there is the issue - why telnet to each machine if you don't have to. Why manage - upgrade X number of RMAN databases???? Why duplicate the code on X number of machines..... Why...why...why....???

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mercadante, Thomas F Sent: Tuesday, February 01, 2005 2:37 PM To: 'DWILLIAMS_at_LIFETOUCH.COM'; Oracle-L
Subject: RE: RMAN - Local vs. central backup script

Dennis,

I find it just as easy to have a standard Rman cron script and simply have it installed on each box. Cron runs on each box and schedules the backup accordingly.

Obviously, if you have something like Tivoli Workload Scheduler, it would be easier to control the backups from one place - this simply runs the shell script on each machine.

To me, its 6 of one, half a dozen of the other. We telnet to each machine as needed.

Hope this helps.

Tom

-----Original Message-----

From: DENNIS WILLIAMS [mailto:DWILLIAMS_at_LIFETOUCH.COM] 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?  

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

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l

BEGIN-ANTISPAM-VOTING-LINKS



Teach CanIt if this mail (ID 22912776) is spam: Spam:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=s&i=22912776&m=40c736055 81a
Not spam:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=n&i=22912776&m=40c736055 81a
Forget vote:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=f&i=22912776&m=40c736055 81a

END-ANTISPAM-VOTING-LINKS
--

http://www.freelists.org/webpage/oracle-l Received on Wed Feb 02 2005 - 08:27:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US