-
Oracel 9i Physical Standby Database setup HELP !
Hi All,
I need to set up a phsysical 9i standby database but I am confess the listener.ora and tnsname.ora setup in both primary and standby server.
Both database are the same SID (P08) but run on two physical server say PRIServ1 and SBYServ1 .
Can any one give me the entry I should put in both PRI and SBY server for listener and tnsname?
Thanks in advance.
-
You have to configure tnsnames.ora at production DB for your standby database
e.g.
listener on SBYServ1 :
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = ))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = )
)
)
TNSnames.ora on PRIServ1
P08 =(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=)))(CONNECT_DATA=(SID=P08)))
-
9i Physical Standby
You need to modify init.ora for the following parameters
lock_name_space
db_file_name_convert
log_file_name_convert
tnsname.ora
Primary1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.11.7)(PORT = 1521))
)
(CONNECT_DATA =
(service_Name = XXXXX)
)
)
Stdby2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.11.7)(PORT = 1521))
)
(CONNECT_DATA =
(service_Name = stdbydb)
)
)
listner.ora
LISTENER =
(SID_NAME = PRIMARYDB)
(ORACLE_HOME = /ORA_HOME)
(SID_NAME = STDBYDB)
(ORACLE_HOME = /ORA_HOME)
-
Originally Posted by kashish
You need to modify init.ora for the following parameters
lock_name_space
db_file_name_convert
log_file_name_convert
no you dont NEED to
-
Hi all,
I did modified the lisener and tnsname in both server as follow, also I can copy the archive log from PRI to SBY. BUT the SBY didn't applly any archive log by using managed recover . What I am doing wrong?
Here is the lisener, tnsname and init.ora for both database.
SBYSer1 - Listener.ora
ADMIN_RESTRICTIONS_LISTENER = on
LISTENER =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = TX1.WORLD)
)
(ADDRESS =
(PROTOCOL = IPC)
(KEY = extproc)
)
(ADDRESS=
(PROTOCOL = IPC)
(KEY = TX1)
)
(ADDRESS =
(PROTOCOL = IPC)
(KEY = TX1SBY.WORLD)
)
(ADDRESS=
(PROTOCOL = IPC)
(KEY = TX1SBY)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SDU = 32768)
(SID_NAME = TX1SBY)
(ORACLE_HOME = /oracle/TX1/920_64)
)
(SID_DESC =
(SDU = 32768)
(SID_NAME = TX1)
(ORACLE_HOME = /oracle/TX1/920_64)
)
(SID_DESC =
(SID_NAME = plsextproc)
(ORACLE_HOME = /oracle/TX1/920_64)
(PROGARM = extproc)
)
)
tnsname.ora
TX1.WORLD=
(DESCRIPTION =
(SDU = 32768)
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = SBYSer1)
(PORT = 1527)
)
)
(CONNECT_DATA =
(SID = TX1)
(GLOBAL_NAME = TX1.WORLD)
)
)
TX1SBY.WORLD=
(DESCRIPTION =
(SDU = 32768)
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = SBYSer1)
(PORT = 1527)
)
)
(CONNECT_DATA =
(SID = TX1)
(SERVICE_NAME = TX1SBY.WORLD)
(SERVER = DEDICATED)
)
)
PRIServ1.listener.ora
ADMIN_RESTRICTIONS_LISTENER = on
LISTENER =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = TX1.WORLD)
)
(ADDRESS=
(PROTOCOL = IPC)
(KEY = TX1)
)
(ADDRESS =
(PROTOCOL = TCP)
(HOST = PRIServ1)
(PORT = 1527)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SDU = 32768)
(SID_NAME = TX1)
(ORACLE_HOME = /oracle/TX1/920_64)
)
)
tnsname.ora
TX1.WORLD=
(DESCRIPTION =
(SDU = 32768)
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = PRIServ1)
(PORT = 1527)
)
)
(CONNECT_DATA =
(SID = TX1)
(GLOBAL_NAME = TX1.WORLD)
)
)
TX1SBY.WORLD=
(DESCRIPTION =
(SDU = 32768)
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = SBYSer1)
(PORT = 1527)
)
)
(CONNECT_DATA =
(SID = TX1)
(SERVICE_NAME = TX1SBY.WORLD)
(SERVER = DEDICATED)
)
)
init.ora in SBYServ1
*.log_archive_dest_1='location=/oracle/TX1/oraarch/TX1arch'
*.log_archive_dest_state_1=ENABLE
*.standby_archive_dest='/oracle/TX1/remotelog/TX1arch OPTIONAL'
*.remote_archive_enable=RECEIVE
init.ora in PRIServ
*.log_archive_dest_1='location=/oracle/TX1/oraarch/TX1arch MANDATORY'
*.log_archive_dest_2='location=/oracle/TX1/remotelog/TX1arch OPTIONAL '
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_start=true
*.remote_archive_enable='SEND'
The /oracle/TX1/remotelog/TX1arch is remote mounted on /oracle/TX1/remotelog/TX1arch
Thanks
-
change syansbt archive destination in init.ora in PRIServ
log_archive_dest_2='SERVICE=TX1 reopen=60'
-
I did try that but I find no archvie has been applied to the SBy databse
when I execulte the sql
select * from v$archived_log;
no rows selected
also in the SBY server I can't find any RFS service running
oratx1 27057 26877 0 11:26:29 ? 0:00 oracleTX1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oratx1 26877 25718 0 11:24:37 pts/0 0:00 sqlplus /nolog
oratx1 27044 1 0 11:26:28 ? 0:00 ora_dbw0_TX1
oratx1 27048 1 0 11:26:28 ? 0:00 ora_ckpt_TX1
oratx1 26904 26892 0 11:25:19 pts/1 0:00 -csh
oratx1 27046 1 0 11:26:28 ? 0:00 ora_lgwr_TX1
oratx1 27272 26904 0 11:48:34 pts/1 0:00 grep ora
oratx1 27271 26904 1 11:48:34 pts/1 0:00 ps -ef
oratx1 5490 1 0 Jul 18 ? 0:00 /oracle/TX1/920_64/bin/tnslsnr LISTENER -inherit
oratx1 25718 25706 0 09:28:33 pts/0 0:00 -csh
oratx1 27054 1 0 11:26:29 ? 0:00 ora_arc0_TX1
oratx1 27042 1 0 11:26:28 ? 0:00 ora_pmon_TX1
oratx1 27060 1 0 11:27:09 ? 0:00 ora_mrp0_TX1
oratx1 27052 1 0 11:26:29 ? 0:00 ora_reco_TX1
oratx1 27056 1 0 11:26:29 ? 0:00 ora_arc1_TX1
oratx1 27050 1 0 11:26:29 ? 0:00 ora_smon_TX1
Form the doc it looks like a RFS serveice is required but it is not in my system, How can I start this serverice up?
Please help
-
Originally Posted by bhattnirav
change syansbt archive destination in init.ora in PRIServ
log_archive_dest_2='SERVICE=TX1 reopen=60'
Should the service name be TX1SBY instead of TX1, it looks like it connect back to itself??
-
yes, it should be TX1SBY
after that query v$archive_Dest and check status of both archive destination on primary database. Both must be VALID.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|