Re: an interview question
Date: Thu, 7 Aug 2008 10:27:31 -0400
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:
> 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
> --- 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