Re: an interview question

From: David Barbour <david.barbour1_at_gmail.com>
Date: Thu, 7 Aug 2008 10:27:31 -0400
Message-ID: <69eafc3f0808070727w54317a11jcc561304e7e5843e@mail.gmail.com>


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
Received on Thu Aug 07 2008 - 09:27:31 CDT

Original text of this message