Replication in Oracle 10G Express

DBA Geral (instalação, configuração do banco, scripts do Sql*Plus, shell scripts, batch scripts, etc...)
Post Reply
rsnaumann
Rank: Estagiário Sênior
Rank: Estagiário Sênior
Posts: 13
Joined: Thu, 30 Nov 2006 11:42 am
Location: São Paulo - SP

Hello everyone, good afternoon!

I would like to know if it is possible to replication of bases using Oracle 10G Express.

If possible I would like to know how.

Thanks!
cleberzumba
Rank: DBA Júnior
Rank: DBA Júnior
Posts: 223
Joined: Thu, 14 Dec 2006 10:45 am
Location: Brasília-DF
Cleber Zumba de Souza

It is possible yes, it does everything a normal bank does, just does not support many quantities of records, such as: many tablespaces, many datafiles and etc ....
santana.neto
Rank: Estagiário Júnior
Rank: Estagiário Júnior
Posts: 1
Joined: Fri, 16 Nov 2007 1:25 pm
Location: SP

Dear friend Kleber, it would be very good if you put an example script to further illustrate the forum ...

Thank you ...
elidias7
Rank: Analista Sênior
Rank: Analista Sênior
Posts: 153
Joined: Thu, 01 Nov 2007 2:53 pm
Location: Osasco
Eli Dias
Oracle Certified Professional

To facilitate you should inform the type of replication desired,
only goes or goes back

Hugs!
lucianof80
Rank: Estagiário Júnior
Rank: Estagiário Júnior
Posts: 1
Joined: Wed, 02 Jul 2008 6:27 pm
Location: São Paulo -SP

Good evening Eli
I need to make a replication (go and go back) from my bd
could you show me a model of how to do this?
And this replication served only for 2 servers or could it be on more servers?
I will try to explain my situation:
Today I have a laboratory system with several collection posts, where all they have to be online, but I did not see Internet, via intranet. But it happens that some posts to intranet lives falling, so I thought of putting a server at each post and every 5 minutes he would replicate and update what was changed on all servers.
Is it possible?

Grato
Luciano Fernandes
ruevers
Rank: DBA Sênior
Rank: DBA Sênior
Posts: 324
Joined: Fri, 02 Jun 2006 1:48 pm
Location: sp
Contact:

Even gives, this would be the part of Advanced Replication, but I doubt that this is possible in the XE, the standby part that is a replication of a way I already find it difficult.

should consult Oracle's documentation in the Advanced Replication part and see if in the XE is possible, unfortunately I have no example of this, especially in the XE.

If you want to try the Standby Database example I made a small step by step ... www.ruevers.webs.com/standby.htm
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 1 guest