Version: 11.2.0.3
Platfomrm : Solaris 10
We are going to create a physical standby DB for our primary DB using RMAN Duplicate.
Our primary DB details
DB_NAME = ADPTGMS
DB_UNIQUE_NAME = ADPTGMS
Planned names for standby
DB_NAME = ADPTGMS
DB_UNIQUE_NAME = ADPTGMSDG
Question1.
At the standby side, before I run the RMAN Duplicate, I need to startup the empty instance in NOMOUNT state. Right ? Should I set export ORACLE_SID to DB_NAME or DB_UNIQUE_NAME ?
Question2.
I gather that it is a pre-requisite to have the listener up in standby side to do the RMAN Duplicate (otherwise how will RMAN connect to the dummy instance in the standy side )
At standby side , there is no DB running yet. But for the RMAN to connect to the dummy Instance, I've configured and started a listener as shown below. Is this fine ?
$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER_DG =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.80.16.179)(PORT = 1524 ))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2012))
)
)
$
$
$
$ lsnrctl start LISTENER_DG
LSNRCTL for Solaris: Version 11.2.0.3.0 - Production on 20-DEC-2012 00:14:19
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...
TNSLSNR for Solaris: Version 11.2.0.3.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/tigris179/listener_dg/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.80.16.179)(PORT=1524)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC2012)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.80.16.179)(PORT=1524)))
STATUS of the LISTENER
------------------------
Alias LISTENER_DG
Version TNSLSNR for Solaris: Version 11.2.0.3.0 - Production
Start Date 20-DEC-2012 00:14:24
Uptime 0 days 0 hr. 0 min. 3 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/tigris179/listener_dg/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.80.16.179)(PORT=1524)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC2012)))
The listener supports no services
The command completed successfully