Re: an interview question

From: Robert Freeman <robertgfreeman_at_yahoo.com>
Date: Thu, 7 Aug 2008 08:01:08 -0700 (PDT)
Message-ID: <751586.33786.qm@web38908.mail.mud.yahoo.com>

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
--
http://www.freelists.org/webpage/oracle-l

Received on Thu Aug 07 2008 - 10:01:08 CDT