-
Hello Guys,
Can anyone of you tell me the difference between CLONING and REPLICATION? And would appreciate if you guys can help me finding more information on CLONING.
Thanks in advance
-
Cloning is an operation where you manually take a copy of the database and move it to another location. The two databases do not stay in sync via automatic methods.
Replication involves setting up two databases that are automatically kept in sync by Oracle. When a change is made in one database, it is automatically reflected in the other database. Replication is typically used in HA environments or distributed environments.
Jeff Hunter
-
You might find the following tech note on Replication Design Setup Tips to be helpful if you plan to setup Advanced Replication:
http://www.dotcomsolutionsinc.net/su...on_design.html
The following replication setup scripts could also give you a good outline to work with for your installation as well:
http://www.dotcomsolutionsinc.net/pr...gen_files.html
Another high-availability option which you may want to consider is the setup of a standby database. A standby database does not provide instant failover capability like a replicated database installation. The standby instance needs to apply the remaining archivelog files then be brought out of recovery to become active.
David Simpson
http://www.dotcomsolutionsinc.net
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|