Re: an interview question
- From: "David Barbour" <david.barbour1@xxxxxxxxx>
- To: hrishys@xxxxxxxxxxx
- 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@xxxxxxxxxxx> 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@xxxxxxxxxxx> wrote:
>
> > From: Jeremiah Wilton <jeremiah@xxxxxxxxxxx>
> > Subject: RE: an interview question
> > To: prabhu_adam@xxxxxxxxxxx, "'Oracle List'" <oracle-l@xxxxxxxxxxxxx>
> > 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
> >
> >
> > --
> > //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
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
