Re: Help needed performing an offline oracle backup using Arcserve

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 - 03:38:32 CDT