RE: problem in creating control file?

[RAJESH DAYAL]

USE COMMAND LIKE …….   CREATE CONTROLFILE  SET DATABASE "TEST2" RESETLOGS ARCHIVELOG ……….. HTH, Rajesh -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bunyamin K. Karadeniz Sent: Tuesday, March 12, 2002 3:48 PM 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.