Re: Restore Database Question (After Server reinstall).

When we were prepping to get the data off of the server, we set CONTROLFILE AUTOBACKUP ON, which apparently created a backup of the control in a location we determined by using the SHOW ALL command in RMAN. So we killed the server but we got a control file off first. So I think we should be ok. I found the quote from your post in the RMAN docs and have read through it again. So I think everything should be doable...

Thanks,
Bill

"Brian Peasland" <dba_at_remove_spam.peasland.com> wrote in message news:40229312.67D021B4_at_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/rcmarch i.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:19:17 CST