Home » RDBMS Server » Performance Tuning » How to configure Oracle on Two Servers in Hot Redundant mode (Oracle 10g on Windows Server 2003)
How to configure Oracle on Two Servers in Hot Redundant mode [message #435758] Thu, 17 December 2009 15:47 Go to next message
myinvention99
Messages: 3
Registered: November 2009
Location: INDIA
Junior Member
Hi,
Can anyone explain step-by-step procedure to configure Oracle 10g on two servers to achieve hot redundancy.

I.e. One Server is master (let's say server-1. The other server is Hot Standby (let's say server-2). At any instant, Both databases should be equal. It means at any instant, any filed of any table in server-1 should be equal to server-2.

Whichever the Server (let's say server-1) is started first, it should go to master mode. After 30 Min, the other let's say server-2 is started. Then Server-2 should update its database till it becomes equal to database of server-1.

Similarly when server-2 is started first, server-2 should be master and server-1 should be hot standby.

How to confiure the Oracle 10g on both servers to achieve the above functionality ?

Report message to a moderator

Re: How to configure Oracle on Two Servers in Hot Redundant mode [message #435881 is a reply to message #435758] Fri, 18 December 2009 09:09 Go to previous message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
Perhaps you could take some time and actually read the "Standby Databases" section in the fine Oracle® Data Guard Concepts and Administration manual.
Shocked

Report message to a moderator

Previous Topic: sql tuning help
Next Topic: Problem in understanding the autotrace output exectution plan and statistics
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Feb 18 23:23:59 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.