Hi,
I am trying to create a physical standby RAC (Two Nodes) from a Primary RAC (Two Nodes). I have done the following
- Installed Grid and Oracle Software in both the nodes in Primary
- Created Database in the Primary
- Installed Grid and Oracle DB software in both the nodes in Standby
- Updated the spfile with data guard configuration
- copied the spfile to pfile for standby and modified
- copied the password file from asm to standby asm
- created a database service using srvctl in the standby
- Configured the listener and tnsnames
- Started the standby using the pfile
- Oracle Database Version is 12.1.0.2
Now when I am running the rman command, I am getting the following error
$ rman target sys/*****@drcpdb1 auxiliary sys/*****@drcsdb1
Recovery Manager: Release 12.1.0.2.0 - Production on Wed Feb 24 17:50:09 2016
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
connected to target database: DRCPDB (DBID=2809845299)
connected to auxiliary database: DRCPDB (not mounted)
RMAN>
Note that I am running this command from one of the standby nodes and I am able to connect to the auxiliary database using the connect string. The passwords for both the servers are the same.
RMAN> duplicate target database for standby from active database nofilenamecheck;
Starting Duplicate Db at 24-FEB-16
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=194 device type=DISK
contents of Memory Script:
{
backup as copy reuse
targetfile '+DATA/DRCPDB/PASSWORD/pwddrcpdb.256.903520275' auxiliary format
'+DATA/DRCSDB/PASSWORD/pwdrcsdb' ;
}
executing Memory Script
Starting backup at 24-FEB-16
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=28 instance=drcpdb1 device type=DISK
Finished backup at 24-FEB-16
contents of Memory Script:
{
sql clone "create spfile from memory";
shutdown clone immediate;
startup clone nomount;
restore clone from service 'drcpdb1' standby controlfile;
}
executing Memory Script
sql statement: create spfile from memory
Oracle instance shut down
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 02/24/2016 17:56:02
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-04006: error from auxiliary database: ORA-01017: invalid username/password; logon denied
RMAN>
Where I am going wrong? Any help will be very much appreciated. I have also noticed that the remote password works only if the database is started.
Thanks in advance
Shaji Chacko