Configuration of SQL*NET
Step 1: Configuration of TNSNAMES.ORA
/Oracle/11G/network/admin/tnsnames.ora in the Primary DB
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
ERPPRM = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = adb)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = erpprm) ) ) |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
ERPSBY = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = sdb)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = erpsby) ) ) |
Copy the file to StandbyDB
|
1 |
scp /Oracle/11G/network/admin/tnsnames.ora sdb:/Oracle/11G/network/admin/ |
Step 2: Configuration of LISTENER.ORA
In the Standby DB
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = sdb.sysdba.org)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) ) |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
ADR_BASE_LISTENER = /Oracle SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = erpsby) (ORACLE_HOME = /Oracle/11G) (SID_NAME = erp) ) ) |
|
1 2 3 |
lsnrctl reload lsnrctl start |
Preparation of standby database
Step 1:
The standby database should be set up in the same way as a regular Oracle database structure (should use the same directories as the primary database).
The DBMS application should be set up before creating the database (this can be done by selecting “software only” during setup, after which create a listener using netca.)
Step 2:
Configure the /home/oracle/.bash_profile file with the below parameter in server.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
ORACLE_HOSTNAME=sdb.sysdba.org; export ORACLE_HOSTNAME ORACLE_UNIQNAME=erp_sby; export ORACLE_UNIQNAME ORACLE_BASE=/Oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/11G; export ORACLE_HOME ORACLE_SID=erp; export ORACLE_SID PATH=$ORACLE_HOME/bin:$PATH; export PATH PATH=/usr/sbin:$PATH; export PATH |
Step 3:
Create /Oracle/11G/dbs/initerp.ora in the Standby DB using vi.
Finding out its path using select name from v$controlfile
|
1 2 3 |
DB_NAME=ERP CONTROL_FILES=’/Oracle/oradata/erp/control01.ctl’,’ /Oracle/fast_recovery_area/erp/control02.ctl’ |
Step 4:
Make the directories in the Standby DB.
|
1 2 3 4 5 6 7 |
mkdir -p /Oracle/fast_recovery_area/erp mkdir -p /Oracle/admin/erp/adump mkdir -p /Oracle/oradata/erp mkdir -p /Oracle/ArcLog |
<<Configuration of primary database Creation of standby database>>
Using RMAN for...
12 March 2019