Oracel 9i Physical Standby Database setup HELP !
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Oracel 9i Physical Standby Database setup HELP !

  1. #1
    Join Date
    Jul 2004
    Posts
    6

    Question 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.

  2. #2
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    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)))

  3. #3
    Join Date
    Jul 2006
    Posts
    1

    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)

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    Quote 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

  5. #5
    Join Date
    Jul 2004
    Posts
    6
    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

  6. #6
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    change syansbt archive destination in init.ora in PRIServ

    log_archive_dest_2='SERVICE=TX1 reopen=60'

  7. #7
    Join Date
    Jul 2004
    Posts
    6
    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

  8. #8
    Join Date
    Jul 2004
    Posts
    6
    Quote 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??

  9. #9
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    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
  •  



Click Here to Expand Forum to Full Width