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

From: Howard J. Rogers <howardjr_at_www.com>
Date: Thu, 19 Jul 2001 14:49:32 +1000
Message-ID: <3b56669e@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 Wed Jul 18 2001 - 23:49:32 CDT