Re: URGENT RECOVERY

From: Dennis Williams <oracledba.williams_at_gmail.com>
Date: Wed, 31 Oct 2007 09:59:03 -0500
Message-ID: <de807caa0710310759m79db5838q8fc7556e8ed711a6@mail.gmail.com>

Paula,

First of all, you have my sympathies.

Do you have any other copies of the archive log in question?
Basically the way recovery works is you recover a backup and then apply archive logs to bring the instance up to date. If you recovered your most recent backup and then applied archive logs, you are basically stuck where you got to. It sounds like you may lose a few hours of transactions. Recovering an older backup won't help you because you'll eventually have to apply that same archive log, and that is where you'll stop.

Sorry,
Dennis Williams

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Oct 31 2007 - 09:59:03 CDT