Re: Urgent! How to copy an instance?

From: Knut Lassmann <knut.lassmann_at_mytoys.de>
Date: Tue, 15 Aug 2000 23:04:49 +0200
Message-ID: <3999B071.EB6E6670@mytoys.de>

Sally Pearce wrote:

> Shut down 'OLD' database. If you have time, cold backup!
> decide on a new SID (lets say 'NEW')
> create a new initNEW.ora file - copy the old one but give it the new name.
> edit the new file to show the new position of the control files
> set ORACLE_SID to NEW
> startup mount

I copied everything but when I try to start mount the new database svrmgrl says:
ORA-01103: database name 'MTPRT' in controlfile is not 'MTABN'

How can I change the controlfile?

Thank you in advance,

Knut Received on Tue Aug 15 2000 - 16:04:49 CDT