Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

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

Re: Incomplete recovery question

From: amit poddar <amit.poddar_at_yale.edu>
Date: Wed, 07 Nov 2007 15:13:17 -0500
Message-ID: <47321C5D.4040908@yale.edu>


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-l
Received on Wed Nov 07 2007 - 14:13:17 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US