Jo See - How To Restore Controlfile From A Backupset Without A Catalog Or Autobackup (Doc ID 403883.1) https://support.oracle.com/epmos/faces/ui/km/SearchDocDisplay.jspx?retur nToSrId=&_afrLoop=102280015586110&srnum=&type=DOCUMENT&id=403883.1&displ ayIndex=1&_afrWindowMode=0&_adf.ctrl-state=ys821xpm8_69 I would read through this to understand what is being said before I try anything what I said below after that - Using RMAN to Restore and Recover a Database When the Repository and Spfile/Init.ora Files Are Also Lost (Doc ID 372996.1) https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=10256796 4380858&id=372996.1&_afrWindowMode=0&_adf.ctrl-state=ys821xpm8_135 I am also wondering - I don't remember what happens - if you get all the backup sets - the older ones that you need Get them on disk Recreate the control file and /or a recovery catalog if needed Register the old backup pieces Attempt restore/recovery I would of course backup everything and keep in a safe place before I try anything like this UBS AG Platform Services - Operations & Service Service Delivery - (GSDM) 480 Washington BLVD, Jersey City Tel. external: +(1)-201-318-7597 Tel. internal: 19-436-7597 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Holvoet, Jo Sent: Wednesday, August 28, 2013 4:25 PM To: Mark Bobak; Radoulov, Dimitre Cc: jo.holvoet@xxxxxxxxx; Guillermo Alan Bort; oracle@xxxxxxxxxxxxxxx; oracle-l-freelists Subject: RE: RMAN restore/recover problem Mark, When I try it now I still get an ORA-01190 (control file or data file 1 is from before the last RESETLOGS). I will start over from the beginning and see if works then. Mvg/regards Jo -----Original Message----- From: Mark Bobak [mailto:Mark.Bobak@xxxxxxxxxxxx] Sent: woensdag 28 augustus 2013 22:05 To: Holvoet, Jo; Radoulov, Dimitre Cc: jo.holvoet@xxxxxxxxx; Guillermo Alan Bort; oracle@xxxxxxxxxxxxxxx; oracle-l-freelists Subject: Re: RMAN restore/recover problem Have you tried 'recover database using backup control file until cancel'? http://docs.oracle.com/cd/B12037_01/server.101/b10734/rcmrecov.htm#10062 47 I think someone previously suggested that, but I don't recall seeing that you tried it? -Mark On 8/28/13 3:48 PM, "Holvoet, Jo" <jo.holvoet@xxxxxxxxxxxxx> wrote: >Hi Dimitre, > >The only backups listed are all newer than the point-in-time I want. > >-----Original Message----- >From: Radoulov, Dimitre [mailto:cichomitiko@xxxxxxxxx] >Sent: woensdag 28 augustus 2013 21:00 >To: Holvoet, Jo >Cc: jo.holvoet@xxxxxxxxx; Guillermo Alan Bort; oracle@xxxxxxxxxxxxxxx; >oracle-l-freelists >Subject: Re: RMAN restore/recover problem > >Connect to catalog and execute: > >list backup of controlfile; > >If you find the backup in some backupset, try (I'm not sure about the >exact syntax): > >restore controlfile from 'backupset_name'; > >Regards >Dimitre > >On 28/08/2013 20:56, Holvoet, Jo wrote: >> Hi Dimitre, >> >> Since I registered the backupsets in our rman catalog, shouldn't I see >> this in the RC_BACKUP_CONTROLFILE view ? It's not there. >> >> Mvg/regards >> Jo >> >> -----Original Message----- >> From: Radoulov, Dimitre [mailto:cichomitiko@xxxxxxxxx] >> Sent: woensdag 28 augustus 2013 20:14 >> To: jo.holvoet@xxxxxxxxx; Holvoet, Jo >> Cc: Guillermo Alan Bort; oracle@xxxxxxxxxxxxxxx; oracle-l-freelists >> Subject: Re: RMAN restore/recover problem >> >> Just to add that RMAN automatically includes the control file and >> server parameter file in backups of data file 1, so I believe that you >> should have >> a backup of the controlfile in the backupset of datafile 1 (tablespace >> system). >> >> Regards >> Dimitre >> >> On 28/08/2013 19:54, Guillermo Alan Bort wrote: >>> [...] (ever since I had to >>> restore a database without the correct controlfile and learned to >> check the >>> controlfiles are being backed up properly). > >-- >//www.freelists.org/webpage/oracle-l > > > > -- //www.freelists.org/webpage/oracle-l Please visit our website at http://financialservicesinc.ubs.com/wealth/E-maildisclaimer.html for important disclosures and information about our e-mail policies. For your protection, please do not transmit orders or instructions by e-mail or include account numbers, Social Security numbers, credit card numbers, passwords, or other personal information. -- //www.freelists.org/webpage/oracle-l