Home » RDBMS Server » Server Administration » Create a new control file (Oracle 10g, Windows 7)
Create a new control file [message #560324] Thu, 12 July 2012 02:49 Go to next message
bg1984
Messages: 21
Registered: July 2012
Junior Member
Hi All,

I am trying to create a new controlfile. I used "alter database backup controlfile to trace;" and then I copied and pasted the contents of the trace file into the .sql file. My sql script is
CREATE CONTROLFILE SET DATABASE "FIVESTAR" RESETLOGS NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 'F:\ORACLE\PRODUCT\10.2.0\ORADATA\STAR\REDO01.LOG' SIZE 50M,
GROUP 2 'F:\ORACLE\PRODUCT\10.2.0\ORADATA\STAR\REDO02.LOG' SIZE 50M,
GROUP 3 'F:\ORACLE\PRODUCT\10.2.0\ORADATA\STAR\REDO03.LOG' SIZE 50M
-- STANDBY LOGFILE
DATAFILE
'F:\ORACLE\PRODUCT\10.2.0\ORADATA\STAR\SYSTEM01.DBF',
'F:\ORACLE\PRODUCT\10.2.0\ORADATA\STAR\UNDOTBS01.DBF',
'F:\ORACLE\PRODUCT\10.2.0\ORADATA\STAR\SYSAUX01.DBF',
'F:\ORACLE\PRODUCT\10.2.0\ORADATA\STAR\USERS01.DBF',
'F:\ORACLE\PRODUCT\10.2.0\ORADATA\STAR\EXAMPLE01.DBF'
CHARACTER SET AL32UTF8
;
Actually, the name of my database was 'STAR' and I changed it to "FIVESTAR" int this .sql script.
Now when I run this script with SQL> @ <path of my sql script>, it gives me the following errors:
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01504: database name 'FIVESTAR' does not match parameter db_name 'STAR'

Please help me.
Re: Create a new control file [message #560325 is a reply to message #560324] Thu, 12 July 2012 02:51 Go to previous messageGo to next message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You also have to change the database name in init.ora/spfile.

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel
Re: Create a new control file [message #560326 is a reply to message #560325] Thu, 12 July 2012 02:59 Go to previous message
bg1984
Messages: 21
Registered: July 2012
Junior Member
Hi Michel,

Thanks for your really quick reply and Let me try all this and I will get back to you if I get stuck again.

Regards,

Bhavin
Previous Topic: Can I remove the synonym STATS$SNAPSHOT_ID?
Next Topic: Migration Creating the Migration Repository.
Goto Forum:
  


Current Time: Sat Sep 20 17:16:35 CDT 2014

Total time taken to generate the page: 0.07838 seconds