Re: Help needed performing an offline oracle backup using Arcserve

Why don't you open a DOS windows, and type "oradim /?" (without the quotes).

Then you could answer your own question.

:-|

"Badbark" <badbark_at_hotmail.com> wrote in message news:e7da9094.0306250038.78d2f08b_at_posting.google.com...
> Thanks for the advice guys.
> A 695 page book on Oracle backup and recovery! Oh shit, seems like
> this could be a lot more difficult than I thought.
>
> So if I understand correctly the following would stop the Oracle
> Service on my Server-
>
> oradim -shutdown -SID OracleServiceLive [-USRPWD] [-SHUTMODE i]
>
> What about starting it up again?
>
> Thanks
> Badbark
>
> Brian Peasland <oracle_dba_at_remove_spam.peasland.com> wrote in message
news:<3EF863B6.8B15A8BC_at_remove_spam.peasland.com>...
> > In addition, it would probably be a very good idea to read up on Oracle
> > backup & recovery procedures. You have the Oracle docs at your disposal,
> > or Oracle 8i Backup & Recovery Handbook by Velpuri & Adkoli on Oracle
> > Press.
> >
> > HTH,
> > Brian
> >
> > Badbark wrote:
> > >
> > > An apology in advance if this post is long winded and confusing. My
> > > company has recently purchased and installed Sample Manager (LIMS)
> > > which is an Oracle Database. It's my job to backup the Server which
> > > this LIMS software runs on.
> > > Unfortunately, I know nothing about Oracle and need help performing an
> > > offline backup. The Server is Windows 2000, Oracle version 8.1 and I
> > > have Arcserve 9 backup software.
> > > I don't have the Arcserve Oracle backup agent as the DB is only
> > > required between 8am and 6pm and my company doesn't mind losing a days
> > > work. All I really need to do is shut down Oracle with a batch file,
> > > perform a full offline backup and start up Oracle again every night. I
> > > do this already with a few SQL Servers without much bother using
> > > Arcserves PRE and POST options.
> > > What I really need to know is how to take Oracle and LIMS offline
> > > using commands so that I can create a batch file to do this. With SQL
> > > this is easy because all you need to do is net stop MSSQLServer.
> > > However, I notice the following Oracle Services that are started ?
> > > OracleOraHome81Agent, OracleOraHome81DataGatherer,
> > > OracleOraHomeHTTPServer, OracleOraHome81TNSListener, OracleServiceLIVE
> > > and OracleServiceTEST. There are also the following LIMS services
> > > running ? smpbackLIVE, smpbackTEST, smpLIVE, smplock, smpTEST, smwLIVE
> > > and smwTEST.
> > > The three sm LIVE Services are all dependant on OracleServiceLIVE.
> > > Do I need to stop all these Services before performing an offline
> > > backup? Or do I only need to stop OracleServiceLIVE and its
> > > dependencies? If so what is the command? Could it be as simple as net
> > > stop oracle? What about the LIMS Services ? they will obviously stop
> > > when I stop Oracle but what about starting them again?
> > >
> > > In case it is important the DB is only a few GB and not expected to
> > > grow too large.
> > > Any help would be greatly appreciated. Do you need any other info?
> > >
> > > Thanks
> > > Badbark.
> >
> > --
> > ===================================================================
> >
> > Brian Peasland
> > oracle_dba_at_remove_spam.peasland.com
> >
> > Remove the "remove_spam." from the email address to email me.
> >
> >
> > "I can give it to you cheap, quick, and good. Now pick two out of
> > the three"
Received on Wed Jun 25 2003 - 06:17:36 CDT