Re: create new oracle using copies of dbf files

From: <sybrandb_at_hccnet.nl>
Date: Thu, 21 Jun 2007 00:11:37 +0200
Message-ID: <pd9j73t4jvie2dns719auhjbp2vmalj0eo@4ax.com>

On Wed, 20 Jun 2007 14:29:13 -0700, rich <rschneid_at_nsf.gov> wrote:

>Sybrand, I am sorry. I missed something. I have 2 posts going. One
>on -if there is a way to recover triggers- and this one on recreating
>the entire db as it was. The best suggestion that I saw in the
>triggers one was to use "Strings". Which I have done. I am going
>thru a 13,000 page word document and slowly extracting pl/sql code.
>Its working, but its painful. Was that the exact procedure you are
>referring to? If there is another one, I missed it. Not trying to be
>dense here, really just want to make sure that I have exhausted all
>possibilities.
>
>Rich S.
>

From my previous reply in the other thread You could try to
- run alter database backup controlfile to trace on the original database.
- edit the trace file you get (it has a 'create controlfile ' statement in it), making sure

- you change the SID
- you change the database name
- you rename all files to the restored files
- then you set up a correct init<sid>.ora using the sid and the

database name you used in the previous step. - then (important) you cross your fingers and *pray* - then you run the create controlfile statement on the new database.

In normal cases, this is the exact procedure to 'clone a database'.

-- 
Sybrand Bakker
Senior Oracle DBA

Received on Wed Jun 20 2007 - 17:11:37 CDT