Re: how to come out of "an incompatible media recovery is active" error

On Aug 31, 4:00 pm, Ganesh <ganesh.tam..._at_gmail.com> wrote:
> Hi All,
>
> I am trying to restore my DB.
>
> Is there any way to come out of error "ORA-01153: an incompatible
> media recovery is active" without requiring to shutdown the DB and put
> it in mount state ?
>
> I tried "alter database recover cancel" but it doesn't seem to work. I
> am receiving following error.
>
> **********************************************************
>
> SQL> alter database recover cancel;
> alter database recover cancel
> *
> ERROR at line 1:
> ORA-01112: media recovery not started
>
> **********************************************************
>
> I am using 10g on Windows.
>
> Thanks in advance.
>
> Regards,
> Ganesh Tambat

I don't know what is ORA-01153, i've never encountered, but it seems as you have already a session
which is running a recovery. May also a backup running. What are you trying to restore that you don't want
to shutdown your database? more precisely: what command are you trying to launch that gives you ora-01153?
which version are you using? 10.1.0.3 , ....?

regards,

Cristian Cudizio

http://oracledb.wordpress.com
http://cristiancudizio.wordpress.com Received on Fri Aug 31 2007 - 10:00:20 CDT