Home » RDBMS Server » Backup & Recovery » Recover lost controlfile (Linux oracle 10g)
icon5.gif  Recover lost controlfile [message #575155] Sun, 20 January 2013 06:59 Go to next message
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.
Re: Recover lost controlfile [message #575159 is a reply to message #575155] Sun, 20 January 2013 08:57 Go to previous messageGo to next message
Michel Cadot
Messages: 58609
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Recover lost controlfile [message #575162 is a reply to message #575155] Sun, 20 January 2013 13:22 Go to previous messageGo to next message
John Watson
Messages: 4400
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.
Re: Recover lost controlfile [message #575213 is a reply to message #575162] Mon, 21 January 2013 05:48 Go to previous messageGo to next message
adnanDBA
Messages: 3
Registered: January 2013
Location: Karachi
Junior Member
Thanx John
Re: Recover lost controlfile [message #575214 is a reply to message #575213] Mon, 21 January 2013 05:51 Go to previous message
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.
Previous Topic: How to find table is got restored on not
Next Topic: RMAN Incrementally Updated Backups
Goto Forum:
  


Current Time: Tue Jul 29 08:50:20 CDT 2014

Total time taken to generate the page: 0.06696 seconds