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

Home -> Community -> Usenet -> c.d.o.server -> Re: how to come out of "an incompatible media recovery is active" error

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

From: Cristian Cudizio <cristian.cudizio_at_yahoo.it>
Date: Fri, 31 Aug 2007 08:00:20 -0700
Message-ID: <1188572420.540615.113180@22g2000hsm.googlegroups.com>


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

Original text of this message

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