Re: an interview question

you don't need the catalog or to even restore the catalog.

Restore the controlfile backup in your rman backup set . This controlfile has the metadata you need to restore your database. I can't think of a case where a recovery catalog is needed (although it is a niceity to have the history , at times).

Bradd Piontek
Oracle Blog: http://piontekdd.blogspot.com Linked In: http://www.linkedin.com/in/piontekdd

On Thu, Jul 17, 2008 at 9:34 AM, Prabhu, Krishnaswamy < prabhu_adam_at_hotmail.com> wrote:

> The scenario is , the rman backup is cofigured with recovery catalog db
> and, we lost all control files and rman catalog repository database as
> well. Unfortunately, we don't have backups of catalog.
>
> First to restore/recover the control file, we need recovery catalog
> database, since we lost the meta data information, does it still possible to
> use the backup (which doesn't have the metadata) to recover the target
> database.
>
> Thanks
> Prabhu
>
> > From: jeremiah_at_ora-600.net
> > To: prabhu_adam_at_hotmail.com; oracle-l_at_freelists.org
> > Subject: RE: an interview question
> > Date: Wed, 16 Jul 2008 12:00:42 -0700
>
> >
> > 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
> >
> >
>
>
> ------------------------------
> Windows Live Messenger just got better with Messenger TV. Share your
> favourite videos online with your near and dear ones. Check it out!<http://server1.msn.co.in/sp08/getmessengertv/en-in/index.asp>
> ------------------------------
> This is your window into tinsel town. Keep abreast with the latest movie
> releases, star shockers and juicy gossip. Try it!<http://entertainment.in.msn.com/>
>

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