RE: Backup and Recovery

Thanks Dennis for your information. After I read it maybe I will consider to use RMAN for my daily backup.
I get new knowledgment from you.

Rgrds,

Sony

> -----Original Message-----
> From: DENNIS WILLIAMS [SMTP:DWILLIAMS_at_LIFETOUCH.COM]
> Sent: Tuesday, February 11, 2003 9:40 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Backup and Recovery
>
> Sony
> I'm not Ruth, but perhaps I can provide some helpful information.
> Export is a logical backup. It is useful for recovering from some types
> of failures, but not for others. For example, if I have a small codes
> table
> that doesn't change much, and a developer makes some changes to the table
> that actually corrupt it. Since the table rarely changes I can recover it
> from my export. But suppose instead a production table that receives
> massive
> inserts and updates becomes corrupt near the end of the workday. If I have
> performed hot or cold or RMAN backups and run the database in archivelog
> mode, I can recover that table right up to the last committed transaction.
> You should begin by learning more about the various Oracle backup
> alternatives. A good book to begin with is Oracle Backup & Recovery 101 by
> Kenny Smith and Stephan Haisley. This book covers all types of Oracle
> backups including RMAN.
> RMAN is included with your Oracle installation. It is free with Oracle.
> The best book for RMAN is Oracle9i RMAN Backup & Recovery by Robert
> Freeman
> and Matthew Hart.
> Also visit with your user managers and learn what their backup and
> recovery requirements are. How critical is their data? How long can they
> be
> without their data in the event of a failure? Can you take the database
> down
> each night for a cold backup, or do they need to have the database
> continuously available?
>
> Dennis Williams
> DBA, 40%OCP
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
>
> -----Original Message-----
> Sent: Monday, February 10, 2003 7:29 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi Ruth,
>
> In my company we run export for our daily backup. Why is it not best way
> to
> do backup ? and about RMAN, is it third party program on oracle or it is
> already include in oracle, or if it is a script, would you share it to me
> ?
> I use oracle 9i on windows 2000 server.
>
> TIA,
>
> Sony
>
> > -----Original Message-----
> > From: Ruth Gramolini [SMTP:rgramolini_at_tax.state.vt.us]
> > Sent: Monday, February 10, 2003 9:29 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: Backup and Recovery
> >
> > Export is not the best way to do backup. Have a look at rman, it comes
> > with the rdbms. Ruth
> >
> > ----- Original Message -----
> > From: Santosh Varma <mailto:vsantosh_at_psi.soft.net>
> > To: Multiple recipients of list ORACLE-L
> > <mailto:ORACLE-L_at_fatcity.com>
> > Sent: Monday, February 10, 2003 6:43 AM
> > Subject: Backup and Recovery
> >
> > Hello list,
> >
> > I am implementing a software in Oracle 8.1.7.
> > The client wants to have the backup and recovery procedure. As of
> > now, they are using EXPORT utility.
> > Could any one of you tell me any other utility which the client will
> > be able to use for Backup of their data ?
> >
> > Thanks and Regards,
> > Santosh Varma
> >
> >
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Sony kristanto
> INET: Sony_at_polyfincanggih.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: 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Sony kristanto
  INET: Sony_at_polyfincanggih.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).