3 Replies Latest reply: Feb 1, 2013 6:37 AM by 891445 RSS

    Duplicate failed

    891445
      Duplicate failed with below error.
      The catalog database is up and running




      "rman_Dup_full.log_DEVDB_2013-01-20_21_11_32" 1600 lines, 71681 characters
      {
      switch clone datafile all;
      }
      RMAN-08162: executing Memory Script

      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of Duplicate Db command at 01/20/2013 06:36:34
      RMAN-03015: error occurred in stored script Memory Script
      RMAN-06004: ORACLE error from recovery catalog database: ORA-03114: not connected to ORACLE
      RMAN-06004: ORACLE error from recovery catalog database: ORA-03114: not connected to ORACLE
        • 1. Re: Duplicate failed
          652072
          Please provide the full script of duplication, and also check the SQLNET.EXPIRE_TIME value to be configured less than TCP/IP time out on the firewall If catalog database is connected over network, check with System administrator

          Naga
          • 2. Re: Duplicate failed
            brunors
            Did you try to flush in shared poll? Try and run again.

            Alter system flush shared_poll;


            Kind regard, Bruno Reis.
            • 3. Re: Duplicate failed
              891445
              The restore ran for around 10 hrs., and all the datafiles are restored. There was no error or timeout reported during that time.
              But during recovery, this error is reported. Controlfile is created, but with only system datafile in it.