Re: RMAN on Windows Server

From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Tue, 1 Dec 2009 14:34:43 -0200
Message-ID: <172762180912010834j725a187w3ca7d41842efb94e_at_mail.gmail.com>

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...

hth
Alan Bort
Oracle Certified Professional

On Tue, Dec 1, 2009 at 1:03 PM, Bill Zakrzewski <bill_at_intactus.com> 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.
>
> Oracle 10.2.0.4
> Windows Server 2003 SP2
>
> Thanks in advance,
> Bill--
> http://www.freelists.org/webpage/oracle-l
>
>
>

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

Received on Tue Dec 01 2009 - 10:34:43 CST