2 Replies Latest reply: Feb 7, 2014 11:39 AM by Renu-Oracle RSS

    rman duplicate for standby RMAN-20201, RMAN-06010

    924375

      hello,

       

      In a 11.2.0.3 oracle database, I'm trying to setup a physical standby database with rman duplicate from active database.

       

      I run it once, and I had to add new datafiles to the primary. Than, it failed because of out of disk space at standby site. Since it's data is huge (~ 9 TB) I didn't want to start from the begining and tried to resume.

       

      To skip datafiles already copied, I put the "SET UNTIL SCN" clause to the scn of uncomplete standby db. It skipped all datafiles already copied but gave an error for recently added datafiles.

       

      Is it possible to resume with already copied datafiles?

       

      Thanks...

       

      My script:

      run {

         SET UNTIL SCN 13557146842989;

         allocate channel tar1 type disk;

         allocate channel tar2 type disk;

         allocate channel tar3 type disk;

         allocate channel tar4 type disk;

         allocate auxiliary channel aux1 type disk;

         allocate auxiliary channel aux2 type disk;

         allocate auxiliary channel aux3 type disk;

         allocate auxiliary channel aux4 type disk;

       

       

         duplicate target database

              for standby

              from active database

              dorecover

              nofilenamecheck;

       

      Output:

      sql statement: alter database mount standby database

      Using previous duplicated file +DATA/.... for datafile 2 with checkpoint SCN of 13573985035694

      Using previous duplicated file +DATA/... for datafile 5 with checkpoint SCN of 13563313852934

      ....

      ...

      Using previous duplicated file +DATA/... for datafile 377 with checkpoint SCN of 13569256485600

      ...

      ...

      ...

      RMAN-00571: ===========================================================

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

      RMAN-00571: ===========================================================

      RMAN-03002: failure of Duplicate Db command at 02/07/2014 09:46:54

      RMAN-05501: aborting duplication of target database

      RMAN-03015: error occurred in stored script Memory Script

      RMAN-06136: ORACLE error from auxiliary database: RMAN-20201: datafile not found in the recovery catalog

      RMAN-06010: error while looking up datafile: 299

      ...

      ...