## COPY PASSWORD FILE
-- as grid
export ORACLE_SID=+ASM1
asmcmd
pwcopy +DATA/PROD/orapwprod /home/grid/orapwprod
copying +DATA/PROD/orapwprod -> /home/grid/orapwprod
exit
-- as root, copy all files in /u01/backup
chown -R oracle.oinstall /u01/backup
## COPY WALLET
ASMCMD [+DATA/wallet/PROD/tde] > ls
cwallet.sso
ewallet.p12
ewallet_2025111920493958_KS_backup1.p12
ASMCMD [+DATA/wallet/PROD/tde] > cp +DATA/wallet/PROD/tde/* /home/grid
copying +DATA/wallet/PROD/tde/ewallet_2025111920493958_KS_backup1.p12 -> /home/grid/ewallet_2025111920493958_KS_backup1.p12
copying +DATA/wallet/PROD/tde/ewallet.p12 -> /home/grid/ewallet.p12
copying +DATA/wallet/PROD/tde/cwallet.sso -> /home/grid/cwallet.sso
[grid(PROD1)@s1t3dbm01 ~]$ scp orapwprod ewallet_2025111920493958_KS_backup1.p12 ewallet.p12 cwallet.sso grid@s2t3dbm01:/home/grid
orapwprod 100% 4096 3.4MB/s 00:00
ewallet_2025111920493958_KS_backup1.p12 100% 3584 6.7MB/s 00:00
ewallet.p12 100% 6656 11.7MB/s 00:00
cwallet.sso 100% 6656 12.2MB/s 00:00
-- on secondary site
ASMCMD> mkdir +DATA/wallet +DATA/wallet/PROD_STBY +DATA/wallet/PROD_STBY/tde
ASMCMD> cp /home/grid/*wallet* +DATA/wallet/PROD_STBY/tde
copying /home/grid/cwallet.sso -> +DATA/wallet/PROD_STBY/tde/cwallet.sso
copying /home/grid/ewallet.p12 -> +DATA/wallet/PROD_STBY/tde/ewallet.p12
copying /home/grid/ewallet_2025061707384472_KS_backup1.p12 -> +DATA/wallet/PROD_STBY/tde/ewallet_2025061707384472_KS_backup1.p12
##DRS
ASMCMD [+] > pwcopy --dbuniquename PROD_STBY /home/grid/orapwprod +DATA/PROD_STBY/orapwprod -f
copying /home/grid/orapwprod -> +DATA/PROD_STBY/orapwprod
SQL> startup nomount pfile='/home/oracle/PROD_stby.ora'
[oracle(PROD)@s1t3dbm01 ~]$ export ORACLE_SID=PROD1
[oracle(PROD)@s1t3dbm01 ~]$ rman target / auxiliary sys@PROD_STBY
Recovery Manager: Release 19.0.0.0.0 - Production on Thu Jan 22 11:22:51 2026
Version 19.29.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: PROD (DBID=629345110)
auxiliary database Password:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04006: error from auxiliary database: ORA-12528: TNS:listener: all appropriate instances are blocking new connections
-- create static entry in LISTENER
[grid(-DRS-)@s2t3dbm01 admin]$ cat listener.ora
#Backup file is /oracle/oraBase/crsdata/s2t3dbm01/output/listener.ora.bak.s2t3dbm01.grid line added by Agent
# listener.ora Network Configuration File: /oracle/19c/grid/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = s2t3dbm01.t2.pne.local)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
SID_LIST_LISTENER =
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME = PROD)
(ORACLE_HOME = /oracle/19c/database)
(SID_NAME = PROD)
)
)
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
VALID_NODE_CHECKING_REGISTRATION_LISTENER=ON # line added by Agent
-- or just with UR=A option in "/oracle/19c/database/network/admin/tnsnames.ora" on primary
PROD_STBY=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = s2t3dbm01)(PORT = 1521))
)
(CONNECT_DATA = (SERVICE_NAME = PROD_STBY) (UR = A )
)
)
[oracle(PROD)@s1t3dbm01 ~]$ rman target sys/"PnE+2025-Ecd"@PROD auxiliary sys/"PnE+2025-Ecd"@PROD_STBY
Recovery Manager: Release 19.0.0.0.0 - Production on Thu Jan 22 12:05:08 2026
Version 19.29.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: PROD (DBID=629345110)
connected to auxiliary database: PROD (not mounted)
RMAN> duplicate target database for standby from active database dorecover;