restore database from an old incarnation

From: Anthony <akkha1234_at_gmail.com>
Date: Tue, 17 Feb 2009 20:39:56 -0800 (PST)
Message-ID: <7d4f4fae-1894-4624-a94d-fa40799b30e2_at_r36g2000prf.googlegroups.com>

Hi,

We are using rman and a 3rd party vendor backing up to tape directly. We used Oracle 10g2 on windows 2003 server with a catalog database on another database.

I need to restore and recover a database from a previous incarnation to a different server. (NOT the original production). I create a new instance on the new box. I tried to recover the control file first but get following error.

RMAN> run {

2>      allocate channel ch1 type 'sbt_tape'
3>         PARMS="BLKSIZE=262144,ENV=(CvClientName=svr-lms-

db2,CvInstanceName=In
stance001)";
4> restore controlfile until time = "TO_DATE('10/04/2008 04:29:27','MM/DD/YYYY
HH24:MI:SS')" ;
5> }

allocated channel: ch1
channel ch1: sid=157 devtype=SBT_TAPE
channel ch1: CommVault Systems for Oracle: Version 7.0.0(BUILD76)

Starting restore at 17-FEB-09
released channel: ch1
RMAN-00571:

---

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

---

RMAN-00571:

---

RMAN-03002: failure of restore command at 02/17/2009 20:37:43 RMAN-06004: ORACLE error from recovery catalog database: RMAN-20207: UNTIL TIME
or RECOVERY WINDOW is before RESETLOGS time

How do I go back to a previous incarnation? Please remember I am not recovering and restoring the original database. I just want to get back a database four months ago for comparison.

Thanks for any help. Received on Tue Feb 17 2009 - 22:39:56 CST