rman error : RMAN-20011 while restoring from previous incarnation.

From: Prabhu, Krishnaswamy <prabhu_adam_at_hotmail.com>
Date: Tue, 24 Apr 2007 17:30:15 +0000
Message-ID: <BAY142-F156CD230C835E17F6565A854A0@phx.gbl>

Hi List,

We are trying to recover a database using previous incarnation from rman backup.

Our database is running on SUN Solaris
DB Version : 9.2.0.6

We are tring the following , but getting the following error.

RMAN> list INCARNATION;

List of Database Incarnations
DB Key Inc Key DB Name DB ID CUR Reset SCN Reset Time

------- ------- -------- ---------------- --- ---------- ----------
1       2       TMOC1S   94192921         YES 9025242    18-JUN-06
1       10662   TMOC1S   94192921         NO  23258154   13-APR-07
1       11382   TMOC1S   94192921         NO  23304416   23-APR-07

RMAN> RESET DATABASE TO INCARNATION 10662; database reset to incarnation 10662 in recovery catalog

RMAN> run{
SET UNTIL TIME "to_date('2007-04-13:14:19:00','yyyy-mm-dd:hh24:mi:ss')"; restore database;
recover database;
}
2> 3> 4> 5>
executing command: SET until clause

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03002: failure of set command at 04/24/2007 12:14:21 RMAN-06004: ORACLE error from recovery catalog database: RMAN-20011: target database incarnation is not current in recovery catalog

Thanks for your help on this.

Thanks
Prabhu

Catch all the cricketing action right here. Live score, match reports, photos et al. http://content.msn.co.in/Sports/Cricket/Default.aspx

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Apr 24 2007 - 12:30:15 CDT