Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Incomplete recovery question

Re: Incomplete recovery question

From: Jeremiah Wilton <>
Date: Wed, 07 Nov 2007 12:29:49 -0800
Message-ID: <>

Yes, you can just continue recovering after hitting ORA-1152, but to get a consistent and normally openable database, you will have to either recover everything to Aug. 17, or get rid of the files from Aug. 17 (offline drop or create controlfile without them). That will only be useful if the data you are after is not in those files.

Please let us know what version and platform you are on. There are ways to open the database read-only without invalidating the recovery session. You could check after applying each log then continue.

Have you considered using strings and grep to find the changed value? If the before or after value is a distinctive string, it is easy to find which archivelog a change resides in:

$ strings <logfile> | grep <string>

Hope this helps,

Jeremiah Wilton
ORA-600 Consulting

Maureen English wrote:
> We've been trying to find information about when a value got
> changed in our database, and who changed it. Logminer didn't
> help since the change was a chained row. So, we've been
> restoring the database from different backups to a point in
> time when the change *could* have occurred. Our most recent
> attempt to find the change resulted in an ora-01152 error.
> I understand the reason for the error...our restore was to
> a point in time (Aug 7th), but three datafiles that were
> created after the backup we used (July 6th), were restored
> from a backup on Aug 17th. So, these three datafiles have
> a date in the future of when we want to recover to.
> I believe that I can just restore the datafiles, and while
> I'm still at the point where I received the error, I can
> then reissue my 'recover database until change xxxxxxx'
> command.

Received on Wed Nov 07 2007 - 14:29:49 CST

Original text of this message