OraFAQ Forum: Backup & Recovery » Recover lost controlfile

Home » RDBMS Server » Backup & Recovery » Recover lost controlfile (Linux oracle 10g)

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

Recover lost controlfile [message #575155]

Sun, 20 January 2013 06:59

adnanDBA
Messages: 3
Registered: January 2013
Location: Karachi

Junior Member

how to recover controlfile i have a complete database backup of dbf file but dont have an autobackup folder it means i dont have spfile and controlfile and the system is totally crash i dont have binary and trace of controlfile and i dont wanna to create new controlfile is there is any other option to recreate controlfile. i create spfile but the main problem i face is to recover controlfile dbf are in backupset compressed. if you guyz have any idea about this scenario.

Report message to a moderator

Re: Recover lost controlfile [message #575159 is a reply to message #575155]

Sun, 20 January 2013 08:57

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

Senior Member
Account Moderator

If you have a control file in a backup then you can recover the control file.
If you have not and don't want to recreate a control file then there is no way to create a control file. It is simple logic.

Regards
Michel

Report message to a moderator

Re: Recover lost controlfile [message #575162 is a reply to message #575155]

Sun, 20 January 2013 13:22

John Watson
Messages: 8988
Registered: January 2010
Location: Global Village

Senior Member

You say that you have a complete backup of the datafiles. In that case, you DO have a backup of the controlfile, because it is always backed up whenever you back up the system tablespace. This is not the autobackup, and it is not possible to disable. Look at this:

RMAN>

RMAN> show CONTROLFILE AUTOBACKUP;

RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default

RMAN> backup datafile 1;

Starting backup at 20-JAN-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=10 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=C:\APP\JOHN\ORADATA\ORCL\DATAFILE\O1_MF_SYSTEM_8GJB3ZVK_.DBF
channel ORA_DISK_1: starting piece 1 at 20-JAN-13
channel ORA_DISK_1: finished piece 1 at 20-JAN-13
piece handle=C:\APP\JOHN\FAST_RECOVERY_AREA\ORCL\BACKUPSET\2013_01_20\O1_MF_NNNDF_TAG20130120T191623_8HRJN8HC_.BKP tag=TAG20130120T1
91623 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 20-JAN-13
channel ORA_DISK_1: finished piece 1 at 20-JAN-13
piece handle=C:\APP\JOHN\FAST_RECOVERY_AREA\ORCL\BACKUPSET\2013_01_20\O1_MF_NCSNF_TAG20130120T191623_8HRJOF5P_.BKP tag=TAG20130120T1
91623 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 20-JAN-13

RMAN>

Do you see? The controlfile and spfile are included, even though I didn't ask for them. You have the backup you need.

Report message to a moderator

Re: Recover lost controlfile [message #575213 is a reply to message #575162]

Mon, 21 January 2013 05:48

adnanDBA
Messages: 3
Registered: January 2013
Location: Karachi

Junior Member

Thanx John

Report message to a moderator

Re: Recover lost controlfile [message #575214 is a reply to message #575213]

Mon, 21 January 2013 05:51

adnanDBA
Messages: 3
Registered: January 2013
Location: Karachi

Junior Member

thanx michel i knew that but my teacher give me that task and say without creating new controlfile how to recover it . he give me one week to do that.

Report message to a moderator

Previous Topic:	How to find table is got restored on not
Next Topic:	RMAN Incrementally Updated Backups

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Aug 31 08:09:35 CDT 2025