RE: Is it possible to copy one db to another if the SID is differ

Hi Yen-wee, I tried but still get the following error message : CREATE CONTROLFILE SET DATABASE TEST RESETLOGS NOARCHIVELOG * ORA-01503: CREATE CONTROLFILE failed ORA-01161: database name PROD in file header does not match given name of TEST ORA-01110: data file 6:

RE: Is it possible to copy one db to another if the SID is differ

Hi, You have to recreate the controlfile as CREATE CONTROLFILE SET DATABASE TEST RESETLOGS ARCHIVELOG. The new database name will be TEST . Pl ensure that the old control files are deleted before recereating the controlfile . Regards Rajendra -Original Message- Sent:

RE: Is it possible to copy one db to another if the SID is differ

hi you have to do a alter database backup controlfile to trace on the source database change all occurrences PROD in TEST in the created backup controlfile the create controlfile reuse has to be create controlfile SET database test oracle note 61590.1 on metalink g.g. kor rdw the netherlands

RE: Is it possible to copy one db to another if the SID is differ

Thanks to those (Venkat, Rajendra and Yen-Wee) who replied. Problem has been resolved. Solution : * Has to use CREATE CONTROLFILE SET DATABASE TEST RESETLOGS ARCHIVELOG * I forgot to delete old control files. Thank you so much. Regds, New Bee -Original

RE: Is it possible to copy one db to another if the SID is differ

One thing to keep in mind (If I recall correctly): If you are using rman repository, the database ID (DBID) of the copied database will be the same as the old database. You will have to create a second schema in the repository if you plan on backing up both the new and the old databases using

RE: Is it possible to copy one db to another if the SID is differ

Title: RE: Is it possible to copy one db to another if the SID is differ or consider note: 174625.1 -Original Message- From: Stephen Lee [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 11:04 AM To: Multiple recipients of list ORACLE-L Subject: RE: Is it possible to copy

RE: Is it possible to copy one db to another if the SID is differ

Fascinating. (attrib. Spock) Didn't know about that one. While we're on the subject, I don't recall if anyone mentioned this, but don't forget about updating the global_name table. -Original Message- Sent: Wednesday, October 09, 2002 10:40 AM To: Multiple recipients of list ORACLE-L

RE: Is it possible to copy one db to another if the SID is differ

Hi, Thanks for those who replied. I've solved the problem. Solution: Use SET database in the CREATE CONTROLFILE command and I forgot to delete the old control files. Regds, New Bee -Original Message- From: Vergara, Michael (TEM) [mailto:[EMAIL