Re: it happened, lost database and recovery catalog. starting distaster recovery research
From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Fri, 16 May 2008 10:28:02 +0200
Message-ID: <7ba56$482d4592$524b5c40$2865@cache3.tilbu1.nb.home.nl>
>> 10.2.0.2 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?
Date: Fri, 16 May 2008 10:28:02 +0200
Message-ID: <7ba56$482d4592$524b5c40$2865@cache3.tilbu1.nb.home.nl>
neil kodner wrote:
> On May 14, 8:57 am, Ben <balve..._at_gmail.com> wrote:
>> 10.2.0.2 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