Dear Experts,
Primary DB status is opened but RMAN shows database is not mounted.
Duplicate database
[oracle@replica ~]$ rman target sys/Orclcts12#$@CRMSDB auxiliary sys/Orclcts12#$@STBY_CRMSDB
Recovery Manager: Release 12.2.0.1.0 - Production on Sun Apr 18 22:04:13 2021
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
connected to target database: CRMS (not mounted)
connected to auxiliary database: CRMS (not mounted)
RMAN> duplicate target database for standby from active database nofilenamecheck;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 04/18/2021 22:12:44
RMAN-05501: aborting duplication of target database
RMAN-06217: not connected to auxiliary database with a net service name
TNSNAMES.ORA from Physical Standby Server
[oracle@replica ~]$ cd $ORACLE_HOME/network/admin
[oracle@replica admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/12.2.0/db_home/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
STBY_CRMSDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.157.7)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = stbycrms)
(UR=A)
)
)
CRMSDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.157.5)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = crms)
(UR=A)
)
)