RE: Backup and Recovery

Thanks to all who replied to me regarding Back-up. I think RMAN will be good choice for Back.up.

Thanks and regards,
Santosh

-----Original Message-----
WILLIAMS
Sent: Monday, February 10, 2003 7:24 PM
To: Multiple recipients of list ORACLE-L

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Santosh Varma
  INET: vsantosh_at_psi.soft.net

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