|
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
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.
___________________________________________________________________________
| 