Re: Help needed performing an offline oracle backup using Arcserve

The CLI command to stop an Oracle server is:

oradim -shutdown -SID xxxx [-USRPWD] [-SHUTMODE yyy]

Replace xxx with the actual name of your service (and since the other services are, as you say, dependent on OracleServiceLIVE, they will be dealt with automatically if you put 'LIVE' in there).

Supply SYS's password if you are using a password file, but don't bother if you are a member of the ORA_DBA local group (and thus using O/S authentication).

Shutdown will, by default, be of the 'immediate' type (there's a registry setting to establish what the default shutdown mode should be, and I believe it's immediate by default... but it might vary, or have been varied by someone in your organisation). Therefore, to be certain, supply either "a", "i" or "n" (without the quotes) where I've got 'yyy' above. That means 'abort', 'immediate' or 'normal'.

If you're doing offline backups, you want either immediate or normal. And
normal is probably too 'polite', and so immediate is probably your best bet
(it throws users off the system, but then does a clean shutdown).

Don't forget to test and test and test before thinking you've cracked it. In particular, your backup doesn't work until you can prove you can restore it!

;-^

"Badbark" <badbark_at_hotmail.com> wrote in message news:e7da9094.0306240315.78349e99_at_posting.google.com...
> 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.
Received on Tue Jun 24 2003 - 09:05:39 CDT