RE: automate backup and export
John What is your intention? If you have created a test Oracle database on your Linux system just to learn, then just shut the database down and back up all files. If you have some important data in this database that changes frequently, then you need to learn about Oracle backup & recovery. More than a simple script, you need to understand your backup and recovery requirements as well as your scripts so you can ensure the requirements are being met. And you need to test your backup because a crash is no time to find out your method was flawed. All of this is much broader than we can cover in a few short emails or even a web site. Oracle Education teaches a nice week-long course on this. I found the book Oracle Backup & Recovery 101 by Smith and Haisley to be an excellent tutorial for the various types of Oracle backup methods. They take you step-by-step through tutorials on the different methods. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Saturday, December 13, 2003 7:19 AM To: Multiple recipients of list ORACLE-L Any reference concerning the rman? - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, December 12, 2003 10:19 PM > Yes. It's called "RMAN". > On 12/12/2003 02:04:46 PM, John wrote: > > Do you know any script for doing export and backup of Oracle 9i R2 server? > > > > My oracle is on a SuSE linux. > > Mladen Gogala > Oracle DBA > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mladen Gogala > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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.net -- Author: John INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: automate backup and export
In addition to that, you don't need any expensive software. The original poster said that his platform is SuSE. Well, I'm on RH-9, which is almost the same. Almost. When I want to back up a database, I write 700M backup pieces to the filesystem that I have for this purpose and use xdroast to write it down to CDs. In connection to this, I have a question: is anybody using DVD writer on Linux? DVD writers themselves have several standards and I'm not sure which one should I buy. I'm starting to pay atention but I'm not quite sure what would be the right choice. On 2003.12.13 12:49, Paul Drake wrote: > John, > > Oracle publishes reference material available on OTN. > You can sign up for an account on http://otn.oracle.com, where you can find their > documentation and articles. > > for example: > > Configuring Oracle Recovery Manager > http://otn.oracle.com/oramag/oracle/02-nov/o62support.html > > or the RMAN Reference Manual: > > http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96565/toc.htm > > > There exist a multitude of Oracle User Groups, where people (users) publish papers > and present material. > > Check out http://www.ooug.org - click on "Presentations" - Joe Testa presented on > RMAN Concepts in the April 2003 meeting. > > that's a start. > > Others have recommended Robert Freeman's Oracle 9i Backup and Recovery book under > Oracle Press. I have a copy, but haven't read it enough to recommend it. > > If you have installed Oracle Enterprise Manager with a repository, you can use RMAN > transparently via OEM. > > Pd > > John <[EMAIL PROTECTED]> wrote: > Any reference concerning the rman? > > > - Original Message - > To: "Multiple recipients of list ORACLE-L" > Sent: Friday, December 12, 2003 10:19 PM > > > > Yes. It's called "RMAN". > > On 12/12/2003 02:04:46 PM, John wrote: > > > Do you know any script for doing export and backup of Oracle 9i R2 > server? > > > > > > My oracle is on a SuSE linux. > > > > Mladen Gogala > > Oracle DBA > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Mladen Gogala > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > > San Diego, California -- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (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.net > -- > Author: John > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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). > > - > Do you Yahoo!? > New Yahoo! Photos - easier uploading and sharing -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: automate backup and export
John, Oracle publishes reference material available on OTN. You can sign up for an account on http://otn.oracle.com, where you can find their documentation and articles. for example: Configuring Oracle Recovery Manager http://otn.oracle.com/oramag/oracle/02-nov/o62support.html or the RMAN Reference Manual: http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96565/toc.htm There exist a multitude of Oracle User Groups, where people (users) publish papers and present material. Check out http://www.ooug.org - click on "Presentations" - Joe Testa presented on RMAN Concepts in the April 2003 meeting. that's a start. Others have recommended Robert Freeman's Oracle 9i Backup and Recovery book under Oracle Press. I have a copy, but haven't read it enough to recommend it. If you have installed Oracle Enterprise Manager with a repository, you can use RMAN transparently via OEM. PdJohn <[EMAIL PROTECTED]> wrote: Any reference concerning the rman?- Original Message -To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>Sent: Friday, December 12, 2003 10:19 PM> Yes. It's called "RMAN".> On 12/12/2003 02:04:46 PM, John wrote:> > Do you know any script for doing export and backup of Oracle 9i R2server?> >> > My oracle is on a SuSE linux.>> Mladen Gogala> Oracle DBA> --> Please see the official ORACLE-L FAQ: http://www.orafaq.net> --> Author: Mladen Gogala> INET: [EMAIL PROTECTED]>> Fat City Network Services -- 858-538-5051 http://www.fatcity.com> San Diego, California -- Mailing list and web hosting services> -> To REMOVE yourself fr! om this mailing list, send an E-Mail message> to: [EMAIL PROTECTED] (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.net-- Author: JohnINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for o! ther information (like subscribing). Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing
Re: automate backup and export
Any reference concerning the rman? - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, December 12, 2003 10:19 PM > Yes. It's called "RMAN". > On 12/12/2003 02:04:46 PM, John wrote: > > Do you know any script for doing export and backup of Oracle 9i R2 server? > > > > My oracle is on a SuSE linux. > > Mladen Gogala > Oracle DBA > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mladen Gogala > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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.net -- Author: John INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: automate backup and export
Yes. It's called "RMAN". On 12/12/2003 02:04:46 PM, John wrote: > Do you know any script for doing export and backup of Oracle 9i R2 server? > > My oracle is on a SuSE linux. Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: automate backup and export
The scripts depend on your set up and environment. Cold backup.. Shutdown database copy all datafile,controlfiles,.ora files, etc to a separate disk startup database Hot backup.. place the tablespace in backup mode copy the datafile to a different disk place the tablespace in normal mode ... copy archivelogs to separate disks. .. exports... Create parfiles with the export commands you want. use cron to execute the exp command with the parfile.. Use RMAN as an easy and effective alternative. Ron >>> [EMAIL PROTECTED] 12/12/2003 2:04:46 PM >>> Do you know any script for doing export and backup of Oracle 9i R2 server? My oracle is on a SuSE linux. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
