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

From: Ben <>
Date: Wed, 14 May 2008 08:15:05 -0700 (PDT)
Message-ID: <>

On May 14, 10: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?

I should add the database was in archivelog mode and we have those as well. The database was up for about a day without any activity when it's datafiles were most likely un-accessible. Received on Wed May 14 2008 - 10:15:05 CDT

Original text of this message