Re: How to copy an instance on same unix server?

I use database cloning for our environment, but don't use your method. ie. backup control file to trace etc.etc.etc.

I use the following ...
1. I shutdown the database,
2. copy all database files at the operating system level to the new location,

3. Make sure the parameter file for this new location is setup.
4. startup nomount
5. create controlfile reuse set database .....
6. alter database open resetlogs
7. alter database rename global_name to ...

What are your thoughts with regards to this...? Have been using it for a while and is very clean and simple....

Regards
Mark

Howard J. Rogers <howardjr_at_www.com> wrote in message news:3b56669e_at_usenet.per.paradox.net.au...
> Ed, you don't copy Instances. You copy databases.
>
> And to rename the copy, all you need is the trace file generated by 'alter
> database backup controlfile to trace'.
>
> But it's tricky, so I might just point you instead to my own home-brew
> instructions on cloning a database, at
> http://www.geocities.com/hjroz2000/backup_and_recovery.htm
>
> HTH
> Regards
> HJR
>
>
> "Ed Wong" <ewong_at_mail.com> wrote in message
> news:a5ae1554.0107181313.36e4d49a_at_posting.google.com...
> > Hi,
> >
> > I need to create a copy of a 30GB instance on an unix server so that I
> > have two identical instance running for testing purpose. Is there any
> > fast way to do it beside the slow export/import? I thought about copy
> > all datafiles and rename it but I don't think I can change the db_name
> > to make the instance unique right?
> >
> > Thanks.
> >
> > 8.1.7EE/Sun Solaris 2.7
>
>
Received on Fri Jul 20 2001 - 06:08:36 CDT