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. [EMAIL PROTECTED] -----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:[EMAIL PROTECTED]] > 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:[EMAIL PROTECTED]> > To: Multiple recipients of list ORACLE-L > <mailto:[EMAIL PROTECTED]> > 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: [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).