Ganesh wrote:
> 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
>
>
>
>
i think that your attempt to stop the operation did not worked as you espect
so the task is still running or has left an inconsistent state
regards,
--
Cristian Cudizio
http://oracledb.wordpress.com
http://cristiancudizio.wordpress.com
Received on Fri Aug 31 2007 - 10:52:58 CDT
