6 Replies Latest reply: Dec 27, 2013 2:49 PM by Green-bit RSS

    RMAN Duplicate --- ORA-01092: ORACLE instance terminated. Disconnection forced

    Green-bit

      Source DB - 11.2.0.2.0

      Target DB  - 11.2.0.2.0

      OS - SunOS 5.11

      Hello Guys I am trying to restore a database through a duplicate command. The following are the scripts I am using.

       

       

       

      this is the script in which the restore.cmd is invoked.

       

      -----------------------------restore.sh--------------------------------------------------------------

       

      #!/usr/bin/ksh

      #PATH=$PATH"/usr/ccs/bin:/usr/bin:/usr/sbin:/usr/sbin/nsr:/usr/ucb:/usr/ucb:/etc:/usr/local/bin"

      #LD_LIBRARY_PATH=/usr/openwin/lib:/usr/ccs/lib

      #export PATH LD_LIBRARY_PATH

       

       

      GET_DATE=`date "+%y%m%d%H%M%S"`

      CHK_DATE=`date "+%y%m%d"`

      GET_YEAR=`date "+%y"`

      GET_DAY=`date "+%d"`

      WEEK_DAY=`date "+%w"`

      GET_MONTH=`date "+%m"`

       

       

       

       

      ORAENV_ASK=NO

      #. /usr/local/bin/oraenv

      . $HOME/.profile

      echo ${ORACLE_SID}

      ################################################################################################################

      echo $ORACLE_HOME $DB_NAME $ORACLE_BASE

      export ORACLE_HOME DB_NAME ORACLE_BASE

      EXPHOME=/export/home/oracle

      CLN_Home=/export/home/oracle

      job_log_file="${EXPHOME}/rman_restore.log"

       

       

      ${ORACLE_HOME}/bin/rman trace=/export/home/oracle/mytrace msglog ${EXPHOME}/rman_restore_msg_log.log append<<!

      connect auxiliary /

      set dbid=5798365608

      set echo on;

      @${CLN_Home}/restore.cmd

      exit

      !

       

      Soon after the spfile is restore I am getting the following error.

      -------------RMAN DUPLICATE ERROR------------------------------------

       

      connected to auxiliary database (not started)

      Oracle instance started

       

       

      Total System Global Area    8554127360 bytes

       

       

      Fixed Size                     2175440 bytes

      Variable Size               5117054512 bytes

      Database Buffers            3170893824 bytes

      Redo Buffers                 264003584 bytes

      Calling krmmpem from krmmmai

      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-01092: ORACLE instance terminated. Disconnection forced

      RMAN-03002: failure of Duplicate Db command at 12/27/2013 12:18:10

      RMAN-05501: aborting duplication of target database

      RMAN-03015: error occurred in stored script Memory Script

      ORA-03113: end-of-file on communication channel

       

      ---------ATTEMPTS to resolve the error-----------

      when I checked google, some said, it might be undo tablespace issue, so I set the undo_tablespace parameter in the target same as the source. Then again I was getting the same error.

       

      The source database hasn't been upgraded, so this is not a problem of the upgrading.

       

       

      can some one give any outputs as to how this issue can be resolved?

       

      Thank you