Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Restore Database Question (After Server reinstall).

Re: Restore Database Question (After Server reinstall).

From: Brian Peasland <dba_at_remove_spam.peasland.com>
Date: Thu, 5 Feb 2004 19:01:38 GMT
Message-ID: <40229312.67D021B4@remove_spam.peasland.com>


I'm sure that HJR or someone else will correct me if I am wrong here...

RMAN will store information about the backupsets in one of two places...your control files and/or your Recovery Catalog. If you have no Recovery Catalog, then RMAN will want to read this information from the control files. What if the control files don't exist? What do you use then?

According to the Oracle docs
(http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmarchi.htm#457551), "If you lose the current control files, then you can restore a control file autobackup even if you do not use a recovery catalog." But you need that backup, and I'm assuming that your entire server is gone which means the backup of the control file is gone as well. Is that correct?

HTH,
Brian

Bill Lucas wrote:
>
> Preparing for a worst scenerio in this case...
>
> If they don't have a Recovery catalog? What would be the issue / and where
> can I find info on a resolution workaroundd?
> "Brian Peasland" <dba_at_remove_spam.peasland.com> wrote in message
> news:40228A8F.AB9C1A27_at_remove_spam.peasland.com...
> > After you've got the server set up and running, and Oracle has been
> > installed, use RMAN to just restore the missing database. Don't worry
> > about the database id as RMAN will take care of this for you. But I hope
> > you have a Recovery Catalog in another location.
> >
> > HTH,
> > Brian
> >
> >
> >
> > --
> > ===================================================================
> >
> > Brian Peasland
> > dba_at_remove_spam.peasland.com
> >
> > Remove the "remove_spam." from the email address to email me.
> >
> >
> > "I can give it to you cheap, quick, and good. Now pick two out of
> > the three"

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"
Received on Thu Feb 05 2004 - 13:01:38 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US