Re: RMAN on Windows Server
- From: Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>
- To: Robert Freeman <robertgfreeman@xxxxxxxxx>
- Date: Tue, 1 Dec 2009 14:05:50 -0300
I'm working for a VERY large global company, and they still have about 40%
of their databases on Windows. And this introduces a whole new problem,
since we can't actually create local users, we use our domain accounts to
schedule tasks, and as our passwords change, the scheduled tasks become
invalid. Due to compliance issues, we are still not authorized to create a
Service Account in order to schedule the tasks... so we started moving away
from windows task scheduler.
I'd say windows is an OS for desktop computers... not enterprise servers.
I'd much rather run linux (even RedHat) on any machine that supports
windows. And have a very robus environment on which to run Oracle... as
opposed to the Blue-Screen-Maker...
</rant>
Alan Bort
Oracle Certified Professional
On Tue, Dec 1, 2009 at 1:44 PM, Robert Freeman <robertgfreeman@xxxxxxxxx>wrote:
> 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
> Blog: http://robertgfreeman.blogspot.com
>
>
> ------------------------------
> *From:* Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>
> *To:* bill@xxxxxxxxxxxx
> *Cc:* "Oracle-L@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
> *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...
>
> hth
> Alan Bort
> Oracle Certified Professional
>
>
> On Tue, Dec 1, 2009 at 1:03 PM, Bill Zakrzewski <bill@xxxxxxxxxxxx> 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--
>> //www.freelists.org/webpage/oracle-l
>>
>>
>>
>
Other related posts:
