Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Duplicating an instance
Hi !
You can have some pb because two db with the same name are running on you r system
You have to recreate the controlfile:
ALTER DATABASE backup control file to trace;
Shutdown the instance
modify the initSID.ora (dbname = TEST)
take the trace
modify the generated file and set
CREATE CONTROL FILE SET DATABASE "TEST" ......
then run it.
Shutdown and startup your database
You have rename your d !
Regards.
fabriceh <fabriceh_at_netcourrier.com> a écrit dans le message :
7uk8jn$7rq$1_at_oceanite.cybercable.fr...
> Hello,
> I have to duplicate a production instance to have a test instance.
> I don't want to use import/export features, because it's long and
> complicate.
> So I do that,
> I duplicate all files, (instance down of course)
> Specify new control file on INITprod.ORA,
> Mount the database,
> Rename all files using copied files.
> Open the database.
> rename database using : ALTER DATABASE RENAME GLOBAL_NAME TO test
> Close the Database.
> Respecify original control files for INITprod.ORA,
> Create a new init file (say INITtest.ORA) for the new Database.
> It seems to work, I have after less than 1 hour the two databases running
> together on the same system.
> But, for the new init.ora (INITtest.ORA), I have to specify DB_NAME=prod,
> the same as in INITprod.ORA.
> I'm not sure that will not cause any problem.
> Any help ?
> Fabrice HELMBACHER
>
>
Received on Wed Oct 20 1999 - 09:20:13 CDT