Topic: Backup & Recovery >> ORA-01503: CREATE CONTROLFILE failed
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: ORA-01503: CREATE CONTROLFILE failed |
| jmiller |
Posted: Jan 04, 2005 04:44:18 PM |
Total Post: 3
Joined: Jan, 2003
|
Hi All,
I am trying to rename a database using control file and getting following error.
ORA-01503: CREATE CONTROLFILE failed
ORA-01161: database name PROD01 in file header does not match given name of PROD
I generated following script from trace.
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "PROD" RESETLOGS ARCHIVELOG
-- SET STANDBY TO MAXIMIZE PERFORMANCE
MAXLOGFILES 16
MAXLOGMEMBERS 2
MAXDATAFILES 30
MAXINSTANCES 1
MAXLOGHISTORY 449
LOGFILE
GROUP 1 (
'/u02/oradata/PROD/log1a.log',
'/u03/oradata/PROD/log1b.log'
) SIZE 1M,
GROUP 2 (
'/u02/oradata/PROD/log2a.log',
'/u03/oradata/PROD/log2b.log'
) SIZE 1M
-- STANDBY LOGFILE
DATAFILE
'/u02/oradata/PROD/system_01.dbf',
'/u02/oradata/PROD/undotbs_01.dbf',
'/u02/oradata/PROD/rmandata_01.dbf',
'/u02/oradata/PROD/users_01.dbf'
CHARACTER SET US7ASCII
;
Can you tell me what is wrong here? This is very urgent so please reply asap.
Thanks
J |
|
|
 Vigyan |
| Posted: Jan 04, 2005 05:40:46 PM |  |
|
Total Post: 386
Joined: May, 2001
|
In order to create the new controlfile for the new database you must use the word 'SET' in the CREATE CONTROLFILE COMMAND. The SET DATABASE command is what enables the changes to the name of the database.
Replace reuse with set in your script.
Vigyan
|
|
|
|
|
| jmiller |
| Posted: Jan 05, 2005 10:36:53 AM | |
|
Total Post: 3
Joined: Jan, 2003
|
Thank you so much.. control file is created.
J
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 843 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 272 |
| neeraj sharma | 252 |
| Ramesh Jois | 245 |
| Bishal Khetan | 207 |
|
|
