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.
dwilliams_at_lifetouch.com

-----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" <ORACLE-L_at_fatcity.com> 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: mladen_at_wangtrading.com
>
> 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: ListGuru_at_fatcity.com (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: sc00170_at_cc.uoi.gr

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: ListGuru_at_fatcity.com (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: DWILLIAMS_at_LIFETOUCH.COM

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: ListGuru_at_fatcity.com (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).