OraFAQ Forum: Server Administration » How to Make two Databases Equal...Some body help me

Home » RDBMS Server » Server Administration » How to Make two Databases Equal...Some body help me

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to Make two Databases Equal...Some body help me [message #132657]

Mon, 15 August 2005 09:39

sponguru_dba
Messages: 51
Registered: May 2005
Location: Bangalore

Member

i have one application server called A1
this A1 connected to two DB servers D1,D2
each and every requist (data INSERT)going to both servers D1 and D2
but in case data SELECTION it will go and pick the Data from one of server D1, if D1 fails it will go to D2 and pick the Data
---above system is 24/7
in above case u assume that D1 fail(clash)

i can take backup HOT OR RMAN from D2 and restore in crashed one D1.
mean time because of it is 24/7 system for restoration of data take a some time,in this time some of requists(data INSERTS) will go to D2
so,that this will make data in both systems INEQUILENT

i want make data EQUILENT in both D1 and D2

please could you kindly some one help giving better solution for this problem

regards
Sreenivas

Report message to a moderator

Re: How to Make two Databases Equal...Some body help me [message #132662 is a reply to message #132657]

Mon, 15 August 2005 09:55

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Is this a coincidence?
you are posting the same question across alll over the web!.
--
An Oracle RAC is the most viable solution.
You no need to worry about single point failure.
Look into other options, if you cannot afford it.

>>every requist (data INSERT)going to both servers D1 and D2

Never heard of any such scheme. This should be very painful for the application.
What happens if you update/delete?

All you need standby database, where you copy the archived log to standylocation/server , apply those logs and build a standby database. The downtime is very minimal.

Anyhow to answer your question,
>> i want make data EQUILENT in both D1 and D2
Look into Streams.
Using streams, you can capture only the data that is changed and apply this data to the other database.
You need to do some customization here, which is NOT necessary if you would look into standby database/ RAC.

Other option is to make use of Materialized views to refresh data from one database to another. But anyhow there will be a downtime.

Report message to a moderator

Re: How to Make two Databases Equal...Some body help me [message #132749 is a reply to message #132662]

Mon, 15 August 2005 23:53

sponguru_dba
Messages: 51
Registered: May 2005
Location: Bangalore

Member

Thnakq Mahesh Rajendran

But Here already immplimented system whcih i can't distrub now,even in case of Standby databse,i have to take backup and restore in to target server(STAND BY) for this it will take time,in this mean time some INSERT,UPDATES,DELETES if happence in main DB, how can i get and restore data in target mechine DB

Thankq Very much you better idea and suggetion

I dn't know streems i will try for that

regards
SreenivasaRao

Report message to a moderator

Re: How to Make two Databases Equal...Some body help me [message #132820 is a reply to message #132749]

Tue, 16 August 2005 06:49

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

YOu will apply only the archived logs.
You no need to backup the whole database.
So the downtime is very minimal.
Any other suggested method also will have a minimal downtime ( except RAC)

Report message to a moderator

Re: How to Make two Databases Equal...Some body help me [message #132938 is a reply to message #132820]

Tue, 16 August 2005 22:47

vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad

Senior Member

Other simple way to accomplish this task will be ...make D2 to host only materialized views pointing to D1 ..and schedule a job to fast refresh the mat views in d2 on frequent basis (as per the requirement).

-Sai Jeedigunta

Report message to a moderator

Previous Topic:	Schema comparision---Info needed
Next Topic:	Creation date of table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 26 10:18:56 CST 2025