RE: problem in creating control file?

[SARKAR, Samir]

What did u do ?? Did u use the command 'alter database backup controlfile to trace' from database TESTDB to generate the 'create controlfile' statement ?? If so, the datafiles in the 'create controlfile' statement should have the name 'TESTDB' as the db name in their header. You can only change the path of the datafile names in the 'create controlfile' statement and not the actual datafile itself while creating the clone. Log on to the TESTDB database again and ascertain whether the datafiles listed in ur 'create controlfile' statement matches those in TESTDB. Modify the 'create controlfile' statement to read : CREATE CONTROLFILE RESUE SET DATABASE "TEST2" RESETLOGS ARCHIVELOG   Hope this helps,   Samir   Samir Sarkar Oracle DBA  SchlumbergerSema Email :  [EMAIL PROTECTED]             [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018            -----Original Message----- From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]] Sent: 12 March 2002 11:48 To: Multiple recipients of list ORACLE-L Subject: problem in creating control file?   I try to clone my database . I have the datafiles on D:\yedek123 and want to create the control files . What I do is : set oracle_sid=new_sid   svrmgrl internal/**** startup nomount pfile=new_pfile   CREATE CONTROLFILE  DATABASE "TEST2" RESETLOGS ARCHIVELOG     MAXLOGFILES 32     MAXLOGMEMBERS 2     MAXDATAFILES 254     MAXINSTANCES 1     MAXLOGHISTORY 1815 LOGFILE   GROUP 1 'D:\yedek123\REDO01.LOG'  SIZE 1M,   GROUP 2 'D:\yedek123\REDO02.LOG'  SIZE 1M,   GROUP 3 'D:\yedek123\REDO03.LOG'  SIZE 1M DATAFILE   'D:\yedek123\SYSTEM01.DBF',   'D:\yedek123\RBS01.DBF',   'D:\yedek123\USERS01.DBF',   'D:\yedek123\TEMP01.DBF',   'D:\yedek123\TOOLS01.DBF',   'D:\yedek123\INDX01.DBF',   'D:\yedek123\DR01.DBF' CHARACTER SET WE8ISO8859P9;   But When I run the create control file script , I am encountering the error below. CREATE CONTROLFILE  DATABASE "TEST2" RESETLOGS ARCHIVELOG * ORA-01503: CREATE CONTROLFILE failed ORA-01161: database name TESTDB in file header does not match given name of TE ST2 ORA-01110: data file 1: 'D:\yedek123\SYSTEM01.DBF' TESTDB is the original database . TEST2 is new DB.   What is the problem ? Thank you.       Bunyamin K. Karadeniz           Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729   The degree of normality in a database is inversely proportional to that of its DBA. ___________________________________________________________________________ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___________________________________________________________________________