Question about Note:387261.1 - MAA - Creating a RAC Logical Standby for a RAC Primary 10gr2 [message #350999] |
Sun, 28 September 2008 21:05 |
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 #351209 is a reply to message #350999] |
Mon, 29 September 2008 20:56 |
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)
)
)
*******************************************************************
|
|
|
|