RE: RMAN restore/recover problem

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Holvoet, Jo Sent: Wednesday, August 28, 2013 4:25 PM To: Mark Bobak; Radoulov, Dimitre
Cc: jo.holvoet_at_gmail.com; Guillermo Alan Bort; oracle_at_dunbar-it.co.uk; 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_at_proquest.com] Sent: woensdag 28 augustus 2013 22:05
To: Holvoet, Jo; Radoulov, Dimitre
Cc: jo.holvoet_at_gmail.com; Guillermo Alan Bort; oracle_at_dunbar-it.co.uk; 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_at_thomascook.be> wrote:

>Hi Dimitre,
>
>The only backups listed are all newer than the point-in-time I want.
>
>-----Original Message-----
>From: Radoulov, Dimitre [mailto:cichomitiko_at_gmail.com]
>Sent: woensdag 28 augustus 2013 21:00
>To: Holvoet, Jo
>Cc: jo.holvoet_at_gmail.com; Guillermo Alan Bort; oracle_at_dunbar-it.co.uk;
>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_at_gmail.com]
>> Sent: woensdag 28 augustus 2013 20:14
>> To: jo.holvoet_at_gmail.com; Holvoet, Jo
>> Cc: Guillermo Alan Bort; oracle_at_dunbar-it.co.uk; 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).
>
>--
>http://www.freelists.org/webpage/oracle-l
>
>
>
>

--
http://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.
--
http://www.freelists.org/webpage/oracle-l