Re: Clone Database

From: Daniel W. Fink <optimaldba_at_yahoo.com>
Date: Tue, 07 May 2002 10:23:31 -0800
Message-ID: <F001.0045A1F0.20020507102331@fatcity.com>

Ramon,

   There is a paper on my site
(http://www.optimaldba.com/library/CreatingOracledbusingphysicalcopy.html) that outlines the procedures to perform this cloning. The document uses 7.3, but the procedures remain the same.

I would also recommend using this time to periodically test your production backups by using the backup files to recover to the development database. This can find problems in your backup/recovery process before a production recovery fails. You don't have to do it each time, but once a month would be a good target.

Just my $.02

• "Ramon E. Estevez" <com.banilejas_at_codetel.net.do> wrote:
  > I have to refresh a development database every day
  > with the production DB.
  > The size of the DB is 70GB and import last like 7
  > hours. Does anyone in the
  > list has the steps to clone a database, not using
  > import.
  >
  > TIA
  >
  > Ramon E. Estevez
  >
  

  ---

Daniel W. Fink
www.optimaldba.com

Do not meddle in the affairs of Dragons. For you are crunchy and taste good with ketchup.

---

Do You Yahoo!?
Yahoo! Health - your guide to health and wellness http://health.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Daniel W. Fink
  INET: optimaldba_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Tue May 07 2002 - 13:23:31 CDT