Oracle-L: RE: Backup and Recovery

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Mon, 10 Feb 2003 05:53:39 -0800
Message-ID: <F001.00548347.20030210055339@fatcity.com>

Santosh - You might consider locating an Oracle consultant with experience in backup and recovery procedures to help this client. If the client is paying you under the assumption that you are an Oracle backup and recovery expert, you may be misleading them. Honesty builds long-term relationships.

Be sure the client has archive logging turned on. This increases the options in a backup situation.

Oracle backup discussions tend to be complex because Oracle is used at such a wide variety of sites, all of which have individual requirements. Here is a discussion of some of the issues. http://www.experts-exchange.com/Databases/Oracle/Q_20223776.html

<http://www.experts-exchange.com/Databases/Oracle/Q_20223776.html> 
    Short-term, consider implementing a cold backup strategy. This involves
shutting the database down and backing up all the data files.

Then talk to the client about what their goal are. If the database is small and not used off-hours, cold backup may be adequate. If the database is continually used, but the site has no plans to expand greatly, a hot backup scheme may be satisfactory. Otherwise, consider Oracle's RMAN utility which is included with Oracle.

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Monday, February 10, 2003 5:44 AM
To: Multiple recipients of list ORACLE-L

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: 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). Received on Mon Feb 10 2003 - 07:53:39 CST