3 Replies Latest reply: Jan 3, 2013 6:31 PM by mseberg RSS

    failure of duplicate db command... aborting duplication of target

    yakub21
      There is something wrong with my implementation and would appreciate feedback to resolve:

      Start up the standby in nomount:

      cat initKEMETSnew.ora
      KEMETS.__db_cache_size=402653184
      KEMETS.__java_pool_size=33554432
      KEMETS.__large_pool_size=16777216
      KEMETS.__oracle_base='/u01/kemet'#ORACLE_BASE set from environment
      KEMETS.__pga_aggregate_target=738197504
      KEMETS.__sga_target=838860800
      KEMETS.__shared_io_pool_size=0
      KEMETS.__shared_pool_size=369098752
      KEMETS.__streams_pool_size=0
      *._trace_files_public=FALSE
      *.audit_file_dest='/u01/kemet/admin/KEMET/adump'
      *.audit_sys_operations=TRUE
      *.audit_trail='DB','EXTENDED'
      *.cluster_database=FALSE
      *.compatible='11.2.0.0.0'
      #*.control_files='/u01/kemet/oradata/KEMET/control01.ctl','/u01/kemet/oradata/KEMET/control02.ctl'
      *.db_block_size=8192
      *.db_domain='respecti.com'
      *.db_file_name_convert='/u01/kemet/oradata/KEMET/','/u01/kemet/oradata/KEMET/'
      *.db_name='KEMET'
      *.db_recovery_file_dest='/u01/kemet/flash_recovery_area'
      *.db_recovery_file_dest_size=5218762752
      *.db_unique_name='KEMETS'
      *.diagnostic_dest='/u01/kemet'
      *.dispatchers='(PROTOCOL=TCP) (SERVICE=KEMETXDB)'
      *.fal_client='KEMETS'
      *.fal_server='KEMET'
      *.local_listener='LISTENER_KEMETS'
      *.log_archive_dest_1='location=use_db_recovery_file_dest valid_for=(all_logfiles,all_roles) db_unique_name=KEMETS'
      *.log_archive_dest_2='service=KEMET lgwr async valid_for=(online_logfiles,primary_role) db_unique_name=KEMET'
      *.log_archive_format='KEMET%t_%s_%r.arc'
      *.log_archive_max_processes=30
      *.log_file_name_convert='/u01/kemet/oradata/KEMET/','/u01/kemet/oradata/KEMET/'
      *.memory_target=1577058304
      *.O7_DICTIONARY_ACCESSIBILITY=FALSE
      *.open_cursors=300
      *.processes=300
      *.remote_login_passwordfile='EXCLUSIVE'
      *.sec_max_failed_login_attempts=3
      *.sessions=472
      *.standby_file_management='AUTO'
      *.undo_tablespace='UNDOTBS1'
      *.service_names='KEMETS.respecti.com,KEMETS'
      *.log_archive_config='DG_CONFIG=(KEMET,KEMETS)'
      KEMET >

      SQL> nnect / as sysdba
      Connected to an idle instance.
      SQL> startup nomount pfile='/u01/kemet/11.2.0.3/KEMET/dbs/initKEMETSnew.ora';
      ORACLE instance started.

      Total System Global Area 1570009088 bytes
      Fixed Size          2228704 bytes
      Variable Size          1157631520 bytes
      Database Buffers     402653184 bytes
      Redo Buffers          7495680 bytes
      SQL>


      Verify Primary and Standby SQLNet connection:
      sqlplus sys/guidei@kemet as sysdba
      SQL*Plus: Release 11.2.0.3.0 Production on Wed Jan 2 23:10:28 2013

      Copyright (c) 1982, 2011, Oracle. All rights reserved.


      Connected to:
      Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
      With the Partitioning, OLAP, Data Mining and Real Application Testing options

      SQL> exit
      Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
      With the Partitioning, OLAP, Data Mining and Real Application Testing options
      KEMET >sqlplus sys/guidei@kemets as sysdba

      SQL*Plus: Release 11.2.0.3.0 Production on Wed Jan 2 23:10:37 2013

      Copyright (c) 1982, 2011, Oracle. All rights reserved.


      Connected to:
      Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
      With the Partitioning, OLAP, Data Mining and Real Application Testing options

      SQL>




      Spooling started in log file: dup_KEMETS.log

      Recovery Manager11.2.0.3.0

      RMAN> run {
      2> allocate channel p1 type disk;
      3> allocate channel p2 type disk;
      4> allocate auxiliary channel stby type disk;
      5> duplicate target database for standby from active database
      6> spfile
      7> parameter_value_convert 'KEMET','KEMETS'
      8> set db_unique_name='KEMETS'
      9> set db_file_name_convert='/u01/kemet/oradata/KEMET/','/u01/kemet/oradata/KEMET/'
      10> set log_file_name_convert='/u01/kemet/oradata/KEMET/','/u01/kemet/oradata/KEMET/'
      11> set control_files='/u01/kemet/oradata/KEMET/control02.ctl'
      12> set log_archive_max_processes='30'
      13> set fal_client='KEMETS'
      14> set fal_server='KEMET'
      15> set standby_file_management='AUTO'
      16> set log_archive_config='dg_config=(KEMET,KEMETS)'
      17> set log_archive_dest_2='service=kemet async valid_for=(online_logfile,primary_role) db_unique_name=KEMET';
      18> }
      using target database control file instead of recovery catalog
      allocated channel: p1
      channel p1: SID=13 device type=DISK

      allocated channel: p2
      channel p2: SID=181 device type=DISK

      allocated channel: stby
      channel stby: SID=357 device type=DISK

      Starting Duplicate Db at 02-JAN-13

      contents of Memory Script:
      {
      backup as copy reuse
      targetfile '/u01/kemet/11.2.0.3/KEMET/dbs/orapwKEMET' auxiliary format
      '/u01/kemet/11.2.0.3/KEMET/dbs/orapwKEMETS' targetfile
      '/u01/kemet/11.2.0.3/KEMET/dbs/spfileKEMET.ora' auxiliary format
      '/u01/kemet/11.2.0.3/KEMET/dbs/spfileKEMETS.ora' ;
      sql clone "alter system set spfile= ''/u01/kemet/11.2.0.3/KEMET/dbs/spfileKEMETS.ora''";
      }
      executing Memory Script

      Starting backup at 02-JAN-13
      Finished backup at 02-JAN-13

      sql statement: alter system set spfile= ''/u01/kemet/11.2.0.3/KEMET/dbs/spfileKEMETS.ora''

      contents of Memory Script:
      {
      sql clone "alter system set audit_file_dest =
      ''/u01/kemet/admin/KEMETS/adump'' comment=
      '''' scope=spfile";
      sql clone "alter system set dispatchers =
      ''(PROTOCOL=TCP) (SERVICE=KEMETSXDB)'' comment=
      '''' scope=spfile";
      sql clone "alter system set local_listener =
      ''LISTENER_KEMETS'' comment=
      '''' scope=spfile";
      sql clone "alter system set log_archive_dest_1 =
      ''location=use_db_recovery_file_dest valid_for=(all_logfiles,all_roles) db_unique_name=KEMETS'' comment=
      '''' scope=spfile";
      sql clone "alter system set log_archive_format =
      ''KEMETS%t_%s_%r.arc'' comment=
      '''' scope=spfile";
      sql clone "alter system set service_names =
      ''KEMETS.respecti.com,KEMET'' comment=
      '''' scope=spfile";
      sql clone "alter system set db_unique_name =
      ''KEMETS'' comment=
      '''' scope=spfile";
      sql clone "alter system set db_file_name_convert =
      ''/u01/kemet/oradata/KEMET/'', ''/u01/kemet/oradata/KEMET/'' comment=
      '''' scope=spfile";
      sql clone "alter system set log_file_name_convert =
      ''/u01/kemet/oradata/KEMET/'', ''/u01/kemet/oradata/KEMET/'' comment=
      '''' scope=spfile";
      sql clone "alter system set control_files =
      ''/u01/kemet/oradata/KEMET/control02.ctl'' comment=
      '''' scope=spfile";
      sql clone "alter system set log_archive_max_processes =
      30 comment=
      '''' scope=spfile";
      sql clone "alter system set fal_client =
      ''KEMETS'' comment=
      '''' scope=spfile";
      sql clone "alter system set fal_server =
      ''KEMET'' comment=
      '''' scope=spfile";
      sql clone "alter system set standby_file_management =
      ''AUTO'' comment=
      '''' scope=spfile";
      sql clone "alter system set log_archive_config =
      ''dg_config=(KEMET,KEMETS)'' comment=
      '''' scope=spfile";
      sql clone "alter system set log_archive_dest_2 =
      ''service=kemet async valid_for=(online_logfile,primary_role) db_unique_name=KEMET'' comment=
      '''' scope=spfile";
      shutdown clone immediate;
      startup clone nomount;
      }
      executing Memory Script

      sql statement: alter system set audit_file_dest = ''/u01/kemet/admin/KEMETS/adump'' comment= '''' scope=spfile

      sql statement: alter system set dispatchers = ''(PROTOCOL=TCP) (SERVICE=KEMETSXDB)'' comment= '''' scope=spfile

      sql statement: alter system set local_listener = ''LISTENER_KEMETS'' comment= '''' scope=spfile

      sql statement: alter system set log_archive_dest_1 = ''location=use_db_recovery_file_dest valid_for=(all_logfiles,all_roles) db_unique_name=KEMETS'' comment= '''' scope=spfile

      sql statement: alter system set log_archive_format = ''KEMETS%t_%s_%r.arc'' comment= '''' scope=spfile

      sql statement: alter system set service_names = ''KEMETS.respecti.com,KEMET'' comment= '''' scope=spfile

      sql statement: alter system set db_unique_name = ''KEMETS'' comment= '''' scope=spfile

      sql statement: alter system set db_file_name_convert = ''/u01/kemet/oradata/KEMET/'', ''/u01/kemet/oradata/KEMET/'' comment= '''' scope=spfile

      sql statement: alter system set log_file_name_convert = ''/u01/kemet/oradata/KEMET/'', ''/u01/kemet/oradata/KEMET/'' comment= '''' scope=spfile

      sql statement: alter system set control_files = ''/u01/kemet/oradata/KEMET/control02.ctl'' comment= '''' scope=spfile

      sql statement: alter system set log_archive_max_processes = 30 comment= '''' scope=spfile

      sql statement: alter system set fal_client = ''KEMETS'' comment= '''' scope=spfile

      sql statement: alter system set fal_server = ''KEMET'' comment= '''' scope=spfile

      sql statement: alter system set standby_file_management = ''AUTO'' comment= '''' scope=spfile

      sql statement: alter system set log_archive_config = ''dg_config=(KEMET,KEMETS)'' comment= '''' scope=spfile

      sql statement: alter system set log_archive_dest_2 = ''service=kemet async valid_for=(online_logfile,primary_role) db_unique_name=KEMET'' comment= '''' scope=spfile

      Oracle instance shut down

      released channel: p1
      released channel: p2
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of Duplicate Db command at 01/02/2013 19:57:35
      RMAN-05501: aborting duplication of target database
      RMAN-03015: error occurred in stored script Memory Script
      RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

      RMAN> spool log off


      After the standby gets shutdown via the duplicate, it errors out. Does anyone have any suggestions?

      tnsnames.ora on Primary:
      LISTENER_KEMET = (ADDRESS = (PROTOCOL = TCP)(HOST = linuxmac1.respecti.com)(port = 2021))

      KEMET, KEMET.respecti.com =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = linuxmac1.respecti.com)(port = 2021))
      )
      (CONNECT_DATA =
      (SERVICE_NAME = KEMET.respecti.com)
      #(SERVER = DEDICATED)
      )
      )

      KEMETS, KEMETS.respecti.com =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = linuxmac2.respecti.com)(PORT = 2021))
      )
      (CONNECT_DATA =
      (SERVICE_NAME = KEMETS.respecti.com) (UR = A)
      (SERVER = DEDICATED)
      )
      )

      LISTENER_KEMET =
      (DESCRIPTION_LIST =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP) (HOST = linuxmac1.respecti.com)(port = 2021))
      (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC2021))
      )
      )
      ENABLE_GLOBAL_DYNAMIC_ENDPOINT_KEMET=on

      ADR_BASE_LISTENER_KEMET = /u01/kemet

      SID_LIST_LISTENER_KEMET =
      (sid_list =
      (sid_desc =
      (sid_name = PLSExtProc)
      (ORACLE_HOME = /u01/kemet/11.2.0.3/KEMET)
      (PROGRAM = extproc)
      )
      (SID_DESC =
      (GLOBAL_DBNAME = KEMET.respecti.com)
      (SID_NAME = KEMET)
      (ORACLE_HOME = /u01/kemet/11.2.0.3/KEMET)
      )
      )
        • 1. Re: failure of duplicate db command... aborting duplication of target
          mseberg
          Hello;

          It might be a timeout, I prevent using :
          Prevent Timeouts
          
          Add these to both servers
          
          To listener.ora
          INBOUND_CONNECT_TIMEOUT_ = 120
          
          To sqlnet.ora
          SQLNET.INBOUND_CONNECT_TIMEOUT = 120
          
          
          Then stop and start the listener.
          Then me double check your post again for anything else.

          This
          RMAN> run {
          2> allocate channel p1 type disk;
          3> allocate channel p2 type disk;
          4> allocate auxiliary channel stby type disk;
          5> duplicate target database for standby from active database
          6> spfile
          7> parameter_value_convert 'KEMET','KEMETS'
          8> set db_unique_name='KEMETS'
          9> set db_file_name_convert='/u01/kemet/oradata/KEMET/','/u01/kemet/oradata/KEMET/'
          10> set log_file_name_convert='/u01/kemet/oradata/KEMET/','/u01/kemet/oradata/KEMET/'
          11> set control_files='/u01/kemet/oradata/KEMET/control02.ctl'
          12> set log_archive_max_processes='30'
          13> set fal_client='KEMETS'
          14> set fal_server='KEMET'
          15> set standby_file_management='AUTO'
          16> set log_archive_config='dg_config=(KEMET,KEMETS)'
          17> set log_archive_dest_2='service=kemet async valid_for=(online_logfile,primary_role) db_unique_name=KEMET';
          18> }
          Is very complex. I generally only use :
          DUPLICATE TARGET DATABASE TO RECLONE FROM ACTIVE DATABASE NOFILENAMECHECK; 
          And let the INIT file handle everything else.

          h3. Important

          you need an entry for the CLONE in your TNSNAMES.ORA on both servers

          h3. More

          This cannot be right

          db_file_name_convert='/u01/kemet/oradata/KEMET/','/u01/kemet/oradata/KEMET/'

          Example

          DB_FILE_NAME_CONVERT=('/u01/app/oracle/oradata/RECOVER2', '/u01/app/oracle/oradata/RECLONE','/u01/oradata/RECOVER2','/u01/oradata/RECLONE')

          Same problem here

          log_file_name_convert='/u01/kemet/oradata/KEMET/','/u01/kemet/oradata/KEMET/'

          It converts nothing, would exact first string to be KEMETS

          Example

          LOG_FILE_NAME_CONVERT=('/u01/app/oracle/flash_recovery_area/RECOVER2', '/u01/app/oracle/flash_recovery_area/RECLONE')


          Would consider a simple INIT for the duplicate process : ( This needs some work but should work )
          db_block_size=8192
          db_name='KEMET'
          control_files='/u01/kemet/oradata/KEMET/control01.ctl','/u01/kemet/oradata/KEMET/control02.ctl'
          db_file_name_convert='/u01/kemet/oradata/KEMETS/','/u01/kemet/oradata/KEMET/'
          log_file_name_convert='/u01/kemet/oradata/KEMETS/','/u01/kemet/oradata/KEMET/'
          audit_file_dest='/u01/kemet/admin/KEMET/adump'
          core_dump_dest=
          diagnostic_dest=
          core_dump_dest=
          log_archive_dest_1=
          log_archive_max_processes=30
          open_cursors=300
          pga_aggregate_target=
          remote_login_passwordfile='EXCLUSIVE'
          sga_target=
          undo_management='AUTO'
          undo_retention=10800
          undo_tablespace='UNDOTBS1'
          db_recovery_file_dest_size=5218762752
          audit_trail='DB'
          compatible='11.2.0.0.0'
          db_recovery_file_dest='/u01/kemet/flash_recovery_area'
          fal_client - Is obsolete in Oracle 11r2 unless you have more than one Standby.

          FAL becahivor on 11.2 [ID 1394472.1]

          ( Yes, I reported the typo in this document to Oracle support )


          Best Regards

          mseberg

          Edited by: mseberg on Jan 3, 2013 10:49 AM

          Edited by: mseberg on Jan 3, 2013 10:51 AM
          • 2. Re: failure of duplicate db command... aborting duplication of target
            yakub21
            cat $TNS_ADMIN/listener.ora
            # listener.ora Network Configuration File: /u01/kemet/11.2.0/KEMET/network/admin/listener.ora
            # Generated by Oracle configuration tools.
            SQLNET.INBOUND_CONNECT_TIMEOUT=120
            SQLNET.OUTBOUND_CONNECT_TIMEOUT=120

            LISTENER_KEMET =
            (DESCRIPTION_LIST =
            (DESCRIPTION =
            (ADDRESS = (PROTOCOL = TCP) (HOST = linuxmac1.respecti.com)(port = 2021))
            (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC2021))
            )
            )
            ENABLE_GLOBAL_DYNAMIC_ENDPOINT_KEMET=on

            ADR_BASE_LISTENER_KEMET = /u01/kemet

            SID_LIST_LISTENER_KEMET =
            (sid_list =
            (sid_desc =
            (sid_name = PLSExtProc)
            (ORACLE_HOME = /u01/kemet/11.2.0.3/KEMET)
            (PROGRAM = extproc)
            )
            (SID_DESC =
            (GLOBAL_DBNAME = KEMET.respecti.com)
            (SID_NAME = KEMET)
            (ORACLE_HOME = /u01/kemet/11.2.0.3/KEMET)
            )
            )
            KEMET >

            cat $TNS_ADMIN/sqlnet.ora
            SQLNET.INBOUND_CONNECT_TIMEOUT=120
            SQLNET.OUTBOUND_CONNECT_TIMEOUT=120
            KEMET >



            rman target sys/guidei@kemet auxiliary sys/guidei@kemets

            Recovery Manager: Release 11.2.0.3.0 - Production on Thu Jan 3 03:43:53 2013

            Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

            connected to target database: KEMET (DBID=3765485650)
            connected to auxiliary database: KEMET (not mounted)

            RMAN> @/u01/owrk/dataguard/dup_KEMETS.rman

            cat dup_KEMETS.log

            Spooling started in log file: dup_KEMETS.log

            Recovery Manager11.2.0.3.0

            RMAN> run {
            2> allocate channel p1 type disk;
            3> allocate channel p2 type disk;
            4> allocate auxiliary channel stby type disk;
            5> duplicate target database for standby from active database
            6> spfile
            7> parameter_value_convert 'KEMET','KEMETS'
            8> set db_unique_name='KEMETS'
            9> set db_file_name_convert='/u01/kemet/oradata/KEMET/','/u01/kemet/oradata/KEMET/'
            10> set log_file_name_convert='/u01/kemet/oradata/KEMET/','/u01/kemet/oradata/KEMET/'
            11> set control_files='/u01/kemet/oradata/KEMET/control02.ctl'
            12> set log_archive_max_processes='30'
            13> set fal_client='KEMETS'
            14> set fal_server='KEMET'
            15> set standby_file_management='AUTO'
            16> set log_archive_config='dg_config=(KEMET,KEMETS)'
            17> set log_archive_dest_2='service=kemet async valid_for=(online_logfile,primary_role) db_unique_name=KEMET';
            18> }
            using target database control file instead of recovery catalog
            allocated channel: p1
            channel p1: SID=367 device type=DISK

            allocated channel: p2
            channel p2: SID=427 device type=DISK

            allocated channel: stby
            channel stby: SID=357 device type=DISK

            Starting Duplicate Db at 03-JAN-13

            contents of Memory Script:
            {
            backup as copy reuse
            targetfile '/u01/kemet/11.2.0.3/KEMET/dbs/orapwKEMET' auxiliary format
            '/u01/kemet/11.2.0.3/KEMET/dbs/orapwKEMETS' targetfile
            '/u01/kemet/11.2.0.3/KEMET/dbs/spfileKEMET.ora' auxiliary format
            '/u01/kemet/11.2.0.3/KEMET/dbs/spfileKEMETS.ora' ;
            sql clone "alter system set spfile= ''/u01/kemet/11.2.0.3/KEMET/dbs/spfileKEMETS.ora''";
            }
            executing Memory Script

            Starting backup at 03-JAN-13
            Finished backup at 03-JAN-13

            sql statement: alter system set spfile= ''/u01/kemet/11.2.0.3/KEMET/dbs/spfileKEMETS.ora''

            contents of Memory Script:
            {
            sql clone "alter system set audit_file_dest =
            ''/u01/kemet/admin/KEMETS/adump'' comment=
            '''' scope=spfile";
            sql clone "alter system set dispatchers =
            ''(PROTOCOL=TCP) (SERVICE=KEMETSXDB)'' comment=
            '''' scope=spfile";
            sql clone "alter system set local_listener =
            ''LISTENER_KEMETS'' comment=
            '''' scope=spfile";
            sql clone "alter system set log_archive_dest_1 =
            ''location=use_db_recovery_file_dest valid_for=(all_logfiles,all_roles) db_unique_name=KEMETS'' comment=
            '''' scope=spfile";
            sql clone "alter system set log_archive_format =
            ''KEMETS%t_%s_%r.arc'' comment=
            '''' scope=spfile";
            sql clone "alter system set service_names =
            ''KEMETS.respecti.com,KEMET'' comment=
            '''' scope=spfile";
            sql clone "alter system set db_unique_name =
            ''KEMETS'' comment=
            '''' scope=spfile";
            sql clone "alter system set db_file_name_convert =
            ''/u01/kemet/oradata/KEMET/'', ''/u01/kemet/oradata/KEMET/'' comment=
            '''' scope=spfile";
            sql clone "alter system set log_file_name_convert =
            ''/u01/kemet/oradata/KEMET/'', ''/u01/kemet/oradata/KEMET/'' comment=
            '''' scope=spfile";
            sql clone "alter system set control_files =
            ''/u01/kemet/oradata/KEMET/control02.ctl'' comment=
            '''' scope=spfile";
            sql clone "alter system set log_archive_max_processes =
            30 comment=
            '''' scope=spfile";
            sql clone "alter system set fal_client =
            ''KEMETS'' comment=
            '''' scope=spfile";
            sql clone "alter system set fal_server =
            ''KEMET'' comment=
            '''' scope=spfile";
            sql clone "alter system set standby_file_management =
            ''AUTO'' comment=
            '''' scope=spfile";
            sql clone "alter system set log_archive_config =
            ''dg_config=(KEMET,KEMETS)'' comment=
            '''' scope=spfile";
            sql clone "alter system set log_archive_dest_2 =
            ''service=kemet async valid_for=(online_logfile,primary_role) db_unique_name=KEMET'' comment=
            '''' scope=spfile";
            shutdown clone immediate;
            startup clone nomount;
            }
            executing Memory Script

            sql statement: alter system set audit_file_dest = ''/u01/kemet/admin/KEMETS/adump'' comment= '''' scope=spfile

            sql statement: alter system set dispatchers = ''(PROTOCOL=TCP) (SERVICE=KEMETSXDB)'' comment= '''' scope=spfile

            sql statement: alter system set local_listener = ''LISTENER_KEMETS'' comment= '''' scope=spfile

            sql statement: alter system set log_archive_dest_1 = ''location=use_db_recovery_file_dest valid_for=(all_logfiles,all_roles) db_unique_name=KEMETS'' comment= '''' scope=spfile

            sql statement: alter system set log_archive_format = ''KEMETS%t_%s_%r.arc'' comment= '''' scope=spfile

            sql statement: alter system set service_names = ''KEMETS.respecti.com,KEMET'' comment= '''' scope=spfile

            sql statement: alter system set db_unique_name = ''KEMETS'' comment= '''' scope=spfile

            sql statement: alter system set db_file_name_convert = ''/u01/kemet/oradata/KEMET/'', ''/u01/kemet/oradata/KEMET/'' comment= '''' scope=spfile

            sql statement: alter system set log_file_name_convert = ''/u01/kemet/oradata/KEMET/'', ''/u01/kemet/oradata/KEMET/'' comment= '''' scope=spfile

            sql statement: alter system set control_files = ''/u01/kemet/oradata/KEMET/control02.ctl'' comment= '''' scope=spfile

            sql statement: alter system set log_archive_max_processes = 30 comment= '''' scope=spfile

            sql statement: alter system set fal_client = ''KEMETS'' comment= '''' scope=spfile

            sql statement: alter system set fal_server = ''KEMET'' comment= '''' scope=spfile

            sql statement: alter system set standby_file_management = ''AUTO'' comment= '''' scope=spfile

            sql statement: alter system set log_archive_config = ''dg_config=(KEMET,KEMETS)'' comment= '''' scope=spfile

            sql statement: alter system set log_archive_dest_2 = ''service=kemet async valid_for=(online_logfile,primary_role) db_unique_name=KEMET'' comment= '''' scope=spfile

            Oracle instance shut down

            released channel: p1
            released channel: p2
            RMAN-00571: ===========================================================
            RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
            RMAN-00571: ===========================================================
            RMAN-03002: failure of Duplicate Db command at 01/03/2013 03:44:41
            RMAN-05501: aborting duplication of target database
            RMAN-03015: error occurred in stored script Memory Script
            RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

            RMAN> spool log off
            KEMET >

            Advice is Appreciated. Thanks in advance
            • 3. Re: failure of duplicate db command... aborting duplication of target
              mseberg
              It looks form this :
              rman target sys/guidei@kemet auxiliary sys/guidei@kemets
              
              Recovery Manager: Release 11.2.0.3.0 - Production on Thu Jan 3 03:43:53 2013
              
              Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
              
              connected to target database: KEMET (DBID=3765485650)
              connected to auxiliary database: KEMET (not mounted)
              That you are running the duplicate command from the target database. You should run the duplicate database from the auxiliary database.

              Run the RMAN duplicate from auxiliary

              Take a look at my short notes :

              http://www.visi.com/~mseberg/standby_creation_from_active_database_using_rman.html

              Best Regards and Best of Luck.

              mseberg