RE: problem in creating control file?

[Robertson Lee - lerobe]

Hi,   I think you need the SET keyword in there.   ie.   CREATE CONTROLFILE SET DATABASE "TEST2" RESETLOGS ARCHIVELOG   HTH   Lee -----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. The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system.