Good morning. I am having problems creating a standby database using RMAN. Both databases are version 11.2.0.3, on Linux platforms. I can tnsping the databases in both directions. When I start the script, the spfile restores fine, and it executes the memory script, but then the auxiliary database shuts down, and doesn't start up, and the script fails. Has anyone come across this before? Here is the output when I try and create the standby:
oracle@tnt-dbsrv1:~> rman target sys@ppptt1c auxiliary sys@ppptt1s
Recovery Manager: Release 11.2.0.3.0 - Production on Tue Mar 15 09:29:43 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: PPPTT1C (DBID=2106128194)
connected to auxiliary database: PPPTT1S (not mounted)
RMAN> run {
allocate channel prmy1 type disk;
allocate channel prmy2 type disk;
allocate channel prmy3 type disk;
allocate channel prmy4 type disk;
allocate auxiliary channel stby type disk;
duplicate target database for standby
spfile
parameter_value_convert 'ppptt1c','ppptt1s'
set db_unique_name='ppptt1s'
set db_file_name_convert='ppptt1c','ppptt1s'
set log_file_name_convert='ppptt1c','ppptt1s'
set fal_server='ppptt1p'
set standby_file_management='AUTO'
set log_archive_config='dg_config=(ppptt1c,ppptt1s)'
set log_archive_dest_3='service=ppptt1p lgwr sync affirm valid_for=(all_logfiles,primary_role) db_unique_name=ppptt1c'
;
}
17> 18>
using target database control file instead of recovery catalog
allocated channel: prmy1
channel prmy1: SID=613 device type=DISK
allocated channel: prmy2
channel prmy2: SID=28 device type=DISK
allocated channel: prmy3
channel prmy3: SID=420 device type=DISK
allocated channel: prmy4
channel prmy4: SID=402 device type=DISK
allocated channel: stby
channel stby: SID=5 device type=DISK
Starting Duplicate Db at 15/03/2016 09:30:38
contents of Memory Script:
{
restore clone spfile to '/apps/oracle/product/11.2/db_1/dbs/spfileppptt1s.ora';
sql clone "alter system set spfile= ''/apps/oracle/product/11.2/db_1/dbs/spfileppptt1s.ora''";
}
executing Memory Script
Starting restore at 15/03/2016 09:30:40
channel stby: starting datafile backup set restore
channel stby: restoring SPFILE
output file name=/apps/oracle/product/11.2/db_1/dbs/spfileppptt1s.ora
channel stby: reading from backup piece /data_backup/oracle/db_backup/ppptt1c/c-2106128194-20160306-02
channel stby: piece handle=/data_backup/oracle/db_backup/ppptt1c/c-2106128194-20160306-02 tag=TAG20160306T002330
channel stby: restored backup piece 1
channel stby: restore complete, elapsed time: 00:00:00
Finished restore at 15/03/2016 09:31:00
sql statement: alter system set spfile= ''/apps/oracle/product/11.2/db_1/dbs/spfileppptt1s.ora''
contents of Memory Script:
{
sql clone "alter system set db_unique_name =
''ppptt1s'' comment=
'''' scope=spfile";
sql clone "alter system set db_file_name_convert =
''ppptt1c'', ''ppptt1s'' comment=
'''' scope=spfile";
sql clone "alter system set log_file_name_convert =
''ppptt1c'', ''ppptt1s'' comment=
'''' scope=spfile";
sql clone "alter system set fal_server =
''ppptt1p'' 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=(ppptt1c,ppptt1s)'' comment=
'''' scope=spfile";
sql clone "alter system set log_archive_dest_3 =
''service=ppptt1p lgwr sync affirm valid_for=(all_logfiles,primary_role) db_unique_name=ppptt1c'' comment=
'''' scope=spfile";
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script
sql statement: alter system set db_unique_name = ''ppptt1s'' comment= '''' scope=spfile
sql statement: alter system set db_file_name_convert = ''ppptt1c'', ''ppptt1s'' comment= '''' scope=spfile
sql statement: alter system set log_file_name_convert = ''ppptt1c'', ''ppptt1s'' comment= '''' scope=spfile
sql statement: alter system set fal_server = ''ppptt1p'' 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=(ppptt1c,ppptt1s)'' comment= '''' scope=spfile
sql statement: alter system set log_archive_dest_3 = ''service=ppptt1p lgwr sync affirm valid_for=(all_logfiles,primary_role) db_unique_name=ppptt1c'' comment= '''' scope=spfile
Oracle instance shut down
released channel: prmy1
released channel: prmy2
released channel: prmy3
released channel: prmy4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 03/15/2016 09:31:18
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
Thank you very much.