Re: Clone Database

From: Shaibal Talukder <shaibal_talukder_at_hotmail.com>
Date: Tue, 07 May 2002 13:28:41 -0800
Message-ID: <F001.0045A95C.20020507132841@fatcity.com>

Ramon,

Following are the steps:

1.Shutdown the database(target db) on which you are restoring. 2.Restore all the necessary files(datafiles, rbs, archive logs,etc) on the the target db from the hot backup of the production db.

3.Create the create control file script by "ALTER DATABASE BACKUP CONTROLFILE TO TRACE" command in the production sever. 4.ftp the trace file to the target db.
5.Edit the trace file to reflect the new pathnames(the pathnames for the files in the target database)
6.Change the "CREATE CONTROLFILE REUSE" line to read "CREATE CONTROLFILE SET NEW_DB_NAME(target db name) RESETLOGS"
7.Change the "RECOVER DATABASE" line to read "RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL"
8.echo $ ORACLE_SID to make sure it is the target database 9. Run the trace script as "CONNECT INTERNAL"

10.Oracle will prompt for archive log
11. Once you are done applying logs then type "CANCEL" and press <RET>
12."ALTER DATBASE OPEN RESETLOGS"

the database should now be runing.

ASSUMPTIONS: You are running in Archivelog mode.

This should work.

Shaibal

>From: "Ramon E. Estevez" <com.banilejas_at_codetel.net.do>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Clone Database
>Date: Tue, 07 May 2002 06:28:40 -0800
>
>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

---

Send and receive Hotmail on your mobile device: http://mobile.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shaibal Talukder
  INET: shaibal_talukder_at_hotmail.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 - 16:28:41 CDT