From oracle-l-bounce@freelists.org Wed Feb 2 12:47:37 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j12IlbS1001850 for ; Wed, 2 Feb 2005 12:47:37 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j12IlZem001844 for ; Wed, 2 Feb 2005 12:47:35 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7AC1B6CAFE; Wed, 2 Feb 2005 12:46:29 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 29987-08; Wed, 2 Feb 2005 12:46:29 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EC7236CA94; Wed, 2 Feb 2005 12:46:28 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.0.6603.0 Content-Class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit Subject: RE: RMAN - Local vs. central backup script Date: Wed, 2 Feb 2005 12:43:41 -0500 Message-ID: <7E412C164E6ECB468834A39F31E6E0D406689037@mbs06dc.na.aarp.int> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: RMAN - Local vs. central backup script Thread-Index: AcUJRlttdYBs4eRDRu+r0P6CPA8zxwABxV5Q From: "Marquez, Chris" To: , X-OriginalArrivalTime: 02 Feb 2005 17:43:41.0772 (UTC) FILETIME=[BC1810C0:01C5094E] X-archive-position: 15690 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: CMarquez@aarp.org Precedence: normal Reply-To: CMarquez@aarp.org X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=AWL autolearn=ham version=2.60 X-Spam-Level: Dennis, Not going to talk you out of it...just fyi. On my RMAN server I have 8i and 9i installed to *match* my (50+) target databases. If/when I have a 10g database I would install 10g on the RMAN server too. That way I'm always execute the right/same RMAN executable as my target database (for backup). >>We have also found character set issues Me too...I have NLS set as an environment variable in my master RMAN shell script...fixed! Good luck, and remember; Backup is easy...its Restore & Recovery that's hard! ;o) Chris Marquez Oracle DBA HEYMONitor(tm) - heymonitor.com "Oracle Monitoring & Alerting Solution" PS For the recorded I should point out, that I have a client that has only 2 databases... ...and I do NOT centralize that backup...they run from cron on each database server...call me a hypocrite. -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of DENNIS WILLIAMS Sent: Wednesday, February 02, 2005 11:37 AM To: oracle-l@freelists.org Subject: RE: RMAN - Local vs. central backup script Thanks everyone for sharing your views on this topic. After reviewing the advantages of each configuration, it looks like we will initially go with scripts that are local to target server. We are backing up to disk, and using image copies for cold backups. We are also looking at online image file copies in the future. It seems 10g is enhancing the imagefile copy capability. When I mentioned where the executable runs, I mis-spoke (thanks Mladen), and really should have mentioned the RMAN Client Compatibility. In the 10g documentation there is a compatibility discussion of the RMAN client versions. My understanding is that with a local script, the local RMAN client is used, so there should be no compatibility issues. We have also found character set issues that we feel are due to using a remote client. Again, thanks everyone for your input. Dennis Williams DBA Lifetouch, Inc. -----Original Message----- From: Mercadante, Thomas F [mailto:thomas.mercadante@labor.state.ny.us]=20 Sent: Wednesday, February 02, 2005 7:24 AM To: 'Paula_Stankus@doh.state.fl.us'; Mercadante, Thomas F; DENNIS WILLIAMS; oracle-l@freelists.org Subject: RE: RMAN - Local vs. central backup script 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@doh.state.fl.us [mailto:Paula_Stankus@doh.state.fl.us]=20 Sent: Tuesday, February 01, 2005 4:05 PM To: thomas.mercadante@labor.state.ny.us; DWILLIAMS@LIFETOUCH.COM; oracle-l@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....???=20 -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Mercadante, Thomas F Sent: Tuesday, February 01, 2005 2:37 PM To: 'DWILLIAMS@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@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? =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 ______________________________________________________________________ -- 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=3Ds&i=3D22912776&m=3D40c7= 36055 81a Not spam: https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Dn&i=3D22912776&m=3D40c7= 36055 81a Forget vote: https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Df&i=3D22912776&m=3D40c7= 36055 81a ------------------------------------------------------ END-ANTISPAM-VOTING-LINKS ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email=20 ______________________________________________________________________ -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l