Re: Copying a database

From: Ken White <kwhite_at_tier.com.au>
Date: Tue, 27 Apr 1999 17:26:08 +1000
Message-ID: <7g3os3$epu$1@black.interact.net.au>

I have done this several times although I also needed to change the SID. If you do not need to change the SID what you have outlined should work. If you need to change the SID, you also need to edit the create control file statement to do a SET DATABASE to the new name. You should also rename the global name.

HTH
Ken White

a_merar_at_my-dejanews.com wrote in message <7fuauo$g2j$1_at_nnrp1.dejanews.com>...
>
>
>Hello,
>
>I want to copy my database and create a new one for some special testing
>purposes. I'm not sure how to do it, I just have an idea and wanted to
know
>if this was correct:
>
>First I'd backup the control file to trace and change any and all
references
>that pointed to the old database or old datafiles to the new ones. Then
I'd
>do a simple OS copy of the datafiles and then log in SVRMGR and run the
>script to rebuild the new control file.
>
>Is that about right? I feel that I am missing some steps......do I need to
>export?
>
>Any help would be appreciated. Please send responses to e-mail.....
>
>Thanks,
>
>Arthur
>amerar_at_unsu.com
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Apr 27 1999 - 02:26:08 CDT