Re: Renaming databases

I performed the followin procedures successfully to change the name of a database:

1. backup control file to trace.
2. modify control file script
   • set new dbname
   • Take out the "reuse" option
   • Change noreset logs to resetlogs
3. Change the init.ora file to contain new dbname
4. Specify "new" control files in init.ora file
5. Run control file script
6. shutdown
7. startup mount
8. alter database open resetlogs
9. shutdown
10. open new database

Ricardo Williams

Jim Collier <jcollier_at_mb.sympatico.ca> wrote in article <332738A5.2F6B_at_mb.sympatico.ca>...
> Hello
>
> I want to rename a database from one name to another. Oracle is giving
> me an error 12206 saying the database id does not match in the
> system file SYS1BBBB.ORA.
>
> I performed the following steps.
>
> 1. Shutdown the database AAAA.
> 2. Made a complete copy of a database system who's system id is AAAA by
> copying of all AAAA's files in another subdirectory.
> 3. Copy all initialization and password files belonging to AAAA in
> the %ORACLE_HOME%\DATABASE to the coresponding files for BBBB.
> directory to there coresponding
> initialization parameters from AAAA to a new system ID BBBB.
> 4. Created the appropriate SQLNET files to include both AAAA and BBBB.
> 5. Stared up the listener, AAAA and BBBB via the control panel services
> (This is ORACLE Workgroup for NT by the way).
> 6. BBBB fails to open the database due to the changed system id in
> my SYS1BBBB.ORA file (it will probably happen in all the other
> files as well)
>
> I'd appreciate in hearing from you if you could shed some light on how to
 

> set to the correct system id. Would re-creating the control file work?
>
> Thanks
> Jim Collier
>
  Received on Tue Apr 22 1997 - 00:00:00 CDT