Dear all,
I am facing problem while running duplicate database script. My primary database is ORCL and my standby database is STDBY, both database have started and STDBY database is running in nomount mode.
I have set all required parameters. Problem is that i can connect to STDBY database normally but when RMAN is trying to connect it, it is displaying following error. The output of CMD is shown below :
C:\WINDOWS\system32>set oracle_sid=orcl
C:\WINDOWS\system32>rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Thu Oct 13 16:16:26 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1444809023)
RMAN> connect auxiliary sys@stdby;
auxiliary database Password:
connected to auxiliary database: STDBY (not mounted)
RMAN> run {
2> allocate channel prmy1 type disk;
3> allocate channel prmy2 type disk;
4> allocate channel prmy3 type disk;
5> allocate channel prmy4 type disk;
6> allocate auxiliary channel stby type disk;
7> duplicate target database for standby from active database
8> spfile
9> parameter_value_convert 'orcl','stdby'
10> set db_unique_name='stdby'
11> set db_file_name_convert='+data','+sb'
12> set log_file_name_convert='+data','+sb'
13> set control_files='+sb','+sb'
14> set log_archive_max_processes='5'
15> set fal_server='orcl'
16> set standby_file_management='AUTO'
17> set log_archive_config='dg_config=(orcl,stdby)'
18> set log_archive_dest_2='service=orcl ASYNC valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=orcl'
19> ;
20> }
using target database control file instead of recovery catalog
allocated channel: prmy1
channel prmy1: SID=203 device type=DISK
allocated channel: prmy2
channel prmy2: SID=16 device type=DISK
allocated channel: prmy3
channel prmy3: SID=82 device type=DISK
allocated channel: prmy4
channel prmy4: SID=141 device type=DISK
allocated channel: stby
channel stby: SID=429 device type=DISK
Starting Duplicate Db at 13-OCT-16
contents of Memory Script:
{
backup as copy reuse
targetfile 'E:\app\Administrator\product\11.2.0\dbhome_2\DATABASE\PWDorcl.ORA' auxiliary format
'E:\app\Administrator\product\11.2.0\dbhome_2\DATABASE\PWDstdby.ORA' targetfile
'+DATA/orcl/spfileorcl.ora' auxiliary format
'E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_2\DATABASE\SPFILESTDBY.ORA' ;
sql clone "alter system set spfile= ''E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_2\DATABASE\SPFILESTDBY.ORA''";
}
executing Memory Script
Starting backup at 13-OCT-16
RMAN-03009: failure of backup command on prmy1 channel at 10/13/2016 16:18:38
ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-01017: invalid username/password; logon denied
ORA-17629: Cannot connect to the remote database server
continuing other job steps, job failed will not be re-run
released channel: prmy1
released channel: prmy2
released channel: prmy3
released channel: prmy4
released channel: stby
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/13/2016 16:18:38
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on prmy2 channel at 10/13/2016 16:18:38
ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-01017: invalid username/password; logon denied
ORA-17629: Cannot connect to the remote database server
RMAN> quit
Recovery Manager complete.
C:\WINDOWS\system32>set oracle_sid=stdby
C:\WINDOWS\system32>sqlplus sys/password@stdby as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Thu Oct 13 16:20:46 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>