Re: RMAN on Windows Server

From: Robert Freeman <>
Date: Tue, 1 Dec 2009 08:44:40 -0800 (PST)
Message-ID: <>

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
Oracle ACE
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 <> To:
Cc: "" <> 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...

Alan Bort
Oracle Certified Professional

On Tue, Dec 1, 2009 at 1:03 PM, Bill Zakrzewski <> wrote:

>All -
>>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,

Received on Tue Dec 01 2009 - 10:44:40 CST

Original text of this message