Re: [Q] Duplicate a database and changing the SID

eureka_at_is.co.za wrote:
>
> Hello,
>
> I looking for a script or some advise
> To duplicate a database which is the a 'master'
> (dupicate the data_files the controle files ...)
> change the SID
> and start the copy of the master in oders words it is a clone of my master
> that i need to produce.
>
> (this is for a training databases i have to duplicate that master to a few
> copy on the same machine)
>
> The configuration is the follow:
> Oracle 7.1.4
> Digital OSF1
>
> Please reply as well bye eMail
> eureka_at_is.co.za
>
> THX PatrickThe basic process goes something like this:

1. Alter database backup controlfile to trace; This creates a copy of the controlfile for subsequent editing. This should be done right after a log switch if you are running archive logs.
2. Shut down the instance.
3. Copy the datafiles to the new datafile names.
4. Edit the controlfile, changing all the paths to reflect the new paths for the datafiles.
5. Make a copy of the original init.ora file and modify it to reflect the new controlfile path data.
6. Add the new instance name to /etc/oratab.
7. . oraenv to set the new instance name as the current instance.
8. Startup the new instance.

I may be missing some details here, the detailed checklist I use is at work and I am at home. If you need more, email me direct. 2. Received on Tue Sep 10 1996 - 00:00:00 CEST