RE: Automating or scheduling backups from OEM on NT 4.0

Hi,
I suggest you try using the Task Scheduler.

I've had problems in the past using AT and/or WINAT. For some reason certain batches would not run but when I tried Task Scheduler everything worked as expected.

If you have IE5+ then you should already have it installed. If you have IE4 then you can install it as an add-on.

The name of the service is Task Scheduler and you can run it from Administrative Tools and/or My Computer.

HTH

--
Chris J. Guidry  P.Eng.
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: chris.guidry_at_atcoelectric.com



> -----Original Message-----

> From: Denmark Weatherburne [SMTP:denmark_weatherburne_at_hotmail.com]

> Sent: Wednesday, August 22, 2001 11:12 AM

> To:   Multiple recipients of list ORACLE-L

> Subject:      Automating or scheduling backups from OEM on NT 4.0

> 

> Hi DBA's,

> 

> I've recently completed several SQL*Plus scripts and Batch files to do Hot

> 

> backups of our production Oracle 8.0.5 database at 8am, 12pm, and 5pm

> daily.

> Currently, I have to double click the batch file icon which calls SQL*Plus

> 

> and executes the backup script.

> I tried unsuccessfully to use NT's AT and WINAT.EXE commands to schedule

> the 

> execution of the batch jobs. Nothing ran when the scheduled time came.

> Following your advice, I recently downloaded "cygwin" and all the tools,

> but 

> I'm currently trying to get cron working.

> I was advised that OEM for NT has the capability to automate and schedule 

> backups, etc.

> I've started to look at RMAN, but I'm not sure if RMAN is the tool that I 

> need to accomplish my backup/restore automation and scheduling needs.

> I'm comfortable at the command line and with scripts, because I've worked

> in 

> the Solaris environment for a few years, but I know that a lot of tools

> has 

> been built into OEM for NT.

> I'd like to get feedback from DBA's/SA's regarding what implementations

> you 

> have in place to schedule and automate Oracle tasks such as backups, etc.

> I would appreciate your suggestions and recomendations.

> Please provide provide procedures and scripts if possible.

> 

> Thanks for your help!

> 

> Denmark Weatherburne

> "Knowledge is power, but it is only useful if it is shared!"

> 

> 

> 

> _________________________________________________________________

> Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

> 

> -- 

> Please see the official ORACLE-L FAQ: http://www.orafaq.com

> -- 

> Author: Denmark Weatherburne

>   INET: denmark_weatherburne_at_hotmail.com

> 

> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> San Diego, California        -- Public Internet access / Mailing Lists

> --------------------------------------------------------------------

> To REMOVE yourself from this mailing list, send an E-Mail message

> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in

> the message BODY, include a line containing: UNSUB ORACLE-L

> (or the name of mailing list you want to be removed from).  You may

> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Guidry, Chris
  INET: chris.guidry_at_atcoelectric.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).