Databases Reference
In-Depth Information
1.
Create a service called RMAN (it can be of any name) that can be on all the instances
of the cluster:
proltestdb01.oradb:/home/oradb # srvctl add service -d prodb -s RMAN -r "PRODB1,PRODB2"
-P BASIC -e SESSION -m BASIC -j LONG -B NONE
2.
Start that service:
proltestdb01.oradb:/home/oradb # srvctl start service -d prodb -s RMAN
3.
Confirm that the service is running on all the instances of the cluster:
proltestdb01.oradb:/home/oradb # srvctl status service -d prodb -s RMAN
Service RMAN is running on instance(s) PRODB1,PRODB2
4.
If the service is already created, confirm that it has the necessary properties:
proltestdb01.oradb:/home/oradb # srvctl config service -d prodb -s RMAN
Service name: RMAN
Service is enabled
Server pool: prodb_RMAN
Cardinality: 2
Disconnect: false
Service role: PRIMARY
Management policy: AUTOMATIC
DTP transaction: false
AQ HA notifications: false
Failover type: SESSION
Failover method: BASIC
TAF failover retries: 0
TAF failover delay: 0
Connection Load Balancing Goal: LONG
Runtime Load Balancing Goal: NONE
TAF policy specification: BASIC
Edition:
Preferred instances: PRODB1,PRODB2
Available instances:
The output shows “
Preferred instances: PRODB1,PRODB2
”, which is what I needed to see.
5.
Define a TNS alias that uses the SCAN names and the RMAN service to connect to the
database. In all the nodes of the database, put this entry in the TNSNAMES.ORA file:
RMAN=
(DESCRIPTION=
(ADDRESS = (PROTOCOL =TCP)(HOST = prodb01-scan.proligence.com)(PORT=1521))
(CONNECT_DATA =
(SERVER=DEDICATED)
(SERVICE_NAME=RMAN)
)
)
