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

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

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