Re: Incomplete recovery question

"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. "

Can you please share how ?

amit

Jeremiah Wilton wrote:
> 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
> http://www.ora-600.net

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