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

Sorry for not providing all the details. I am using : 10.1.0.2.0.

I ran a restore job but had to cancel it because of some reasons. Now when I am firing restore again using following RMAN script

RMAN> run{

2> allocate channel ch0 type sbt;
3> restore database;
4> recover database;
5> release channel ch0;
6> alter database open;
7> }

I am getting the "incompatible media recovery is active error". ORACLEs guide says we should cancel any active recovery. But "alter database recover cancel" command is telli0gn me that no recovery was started.

I am not sure whats happening here.

Thanks & Regards,
Ganesh

On Aug 31, 8:00 pm, Cristian Cudizio <cristian.cudi..._at_yahoo.it> wrote:
> 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.comhttp://cristiancudizio.wordpress.com
Received on Fri Aug 31 2007 - 10:32:24 CDT