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

From: Ben <>
Date: Wed, 14 May 2008 11:31:16 -0700 (PDT)
Message-ID: <>

On May 14, 2:15 pm, joel garry <> wrote:
> On May 14, 7: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?
> The first thing is to backup anything you can, so you don't shoot
> yourself in the foot by screwing things up trying to recover.
> I'm not real sure what you mean by recover from disk, but in general,
> if you can use the control file that Oracle was using during the
> crash, you will do better than with one you've recovered.  The manuals
> and metalink have examples covering many common situations.  You may
> need to tell rman where things are, one way or another.  If you use a
> recovered catalog, you may need to use the recover using backup
> controlfile syntax to tell Oracle to apply more recent archived logs
> (see PITR examples).
> Hopefully you've learned some lessons about placement and backup of
> your catalog, as well as keeping practiced in recovery.
> jg
> --
> is bogus.
> $230M worth of spam: Hide quoted text -
> - Show quoted text -

Oh, it's going to be interesting to say the least. :)

I meant recover from *tape* instead of disk.

I'm still waiting on word whether or not our admin is going to be able to get the Oracle home and other non database file areas back. If we can get the home back, that will give us the spfile, if not then I'll have to grab it from our last full backup. Then I was planning on recovering the control file from tape and proceeding with a pitr from there. The file system that holds our control file isn't part of the general file system OS backup plan. So I'll have to use the control file from the previous night's backup. Just curious as to why I would be better off using a non-recovered control file?

I had already implemented the writing of the dbid to the alert log every morning just in case I ever needed it, I guess this is going to be that time where I'll need it. Received on Wed May 14 2008 - 13:31:16 CDT

Original text of this message