Re: restore database from an old incarnation
From: <matthias.hoys_at_gmail.com>
Date: Wed, 18 Feb 2009 02:28:41 -0800 (PST)
Message-ID: <5eed7146-2689-4f45-9414-c02d46a6372c_at_l39g2000yqn.googlegroups.com>
On Feb 18, 5:39 am, Anthony <akkha1..._at_gmail.com> wrote:
> 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.
Date: Wed, 18 Feb 2009 02:28:41 -0800 (PST)
Message-ID: <5eed7146-2689-4f45-9414-c02d46a6372c_at_l39g2000yqn.googlegroups.com>
On Feb 18, 5:39 am, Anthony <akkha1..._at_gmail.com> wrote:
> 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.
Cause: UNTIL TIME and RECOVERY WINDOW cannot be less than the database creation time or RESETLOGS time.
Action: Check the UNTIL TIME or RECOVERY WINDOW. If the database needs to be restored to an old incarnation, use the RESET DATABASE TO INCARNATION command.
Matthias Received on Wed Feb 18 2009 - 04:28:41 CST