5 Replies Latest reply: Nov 28, 2012 9:27 AM by user3266490 RSS

    RMAN-20207

    user3266490
      Hi,

      Db :11.2.0.1

      We getting the belo error while execute restore script

      oracle@plm-a33:/u01/app/oracle/11.2.0.1/Bkp_test/Old/Refresh/longest: cat restore_longest_100905*

      Recovery Manager: Release 11.2.0.1.0 - Production on Mon Sep 10 05:02:19 2012

      Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

      RMAN> connect target *
      2> RUN
      3> {
      4> allocate channel t1 type 'SBT_TAPE' parms 'ENV=(LEO_buffersize=1048576,LS_PFILE=/u01/app/oracle/11.2.0.1/product/rdbms/oraclehome/Quest/LEO/param.txt)';
      5> allocate channel t2 type 'SBT_TAPE' parms 'ENV=(LEO_buffersize=1048576,LS_PFILE=/u01/app/oracle/11.2.0.1/product/rdbms/oraclehome/Quest/LEO/param.txt)';
      6> RESTORE DATABASE until time "to_date('2012-09-08-19:15','YYYY-MM-DD-HH24:MI')";
      7> release channel t1;
      8> release channel t2;
      9> }
      10>
      11>
      connected to target database: p261 (DBID=1429245374, not open)

      using target database control file instead of recovery catalog
      allocated channel: t1
      channel t1: SID=5659 device type=SBT_TAPE
      channel t1: LiteSpeed Engine for Oracle v2.2.1.1013

      allocated channel: t2
      channel t2: SID=5782 device type=SBT_TAPE
      channel t2: LiteSpeed Engine for Oracle v2.2.1.1013

      Starting restore at 10-SEP-12
      released channel: t1
      released channel: t2
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of restore command at 09/10/2012 05:02:22
      RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time

      Recovery Manager complete.


      oracle@plm-a33:/u01/app/oracle/11.2.0.1/Bkp_test/Old/Refresh/longest: rman target /

      Recovery Manager: Release 11.2.0.1.0 - Production on Mon Sep 17 13:57:16 2012

      Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

      connected to target database: p261 (DBID=1429245374, not open)

      RMAN> list incarnation;

      using target database control file instead of recovery catalog

      List of Database Incarnations
      DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
      ------- ------- -------- ---------------- --- ---------- ----------
      1 1 p261 1429245374 PARENT 5515926705917 19-SEP-12
      2 2 p261 1429245374 PARENT 5515926731900 19-SEP-12
      3 3 p261 1429245374 CURRENT 5515927706621 15-OCT-12

      RMAN>


      Thanks & Regards,
      VN
        • 1. Re: RMAN-20207
          Veeresh.S
          5> allocate channel t2 type 'SBT_TAPE' parms 'ENV=(LEO_buffersize=1048576,LS_PFILE=/u01/app/oracle/11.2.0.1/product/rdbms/oraclehome/Quest/LEO/param.txt)';
          6> RESTORE DATABASE until time "to_date('*2012-09-08*-19:15','YYYY-MM-DD-HH24:MI')";


          RMAN> list incarnation;

          using target database control file instead of recovery catalog

          List of Database Incarnations
          DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
          ------- ------- -------- ---------------- --- ---------- ----------
          1 1 p261 1429245374 PARENT 5515926705917 19-SEP-12
          2 2 p261 1429245374 PARENT 5515926731900 19-SEP-12
          *3 3 p261 1429245374 CURRENT 5515927706621 15-OCT-12*
          you are trying to restore the database to the date Aug 08, but you cannot restore your database older than Oct 15....so until time clause should always be more than Oct 15......

          another option is set the incarnation to old incarnation and try using until time accordingly
          • 2. Re: RMAN-20207
            Richard Harrison .
            Hi,
            You need to tell rman to use an old incarnation of the database - see example here:

            http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta036.htm

            Cheers,
            Harry
            • 3. Re: RMAN-20207
              user3266490
              Hi,

              Thanks for your reply.

              Even if i try incarnation 1(19-SEP-12) and 2( 19-SEP-12) ,won't work.Right?

              Is it possible to restore that backup?

              Thanks & Regards,
              VN
              • 4. Re: RMAN-20207
                Veeresh.S
                user3266490 wrote:
                Hi,

                Thanks for your reply.

                Even if i try incarnation 1(19-SEP-12) and 2( 19-SEP-12) ,won't work.Right?

                Is it possible to restore that backup?

                Thanks & Regards,
                VN
                No you cant restore
                • 5. Re: RMAN-20207
                  user3266490
                  Hi,

                  Thanks for your reply.

                  Refresh the db from production to test, whether Date should be matched or not.
                  If the test date is less than production,can we restore it?
                  If the test date is more than production,can we restore it?

                  Thanks & Regards,
                  VN