Home » Server Options » Data Guard » Replica of DataBase (oracle, 10g, Xp Server)
Replica of DataBase [message #338803] Tue, 05 August 2008 23:53 Go to next message
myclassic
Messages: 136
Registered: December 2006
Location: Pakistan
Senior Member
Dear

I want to create a replica of my database. and I want it to be updated with active database.

I want to install Oracle10g database on two different machines and two different dbs and want both to be updated at the same time. one will be used by the users and other one will remain as back up. but both must be updated at the same time.

is this solution possible? if yes....... How?

take care.

Regards.

Report message to a moderator

Re: Replica of DataBase [message #338805 is a reply to message #338803] Tue, 05 August 2008 23:56 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member
Yes it is possible.

http://www.oracle.com/technology/deploy/availability/htdocs/DataGuardOverview.html

Report message to a moderator

Re: Replica of DataBase [message #338808 is a reply to message #338805] Wed, 06 August 2008 00:19 Go to previous messageGo to next message
myclassic
Messages: 136
Registered: December 2006
Location: Pakistan
Senior Member
Dear Sir

Data Gaurd concept is only available in 10g or higher version of oracle products.

is it possible in oracle9i........

and is there any other solution except Data Gaurd. because we will need licence of Data Gaurd also, in this case.

Is there any other concept of replica...... providing me the same as Data Gaurd.

Regards.

Report message to a moderator

Re: Replica of DataBase [message #338815 is a reply to message #338808] Wed, 06 August 2008 00:50 Go to previous messageGo to next message
myclassic
Messages: 136
Registered: December 2006
Location: Pakistan
Senior Member
myclassic wrote on Wed, 06 August 2008 00:19
Dear Sir

Data Gaurd concept is only available in 10g or higher version of oracle products.

is it possible in oracle9i........

and is there any other solution except Data Gaurd. because we will need licence of Data Gaurd also, in this case.

Is there any other concept of replica...... providing me the same as Data Gaurd.

Regards.




waiting for responce please

Report message to a moderator

Re: Replica of DataBase [message #338821 is a reply to message #338808] Wed, 06 August 2008 01:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
myclassic wrote on Wed, 06 August 2008 07:19
Dear Sir

Data Gaurd concept is only available in 10g or higher version of oracle products.

is it possible in oracle9i........

and is there any other solution except Data Gaurd. because we will need licence of Data Gaurd also, in this case.

Is there any other concept of replica...... providing me the same as Data Gaurd.

Regards.

In the topic header you said you are in 10g. Posting wrong information leads to inacurrate answers.

In addition, forum rules say you must give your version with 4 decimals. Don't you think there is no difference between 9.0 and 9.2?

Finally, standby database exists since version 7.

By the way, we don't owe you any answer so wait someone post an answer and don't complain about it, above all after 31 minutes.

Regards
Michel

Report message to a moderator

Re: Replica of DataBase [message #338831 is a reply to message #338821] Wed, 06 August 2008 01:23 Go to previous messageGo to next message
myclassic
Messages: 136
Registered: December 2006
Location: Pakistan
Senior Member
Dear Michle

Sorry if i annoyed you....... and sorry for bothering you again.

I have given information initially and rest of the queries emerged with the solution provided by Sir Taj.

I am not a DBA. but i need to provide some solution to my organisation that should be most easy to handle.

still if i have bothered you ......then I can just say Sorry.

regards.

Report message to a moderator

Re: Replica of DataBase [message #338850 is a reply to message #338831] Wed, 06 August 2008 02:06 Go to previous messageGo to next message
Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Still don't know your version but one answer may be standby database... if you fit the prerequisites.

Regards
Michel

Report message to a moderator

Re: Replica of DataBase [message #338854 is a reply to message #338850] Wed, 06 August 2008 02:14 Go to previous messageGo to next message
myclassic
Messages: 136
Registered: December 2006
Location: Pakistan
Senior Member
Michel Cadot wrote on Wed, 06 August 2008 02:06
Still don't know your version but one answer may be standby database... if you fit the prerequisites.

Regards
Michel



I have two Databases.
Oracle 9i .....version 9.2.0.4
Oracle 10g..... version 10.2.0.1.0


I may choose any one of them.
how to prepare a standby server that should be automatically updated with the primary database???
with out data gaurd option.

thanks for reply and regards

Report message to a moderator

Re: Replica of DataBase [message #338876 is a reply to message #338854] Wed, 06 August 2008 02:55 Go to previous message
Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Same version of Oracle in both server?
Same OS in both server?
...

Many questions to answer before ending to a solution.
Read 9i/10g documentation related to standby database: http://tahiti.oracle.com

Regards
Michel

Report message to a moderator

Previous Topic: Primary and Standby on 10.2.0.2 and 10.2.0.3
Next Topic: set time delay sending log file
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Aug 16 23:18:34 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.