RE: an interview question

From: hrishy <hrishys_at_yahoo.co.uk>
Date: Thu, 7 Aug 2008 10:24:45 +0000 (GMT)
Message-ID: <457573.70967.qm@web27401.mail.ukl.yahoo.com>

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

Received on Thu Aug 07 2008 - 05:24:45 CDT