|
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. |
dbainblk.gif
Description: GIF image
The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail.
This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification.
tech.gif
Description: GIF image
