Home » Server Options » Data Guard » dat guard
dat guard [message #393268] Sat, 21 March 2009 01:01 Go to next message
Messages: 6
Registered: November 2007
Junior Member
hai every body
pl can i know the step by step procedure to implement physical standby in windows environment

we are using windows 2003 and oracle 10.2.0


hyderabad, india
Re: dat guard [message #393274 is a reply to message #393268] Sat, 21 March 2009 01:14 Go to previous messageGo to next message
Michel Cadot
Messages: 65143
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It's all in the documentation: http://www.oracle.com/pls/db102/portal.portal_db?selected=3#index-DAT
Do you want us to copy and paste it?


[Updated on: Sat, 21 March 2009 01:15]

Report message to a moderator

Re: dat guard [message #393404 is a reply to message #393268] Sun, 22 March 2009 10:30 Go to previous message
Messages: 14
Registered: March 2009
Location: Austria
Junior Member

i had a real fight with Windows when setting up a test data guard. Normally i use Unix, and it works perfect. Oracle is princpelly not for Windows.

Basically, the Setup Guide in Oracle® Data Guard
Concepts and Administration 10g Release 2 (10.2) include all the necessary procedure.
BUT on Windows, you need to set up the following:

1. ORACLE Service:
oradim -new -sid ORCL -startmode manual -intpwd xxx

2. Create a password file if it doesn't exist.
$orapwd file=pwdPRIM.ora password=xxx force=y

Note: sys passwd on Primayr db MUST be the same as the sys passwd on Standby db, otherwise no Log Shipping is possible.

3. sometimes there might be problem with swapping, which lead to loging shipping problem (SGA_TARGET, and AGGREGATE_TARGET)

4. sometimes you need to use PC_NAME as Host_name in Listener.ora, instead of localhost or ip_addresse. i had to struggle with this

5. last but not least, sometimes you may have to switch OFF Windows Firewall to get Logshipping working.

hope these Notes will do you good.
Previous Topic: GET IP Address of client
Next Topic: Problem creating a logical standby DB
Goto Forum:

Current Time: Fri Aug 18 15:16:09 CDT 2017

Total time taken to generate the page: 0.32026 seconds