RE: RMAN - Local vs. central backup script
- From: <Paula_Stankus@xxxxxxxxxxxxxxx>
- To: <thomas.mercadante@xxxxxxxxxxxxxxxxx>, <DWILLIAMS@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 2 Feb 2005 08:44:43 -0500
Okay,
Let me document them. Basically, I have one script for setup that is
parameterized. I run this script to register the database and put in
the standard "stored" scripts. I started this approach before it became
possible (with later versions of RMAN) to have a global script - which I
think is true now.
Then I have a "calling" script which includes checking for archivelog
mode..... And then generates a log and parses the log and sends an email
- good or bad.
I wrote these scripts when I was working on Oracle 7 and with minor
changes they have worked very well throughout the years. Now, they
likely could be improved with the functionality currently available in
RMAN (in later releases) - but since they have worked reliably.........
I will send them to you Tom directly with documentation. I have to get
through this DATA CLEANSING FROM HELL ISSUE first.
=20
-----Original Message-----
From: Mercadante, Thomas F [mailto:thomas.mercadante@xxxxxxxxxxxxxxxxx]=20
Sent: Wednesday, February 02, 2005 8:24 AM
To: Stankus, Paula G; Mercadante, Thomas F; DWILLIAMS@xxxxxxxxxxxxx;
oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxxxx
[mailto:Paula_Stankus@xxxxxxxxxxxxxxx]
Sent: Tuesday, February 01, 2005 4:05 PM
To: thomas.mercadante@xxxxxxxxxxxxxxxxx; DWILLIAMS@xxxxxxxxxxxxx;
oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mercadante, Thomas F
Sent: Tuesday, February 01, 2005 2:37 PM
To: 'DWILLIAMS@xxxxxxxxxxxxx'; 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@xxxxxxxxxxxxx]
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
--
//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
BEGIN-ANTISPAM-VOTING-LINKS
------------------------------------------------------
Teach CanIt if this mail (ID 22968681) is spam:
Spam:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Ds&i=3D22968681&m=3D50d8=
f4ee2
4ae
Not spam:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Dn&i=3D22968681&m=3D50d8=
f4ee2
4ae
Forget vote:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Df&i=3D22968681&m=3D50d8=
f4ee2
4ae
------------------------------------------------------
END-ANTISPAM-VOTING-LINKS
--
//www.freelists.org/webpage/oracle-l
Other related posts:
