OraFAQ Forum: Server Administration » Create a new control file

Home » RDBMS Server » Server Administration » Create a new control file (Oracle 10g, Windows 7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Create a new control file [message #560324]

Thu, 12 July 2012 02:49

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.

Report message to a moderator

Re: Create a new control file [message #560325 is a reply to message #560324]

Thu, 12 July 2012 02:51

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Create a new control file [message #560326 is a reply to message #560325]

Thu, 12 July 2012 02:59

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 02:24:13 CST 2024