Re: RMAN on Windows Server
Date: Tue, 1 Dec 2009 08:44:40 -0800 (PST)
Hmmmm.... I've never had much of a problem with the Windows task scheduler for such things. I will say the Windows Oracle I've dealt with for the most part has been small enterprise (usually running Oracle Standard Edition). Usually 1 or 2 databases at most and limited technical people to support the solution. Typically the medium/large enterprises move away from the WIN platforms (though, I admit, not always). The Win users that I've been involved with often need simple, inexpensive solutions..... When you start talking about Tivoli, Control-M, etc... you are usually talking about money that they are often not willing to spend, because they don't see the benefit or have the budget.
Robert G. Freeman
Ask me about on-site Oracle Training! RMAN, DBA, Tuning, you name it! Author:
Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON IT'S WAY SOON! OCP: Oracle Database 11g Administrator Certified Professional Study Guide (Sybex) Oracle Database 11g New Features (Oracle Press) Oracle Database 10g New Features (Oracle Press) Other various titles
From: Guillermo Alan Bort <cicciuxdba_at_gmail.com> To: bill_at_intactus.com
Cc: "Oracle-L_at_freelists.org" <oracle-l_at_freelists.org> Sent: Tue, December 1, 2009 9:34:43 AM
Subject: Re: RMAN on Windows Server
I use a vbs script. I've seen people code on perl. The RCV scripts are basically the same (format is the only thing that changes). I'd stay away from Windows Task Scheduler unless you want to get into administration HELL.
For automation, I'd go for Tivoli Workload Scheduler, Control-M, Autosys, etc. If you Trust Grid Control it's a good choice.... though I've not used it extensively and EM (at least dbcontrol) has the habit of breaking when you need it...
Another option is DBMS_SCHEDULER, but it's tricky and requires some testing...
Oracle Certified Professional
On Tue, Dec 1, 2009 at 1:03 PM, Bill Zakrzewski <bill_at_intactus.com> wrote:
>>I was just given a database to maintain on Windows, does anyone have a basic RMAN backup script that I can alter to automate an RMAN backup on Windows? I usually work on Linux or Unix and not really familiar with scripting on a Windows server. Any advice on automating the script will be helpful too.
>>Windows Server 2003 SP2
>>Thanks in advance,