RE: Automating or scheduling backups from OEM on NT 4.0

Hi Denmark,
Go to:
http://windowsupdate.microsoft.com/

Download and install IE5.5 SP2. Do a custom install to ensure the Offline Browsing Pack is selected. I believe it is part of it.

I was just reading some mail from one of the members, Eric Pierce, who supplied this URL which may be useful:

http://www.ultratech-llc.com/KB/?File=TaskSched.TXT

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 04:25 PM

> To:   Multiple recipients of list ORACLE-L

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

> 

> Thanks Chris,

> 

> I did a search for *scheduler* on my drives but I found no scheduler that 

> came with IE5.5

> What is the name of the executable and where is it installed?

> If I need to downlaod it, what is the downloadable zip filename?

> 

> Thanks,

> 

> Denmark W.

> 

> 

> >From: "Guidry, Chris" <chris.guidry_at_atcoelectric.com>

> >Reply-To: ORACLE-L_at_fatcity.com

> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>

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

> >Date: Wed, 22 Aug 2001 12:40:47 -0800

> >

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

> 

> 

> _________________________________________________________________

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