8 Replies Latest reply: May 3, 2012 4:40 AM by user503699 RSS

    duplicate command fail

    886535
      I am testing new duplicate command in 11.2.0.1 i.e
      $duplicate target database to dbname from active database;
      But it was failed
      can give me some suggestion
      I am pasting



      [oracle@balakrushna ~]$ rman target / auxiliary sys/test@to_rman
      Recovery Manager: Release 11.2.0.1.0 - Production on Tue May 1 20:28:26 2012
      Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
      connected to target database: BALADB (DBID=1879616027)
      connected to auxiliary database: TESTDB (not mounted)
      RMAN> duplicate target database to testdb from active database;
      Starting Duplicate Db at 01-MAY-12
      using target database control file instead of recovery catalog
      allocated channel: ORA_AUX_DISK_1
      channel ORA_AUX_DISK_1: SID=20 device type=DISK
      allocated channel: ORA_AUX_DISK_2
      channel ORA_AUX_DISK_2: SID=21 device type=DISK
      contents of Memory Script:
      { sql clone "create spfile from memory";
      }
      executing Memory Script
      sql statement: create spfile from memory
      contents of Memory Script:
      {   shutdown clone immediate;
      startup clone nomount;}
      executing Memory Script
      Oracle instance shut down
      connected to auxiliary database (not started)
      Oracle instance started
      Total System Global Area 159019008 bytes
      Fixed Size 1335192 bytes
      Variable Size 150995048 bytes
      Database Buffers 4194304 bytes
      Redo Buffers 2494464 bytes
      contents of Memory Script:
      {  sql clone "alter system set  db_name =
      ''BALADB'' comment=
      ''Modified by RMAN duplicate'' scope=spfile";
      sql clone "alter system set db_unique_name =
      ''TESTDB'' comment=
      ''Modified by RMAN duplicate'' scope=spfile";
      shutdown clone immediate;
      startup clone force nomount
      backup as copy current controlfile auxiliary format '/oraeng/app/oracle/product/1120/dbs/cntrltest.dbf';
      alter clone database mount;}
      executing Memory Script
      sql statement: alter system set db_name = ''BALADB'' comment= ''Modified by RMAN duplicate'' scope=spfile
      sql statement: alter system set db_unique_name = ''TESTDB'' comment= ''Modified by RMAN duplicate'' scope=spfile
      Oracle instance shut down
      Oracle instance started
      Total System Global Area 159019008 bytes
      Fixed Size 1335192 bytes
      Variable Size 150995048 bytes
      Database Buffers 4194304 bytes
      Redo Buffers 2494464 bytes
      Starting backup at 01-MAY-12
      allocated channel: ORA_DISK_1
      channel ORA_DISK_1: SID=35 device type=DISK
      allocated channel: ORA_DISK_2
      channel ORA_DISK_2: SID=31 device type=DISK
      channel ORA_DISK_1: starting datafile copy
      copying current control file
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of Duplicate Db command at 05/01/2012 20:29:58
      RMAN-03015: error occurred in stored script Memory Script
      RMAN-03009: failure of backup command on ORA_DISK_1 channel at 05/01/2012 20:29:58
      ORA-17629: Cannot connect to the remote database server
      ORA-17627:
      ORA-17629: Cannot connect to the remote database server
        • 1. Re: duplicate command fail
          CKPT
          Hello,

          Always connect to target & auxiliary server with service names.
          Make sure you able to ping from target to target & auxiliary
          also
          Able to ping from Auxiliary to Target & Auxiliary too.


          oerr ora 17627
          17627, 00000, "%s"
          // *Cause:  An error returned by OCI while sending/receiving message from
          //          remote instance
          // *Action: Look at error message and take appropriate action or contact
          //          Oracle Support Services for further assistance
          • 2. Re: duplicate command fail
            886535
            I connecting through target and auxiliary through service name only
            otherwise check my listener.ora and tnsnames.ora and status also

            listener.ora file
            rman =
            (DESCRIPTION_LIST =
            (DESCRIPTION =
            (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.174.128)(PORT = 2014))
            )
            )
            )

            SID_LIST_rman =
            (SID_LIST =
            (SID_DESC =
            #(GLOBAL_DBNAME = dup.WORLD)
            (ORACLE_HOME = /oraeng/app/oracle/product/1120)
            (SID_NAME = test)
            )
            )

            tnsname.ora file is
            to_rman =
            (DESCRIPTION =
            (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.174.128)(PORT = 2014))
            )
            (CONNECT_DATA =
            (SERVICE_NAME = test)
            )
            )

            status of listener.ora

            LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 01-MAY-2012 20:31:46
            Copyright (c) 1991, 2009, Oracle. All rights reserved.

            Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.174.128)(PORT=2014)))
            STATUS of the LISTENER
            ------------------------
            Alias rman

            Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
            Start Date 30-APR-2012 02:27:50
            Uptime 1 days 18 hr. 3 min. 58 sec
            Trace Level off

            Security ON: Local OS Authentication
            SNMP OFF
            Listener Parameter File /oraeng/app/oracle/product/1120/listener.ora
            Listener Log File /oraeng/app/oracle/product/1120/log/diag/tnslsnr/balakrushna/rman/alert/log.xml
            Listening Endpoints Summary...
            (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.174.128)(PORT=2014)))
            Services Summary...
            Service "test" has 1 instance(s).
            Instance "test", status UNKNOWN, has 1 handler(s) for this service...
            The command completed successfully


            status of tnsnames.ora
            $ tnsping to_rman
            TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 01-MAY-2012 20:32:04
            Copyright (c) 1997, 2009, Oracle. All rights reserved.
            Used parameter files:
            Used TNSNAMES adapter to resolve the alia
            s
            )SERVICE_NAME = test)= TCP)(HOST = 192.168.174.128)(PORT = 2014))
            OK (80 msec)

            I a connecting to
            • 3. Re: duplicate command fail
              886535
              I a connecting to the target and auxiliary using
              $rman target / auxiliary sys/test@to_rman

              where i am wrong

              please give me suggestion
              • 4. Re: duplicate command fail
                user503699
                883532 wrote:
                I a connecting to the target and auxiliary using
                $rman target / auxiliary sys/test@to_rman

                where i am wrong

                please give me suggestion
                Not sure if it is a typo but your log for DUPLICATE shows that your auxiliary database name is TESTDB whereas your listener.ora/tnsnames.ora mention the SID as TEST.
                You may want to check which one is correct.
                • 5. Re: duplicate command fail
                  886535
                  Test is correct
                  But i dont know why i m getting this error
                  I export SID test in auxiliary side
                  • 6. Re: duplicate command fail
                    user503699
                    883532 wrote:
                    Test is correct
                    But i dont know why i m getting this error
                    I export SID test in auxiliary side
                    But what is the value of DB_NAME on your auxiliary instance?
                    Also for active database duplication, you have to use service name to connect to source and auxiliary databases.
                    From your original post, it seems you are using "CONNECT TARGET /", which is incorrect.
                    I assume you have the same password file (with same password) on both instances ??
                    • 7. Re: duplicate command fail
                      886535
                      I have created separate password file but still i m getting same error
                      Now i connect
                      $ rman target sys/sys auxiliary sys/test@to_rman
                      db_name of auxiliary side is testdb
                      • 8. Re: duplicate command fail
                        user503699
                        883532 wrote:
                        I have created separate password file but still i m getting same error
                        Now i connect
                        $ rman target sys/sys auxiliary sys/test@to_rman
                        db_name of auxiliary side is testdb
                        You need to connect to the source using net service name as well for active database duplication. Something like this
                        rman target=sys/sys@src auxiliary=sys/test@to_rman