Hi Experts,
I am trying to create a standby database using RMAN duplicate "active database" feature on 11.2 database and OS OEL 5.5
I am facing the below error while duplicating.
[oracle@uat ~]$ rman target sys/oracle@prim auxiliary sys/oracle@stby
Recovery Manager: Release 11.2.0.1.0 - Production on Sun Mar 11 18:22:38 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: prim (DBID=192228048)
connected to auxiliary database: prim (not mounted)
RMAN> duplicate target database for standby from active database nofilenamecheck;
Starting Duplicate Db at 11-MAR-12
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=26 device type=DISK
contents of Memory Script:
{
backup as copy reuse
targetfile '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwprim' auxiliary format
'/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwstby' ;
}
executing Memory Script
Starting backup at 11-MAR-12
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=46 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 03/11/2012 18:26:26
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 03/11/2012 18:26:26
ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-12154: TNS:could not resolve the connect identifier specified
ORA-17629: Cannot connect to the remote database server
RMAN>
I am able to tnsping successfully both the entries prim and stby from both the servers, also I am able to connect to the databases using the connection strings from each other server (primary database from standby server and standby database from primary server). Also, through RMAN I was able to connect to the primary database (target database) and auxilary database (standby database) but during the duplication process, it fails with the error ORA-12154: TNS:could not resolve the connect identifier specified
I have the below tns entries in the tnsnames.ora file on both primary and standby server. Please help me out.
STBY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.75.132)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = stby) (UR=A)
)
)
PRIM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.75.131)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = prim)
)
)