This content has been marked as final. Show 11 replies
You can not.
If you don't use a RMAN catalog database, autobackup of controlfile is mandatory.
Senior Oracle DBA
If you dont have backup of controlfile,
You have to recreate the controlfile using create controlfile(You need to know the list of datafiles and redo log file location) script
I can recreate the controlfiles if I have the datafiles available. No data files are available...
I have my full backup and all archives in disk.what did you use to take the backup? RMAN or User Managed OS backup?
I've taken the backup with RMAN. The pieces are in backupsets.
Despite what others have said it may be possible to still restore your controlfile if you used RMAN and did a full backup.1 person found this helpful
Oracle includes the controlfile and spfile in the backup automatically when you backup datafile 1 whether or not autobackup is on or not.
Straight from the 10.2 documentation that some people like to throw around...
If CONFIGURE CONTROLFILE AUTOBACKUP is ON, then RMAN writes the current control file and SPFILE to a separate autobackup piece. Otherwise, these files are automatically included in the backup set that contains datafile 1.
Check the logfile for the backup and see if it includes a controlfile then you can restore with 'restore controlfile from 'path to backup piece''
Great answer 889915!
I did not know that tip....
You can also recreate controlfile by using "Create Controlfile" Command, and then restore the datafiles.
Hi Ahmer Mansoor
But... when I am going to recreate the controlfiles, this script depends on the data files found in disk. In this scenario I have not still the data files restore...
How I am going to recreate the controlfiles without having the datafiles in disk ? In fact. When the controlfiles are getting recreating if a datafile is missing in disk. The recreation fails...
How I am going to recreate the controlfiles without having the datafiles in disk ?
Thanks Ahmer Mansoor
try RESTORE CONTROLFILE command1 person found this helpful
Excellent Link user11181920!