Solved

Replication vs Standby & Migration vs moving..?

Posted on 2006-07-08
4
605 Views
Last Modified: 2012-06-27

http://searchoracle.techtarget.com/originalContent/0,289142,sid41_gci905154,00.html?Exclusive=True

By searching through above link, i found this  question and answer :

Question:
I need to put a database on two servers, and I want them to be the same: If I change one of them, the second one should take this change, for example, adding columns, removing and whatever else....

Solution:
Brian Peasland: What you are asking to do is to replicate your database between two different servers. Oracle sells an additional product called Advanced Replication. With replication, you can set up one database to be the MASTER with all changes propagated to the other. You can even have two-way replication if you desire. But keep in mind that you will have to license the database and replication on both servers. This cost can add up quickly!

My questions are?

The above solution seems to be same as "STANDBY database".

Can anyone please clarify me the difference between standby and replication..?

Are DB replication and DB cloning concepts are same?

and as well as any difference between DB migration and DB moving, or both are  same.?
0
Comment
Question by:expertblr
4 Comments
 
LVL 25

Accepted Solution

by:
jrb1 earned 63 total points
ID: 17065125
1) standby vs replication

A standby database is not a live database.  It is a current copy that can be made live if your live database is lost for some reason.  This is mainly used in disaster planning.  Replication gives you two (or more) live databases than can be used at the some time (both for viewing or for updates).

2) db replication vs cloning

Cloning usually refers to making a copy of an existing database.  We often clone our production db to make a new test database.  This would be the first part of replication, but no updates are applied to the cloned databases, so they will quickly get out of sync.  That is the second part of replication--keeping the data in sync.

3) I've not heard of the term DB moving, but I would assume that it is the same as migration.  
0
 
LVL 19

Assisted Solution

by:actonwang
actonwang earned 62 total points
ID: 17065531
some notes:

I assume that we are talking just Oracle and same version and same platform. Otherwise it will get very complicated. Not easy to map out.

>>A standby database is not a live database.
    a logical standby database can be used for queries and reporting purpose other than disaster recoverying.

>>replication.
Replication uses distributed database technology to share data between multiple sites. It is different from districuted database where data only exists on one site whereas in replication, same data are located in multiple sites.

>> cloning
     You need to compare cloning with standby because you use first couple of steps used by standy database to clone a database but cloning will not set up archive log transfer or redo log transfer (for logic standby database). As jrb said, cloned database will go on its own way and not required to be synced with primary database.

>>DB migration and DB moving
    DB migration usually means transfer all objects from one db to another. Say MS SQL to Oracle.
    DB moving: no such term widely used as far as I know. IMHO, it might mean you move oracle data between different platforms. You might need to use data pump or stream to do it in oracle 9i/10g.

    all information can be achieved at oracle online documentation.

acton

0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: Swadhin
From the Oracle SQL Reference (http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm) we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

896 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now