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

From: Frank van Bortel <>
Date: Fri, 16 May 2008 10:28:02 +0200
Message-ID: <7ba56$482d4592$524b5c40$>

neil kodner wrote:

> 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.

Which makes sense, as the catalog is no more than a copy of your control file.

Both of which should be backed up!!!

FvB Received on Fri May 16 2008 - 03:28:02 CDT

Original text of this message