<div>
I agree that your question seems to be a little vague.<br />
<br />
Are you after High-Availability, Disaster Recovery, or something else?<br />
<br />
To add to RAC there is also Data Guard and Replication options.
</div>


<div>
<div class="content wysiwyg-content">
Dear all,<br />
<br />
Kindly,<br />
<br />
What is the Advantages/disadvantages of having different oracle Instances or &nbsp;have oracle instances with the same name on different servers and all is from &nbsp;Single database (master) to multi cluster.<br />
<br />
If the master database stop do that impact the instance or cluster one? if the server where master database is stop do that mean all instance will be stop or no impact in the instance database?<br />
<br />
Do any changes in the master database in any tables structure will be migrate to other?<br />
<br />
Are data entered will be store in the master and instances? <br />
<br />
Can we make any changes in the instance in the table structure or this only done in the master?<br />
<br />
<br />
Regarads
</div>
</div>


Dear all,

Kindly,

What is the Advantages/disadvantages of having different oracle Instances or  have oracle instances with the same name on different servers and all is from  Single database (master) to multi cluster.

If the master database stop do that impact the instance or cluster one? if the server where master database is stop do that mean all instance will be stop or no impact in the instance database?

Do any changes in the master database in any tables structure will be migrate to other?

Are data entered will be store in the master and instances? 

Can we make any changes in the instance in the table structure or this only done in the master?


Regarads

I agree that your question seems to be a little vague.

Are you after High-Availability, Disaster Recovery, or something else?

To add to RAC there is also Data Guard and Replication options.

Oracle Instance

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.