Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Automating or scheduling backups from OEM on NT 4.0

RE: Automating or scheduling backups from OEM on NT 4.0

From: Denmark Weatherburne <denmark_weatherburne_at_hotmail.com>
Date: Wed, 22 Aug 2001 14:25:53 -0700
Message-ID: <F001.0037469B.20010822142527@fatcity.com>

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).
Received on Wed Aug 22 2001 - 16:25:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US