| Loss of Controlfile [message #238456] |
Fri, 18 May 2007 02:22  |
rsreddy28
Messages: 295
Registered: May 2007
|
Senior Member |
|
|
Hello All,
Can somebody help me in my query.
I've lost my controlfile for which I dont have any backup. I mean I dont have the backup of the controlfile anywhere either on disk or on any tape device.
Can somebody help me in coming out of this situation.
I know how to recreate a controlfile if we have a backup , that is " Alter database backup controlfile to trace ; "
And also how does one recreate a controlfile , if there is no backup, once the database has been created.
I'd be glad if you can explain me in detail of these situations.
bYe,
Raj
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Loss of Controlfile [message #238687 is a reply to message #238456] |
Sat, 19 May 2007 01:02  |
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
|
Senior Member |
|
|
Hi,
And you have to also specify SIZE cluase with DATAFILE specification.
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "taj"
NORESETLOGS [archivelog/noarchivelog]
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 10
MAXINSTANCES 1
MAXLOGHISTORY 113
LOGFILE
GROUP 1 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\TAJ\REDO01.LOG' SIZE 10M,
GROUP 2 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\TAJ\REDO02.LOG' SIZE 10M,
GROUP 3 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\TAJ\REDO03.LOG' SIZE 10M
DATAFILE
'D:\ORACLE\PRODUCT\10.1.0\ORADATA\TAJ\SYSTEM01.DBF' SIZE xxx,
'D:\ORACLE\PRODUCT\10.1.0\ORADATA\TAJ\USERS01.DBF' SIZE xxx,
...
CHARACTER SET [chracater_set]
Regards
Taj
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
