Re: an interview question
Date: Tue, 29 Jul 2008 00:48:57 +0530
If the backup procedure followed in this case includes the controlfile ( with controlfile auto backup or by any other way), we can always restore the backup. Our requirement is to restore is to restore data & not its metadata (catalog). Meta data does help in restores but will never limits the recoverability of the database.
Here process simple:
catalog start with '/backup_location/';
list backup of controlfile;
==> this should list the backup piece with controlfile.. if it has,,.. if no output then it will be little tough restore controlfile from '<backuppiece listed above>; restore database;
I think this is one possible solution. If anyone thinks otherwise please let us know.
On Thu, Jul 17, 2008 at 8:35 PM, Bradd Piontek <piontekdd_at_gmail.com> wrote:
> 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
>> > 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!
>> This is your window into tinsel town. Keep abreast with the latest movie
>> releases, star shockers and juicy gossip. Try it!