Message-ID: <F001.005D9D0B.20031213174425@fatcity.com>
Date: Sat, 13 Dec 2003 17:44:25 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: ml-errors@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: DENNIS WILLIAMS <DWILLIAMS@LIFETOUCH.COM>
Subject: RE: automate backup and export
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain;	charset="iso-8859-7"
Content-Transfer-Encoding: 7bit

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@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@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@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@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@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@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@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@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).