Re: an interview question

OK - I see where you've lost your current controlfile and the recovery catalog, so my "easy" way probably isn't going to work. If you've got autobackup configured for the controlfile, you could look in the alert log. That seems pretty easy too.

On Thu, Aug 7, 2008 at 10:27 AM, David Barbour <david.barbour1_at_gmail.com>wrote:

> How about RMAN> list backup of controlfile;
>
> Seems pretty easy to me.
>
>
> On Thu, Aug 7, 2008 at 6:24 AM, hrishy <hrishys_at_yahoo.co.uk> wrote:
>
>> Hi
>>
>> How do you find out which backupiece contains the controlfile.
>> One way is to go through the rman logfiles.
>>
>> And the other way i cna think of is run dbms_backup_restore on each of the
>> backup piece in your backupset.
>>
>> is there another easy way
>>
>> regards
>> Hrishy
>>
>>
>> --- On Wed, 16/7/08, Jeremiah Wilton <jeremiah_at_ora-600.net> wrote:
>>
>> > From: Jeremiah Wilton <jeremiah_at_ora-600.net>
>> > Subject: RE: an interview question
>> > To: prabhu_adam_at_hotmail.com, "'Oracle List'" <oracle-l_at_freelists.org>
>> > Date: Wednesday, 16 July, 2008, 8:00 PM
>> > Prabhu, Krishnaswamy wrote:
>> >
>> > > Is it possible to recover a database whose couple of
>> > datafiles , all
>> > multiplexed
>> > > controlfiles and rman catalog repository are lost. A
>> > complete rman backup
>> > exists
>> > > but catalog and control files are lost.
>> >
>> > RMAN> restore controlfile from <backuppiece>;
>> >
>> > Something easy to find with google or the documentation.
>> >
>> > IIRC in 8i it used to require some effort and calls
>> > directly to
>> > dbms_backup_restore.
>> >
>> > Jeremiah Wilton
>> > ORA-600 Consulting
>> > http://www.ora-600.net
>> >
>> >
>> > --
>> > http://www.freelists.org/webpage/oracle-l
>>
>>
>> __________________________________________________________
>> Not happy with your email address?.
>> Get the one you really want - millions of new email addresses available
>> now at Yahoo! http://uk.docs.yahoo.com/ymail/new.html
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>
>

--
http://www.freelists.org/webpage/oracle-l