10 Replies Latest reply: May 23, 2008 4:59 PM by Srinivas.R RSS

    RMAN Duplicate fails...resumable?

    197888
      I am duplicating a rac database on a filesystem to a single node database on ASM.

      The duplicate was very close to finishing. RMAN got to this part of the duplicate process:

      sql statement: CREATE CONTROLFILE REUSE SET DATABASE "TESTDB" RESETLOGS ARCHIVELOG
      MAXLOGFILES 64
      MAXLOGMEMBERS 2
      MAXDATAFILES 256
      MAXINSTANCES 6
      MAXLOGHISTORY 7209
      LOGFILE
      GROUP 5 SIZE 250 M ,
      GROUP 6 SIZE 250 M ,
      GROUP 7 SIZE 250 M ,
      GROUP 8 SIZE 250 M
      DATAFILE
      '+DATA/testdb/datafile/system.382.653678471'
      CHARACTER SET AL32UTF8


      contents of Memory Script:
      {
      set newname for clone tempfile 1 to new;
      set newname for clone tempfile 2 to new;
      switch clone tempfile all;
      catalog clone datafilecopy "+DATA/testdb/datafile/undo_tbs1.259.653642791";
      ...
      switch clone datafile all;
      }
      executing Memory Script


      And before it got to switching the datafiles, I got:


      cataloged datafile copy
      datafile copy filename=+DATA/testdb/datafile/ods2_data1.300.653654645 recid=24 stamp=653683077

      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-00601: fatal error in recovery manager
      RMAN-03004: fatal error during execution of command
      RMAN-04006: error from auxiliary database: ORA-12170: TNS:Connect timeout occurred
      RMAN-03002: failure of Duplicate Db command at 05/02/2008 19:57:20
      RMAN-03015: error occurred in stored script Memory Script
      RMAN-06136: ORACLE error from auxiliary database: ORA-03135: connection lost contact

      Can I recover from this? What is the function of switch clone datafile all?

      Thanks in advance

      JH