Re: an interview question
- From: "Bradd Piontek" <piontekdd@xxxxxxxxx>
- To: prabhu_adam@xxxxxxxxxxx
- Date: Thu, 17 Jul 2008 10:05:01 -0500
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@xxxxxxxxxxx> 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@xxxxxxxxxxx
> > To: prabhu_adam@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
> > 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
> >
> >
> > --
> > //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/>
>
Other related posts:
