 | |
Re: Help needed performing an offline oracle backup using Arcserve
comp.databases.oracle.server comp.databases.oracle.server
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Re: Help needed performing an offline oracle backup using Arcserve -
06-24-2003
, 09:44 AM
|
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 (DOT) 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"
#2
| |||
| |||
|
|
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 (DOT) 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" |
#3
| |||
| |||
|
|
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 (DOT) peasland.com> wrote 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 (DOT) 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" |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.