Re: it happened, lost database and recovery catalog. starting distaster recovery research

From: neil kodner <>
Date: Wed, 14 May 2008 09:41:00 -0700 (PDT)
Message-ID: <>

On May 14, 8:57 am, Ben <> wrote:
> EE, aix5L
> had a storm this weekend and power went out to the disk cabinet on our
> development machine. I was just informed by our sys admin that we
> might be having to recover from disk to get everything back.
> Luckily it is just our development machine but we do have critical
> data in that database. The recovery catalog was located on the same
> machine and filesystem. Now I'm setting forth with the research on how
> to get it back. I have documentation of control file backups, the
> dbid, and the last hot backup of the database. I don't have a backup
> for the recovery catalog that we were using. Correct me if I'm wrong,
> but I guess I'll be recovering the control file(s) then recovering the
> database from those instead of the catalog. I've practiced recovery in
> the past but never without the recovery catalog.
> Wish me luck. Any pointers?

Have you tried running an RMAN restore without first connecting to any catalog? The backup information is also stored in the control files. We've performed restores while bypassing the recovery catalog. Received on Wed May 14 2008 - 11:41:00 CDT

Original text of this message