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

From: Jerome Vitalis <vitalismanN05P4M_at_gmail.com.invalid>
Date: 31 Aug 2007 16:31:48 GMT
Message-ID: <46d84274$0$1445$79c14f64@nan-newsreader-07.noos.net>

On Fri, 31 Aug 2007 15:32:24 +0000, 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> }

Don't top-post.

Shutdown the instance (make sure the shutdown succeeds) and restart it in the MOUNT status. Then retry your RMAN job.

Jerome Received on Fri Aug 31 2007 - 11:31:48 CDT