Re: Clone Database

From: Shaibal Talukder <shaibal_talukder_at_hotmail.com>
Date: Tue, 07 May 2002 13:47:25 -0800
Message-ID: <F001.0045AA21.20020507134725@fatcity.com>

Ramon,

CORRECTION: In step 2. I meant "log files" not "rbs"

-Shaibal

>From: "Shaibal Talukder" <shaibal_talukder_at_hotmail.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: Clone Database
>Date: Tue, 07 May 2002 13:28:41 -0800
>
>
>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).

---

Join the world’s largest e-mail service with MSN Hotmail. http://www.hotmail.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:47:25 CDT