Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Incomplete recovery question
You can create an auxillary instance with just system , undo and
necessary tablespace files and restore this instance to a point in time
and open with resetlogs.
amit
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.
>
>
> http://www.freelists.org/webpage/oracle-l
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Nov 07 2007 - 14:13:17 CST
![]() |
![]() |