Home » RDBMS Server » Backup & Recovery » Loss of Controlfile
Loss of Controlfile [message #238456] Fri, 18 May 2007 02:22 Go to next message
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 #238465 is a reply to message #238456] Fri, 18 May 2007 03:31 Go to previous messageGo to next message
Michel Cadot
Messages: 68727
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
CREATE CONTROLFILE

Regards
Michel
Re: Loss of Controlfile [message #238470 is a reply to message #238465] Fri, 18 May 2007 03:46 Go to previous messageGo to next message
Frank Naude
Messages: 4586
Registered: April 1998
Senior Member
Also see http://www.orafaq.com/wiki/Control_file_recovery
Re: Loss of Controlfile [message #238613 is a reply to message #238470] Fri, 18 May 2007 13:01 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
hi,

You dont have any backup of ur database??Or only controlfie?
Re: Loss of Controlfile [message #238668 is a reply to message #238613] Fri, 18 May 2007 22:14 Go to previous messageGo to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Hi,

I do have the backup of the datafiles and the logfiles but not the controlfiles.
Re: Loss of Controlfile [message #238669 is a reply to message #238456] Fri, 18 May 2007 22:20 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Launch the text editor you know how to use &
compose the SQL to recreate a controlfile & produce the same results as
ALTER DATABASE BACKUP CONTROLFILE TO TRACE
Re: Loss of Controlfile [message #238687 is a reply to message #238456] Sat, 19 May 2007 01:02 Go to previous message
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
Previous Topic: database cloning using rman
Next Topic: ORA-19511: Error received from media manager layer, error text:
Goto Forum:
  


Current Time: Sat Dec 14 01:02:57 CST 2024