This discussion is archived
3 Replies Latest reply: Jan 3, 2013 4:31 PM by mseberg RSS

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

yakub21 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points