Re: an interview question

My answer addresses no control file backup at all. In a *worse case* situation, you can use the create control file command to re-create the control file. You could then catalog the control file pieces (assuming you are running 10g or later) and then restore the database using the backupset pieces.

RF

 Robert G. Freeman
Author:
Oracle Database 11g New Features (Oracle Press) Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press) Oracle9i RMAN Backup and Recovery (Oracle Press) Oracle9i New Feature
Blog: http://robertgfreeman.blogspot.com (Oracle Press) The LDS Church is looking for DBA's. You must be LDS to apply (please don't write to me and tell me I'm breaking the law. A church can choose to hire members of it's own faith. Look it up if you don't believe me).

• Original Message ---- From: hrishy <hrishys_at_yahoo.co.uk> To: prabhu_adam_at_hotmail.com; Oracle List <oracle-l_at_freelists.org>; jeremiah_at_ora-600.net; Robert Freeman <robertgfreeman_at_yahoo.com> Sent: Wednesday, August 13, 2008 10:35:49 AM Subject: Re: an interview question

Hi Robert

Sorry i didnt mention when i made the statement the scenario i had in my mind was when the controlfile auto backups were turned off

regards
Hrishy

• On Thu, 7/8/08, Robert Freeman <robertgfreeman_at_yahoo.com> wrote:

> From: Robert Freeman <robertgfreeman_at_yahoo.com>
> Subject: Re: an interview question
> To: hrishys_at_yahoo.co.uk, prabhu_adam_at_hotmail.com, "Oracle List" <oracle-l_at_freelists.org>, jeremiah_at_ora-600.net
> Date: Thursday, 7 August, 2008, 4:01 PM
> Controlfile auto backup gets your controlfile back for you.
> You could also manually create the control file and then
> catalog the RMAN backupset pieces in 10g and later. Probably
> easier than hacking at the backup set pieces .... 10g New
> Feature for those that didn't know... You can catalog
> all backup set pieces (like with a splat) once you restore a
> control file. Very handy.
>
> RF
>
>
> Robert G. Freeman
> Author:
> Oracle Database 11g New Features (Oracle Press)
> Portable DBA: Oracle (Oracle Press)
> Oracle Database 10g New Features (Oracle Press)
> Oracle9i RMAN Backup and Recovery (Oracle Press)
> Oracle9i New Feature
> Blog: http://robertgfreeman.blogspot.com (Oracle Press)
> The LDS Church is looking for DBA's. You must be LDS to
> apply (please don't write to me and tell me I'm
> breaking the law. A church can choose to hire members of
> it's own faith. Look it up if you don't believe me).
>
>
>
> ----- Original Message ----
> From: hrishy <hrishys_at_yahoo.co.uk>
> To: prabhu_adam_at_hotmail.com; Oracle List
> <oracle-l_at_freelists.org>; jeremiah_at_ora-600.net
> Sent: Thursday, August 7, 2008 4:24:45 AM
> Subject: RE: an interview question
>
> 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

Send instant messages to your online friends http://uk.messenger.yahoo.com

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