Home » Server Options » Data Guard » Question about Note:387261.1 - MAA - Creating a RAC Logical Standby for a RAC Primary 10gr2 (Oracle 10g)
Question about Note:387261.1 - MAA - Creating a RAC Logical Standby for a RAC Primary 10gr2 [message #350999] Sun, 28 September 2008 21:05 Go to next message
bad kuk
Messages: 6
Registered: December 2002
Junior Member
Hello All,

Is there a similar note for Windows? i am trying to set up dataguard on a rac system, using 10g + windows 2003 + OCFS. i'm stuck on this portion:

**************************
8. After setting up the appropriate environment variables on each standby host, such as ORACLE_SID, ORACLE_HOME, and PATH, start the standby database instance on the standby host that has the staging directoryalter , without mounting the control file.

SQL> STARTUP NOMOUNT
**************************

What would the equivalent of this in Windows terms? Should i be running oradim for this?


Worst comes to worse...would the manual physical standby creation work for RAC as well?


tia

Re: Question about Note:387261.1 - MAA - Creating a RAC Logical Standby for a RAC Primary 10gr2 [message #351001 is a reply to message #350999] Sun, 28 September 2008 21:08 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You'll have to create a Window's Oracle service with oradim and you'll need to set the appropriate environment variables with the set command.
Re: Question about Note:387261.1 - MAA - Creating a RAC Logical Standby for a RAC Primary 10gr2 [message #351209 is a reply to message #350999] Mon, 29 September 2008 20:56 Go to previous messageGo to next message
bad kuk
Messages: 6
Registered: December 2002
Junior Member


Yup, that's what i did; i created a new init.ora for the standby based on the primary's, then added the dataguard parameters...however i keep getting "listener does now know of service" and "could not hand off connection" errors when trying to connect via sqlplus.


Below is my listener.ora(btw, i failed to mention that the primary and standby are on the same rac cluster)



*******************************************************************
LISTENER_1=
(DESCRIPTION_LIST=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=w.x.y.z)(PORT=1521))
)
)
)

SID_LIST_LISTENER_STANDBY=
(SID_LIST=
(SID_DESC=
(SID_NAME=PLSextProc)
(ORACLE_HOME=c:\oracle\product\10.2.0\db_1)
(PROGRAM=extproc)
)
(SID_DESC=
(ORACLE_HOME=c:\oracle\product\10.2.0\db_1)
(SID_NAME=PRIMARY)
)

(SID_DESC=
(ORACLE_HOME=c:\oracle\product\10.2.0\db_1)
(SID_NAME=STANDBY)
)
)

*******************************************************************
Re: Question about Note:387261.1 - MAA - Creating a RAC Logical Standby for a RAC Primary 10gr2 [message #351309 is a reply to message #351209] Tue, 30 September 2008 04:59 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Your listener.ora file doesn't appear to be correct. You've got LISTENER_1 yet have the sid list as SID_LIST_LISTENER_STANDBY. Did you use the same format as your primary RAC listener file ?
Previous Topic: Standby Problem in 9i
Next Topic: Standby is not caught up
Goto Forum:
  


Current Time: Thu Mar 28 18:32:01 CDT 2024