Question: I want to be able to replicate from one production database to a
remote backup instance.
I have heard that I can use the IBM SAN Volume Controller (SVC) to
accomplish this.
What is SVC and how can I use SVC to
keep a remote database synchronized with my production database?
How do I use IBM SVC for Oracle data replication?
Answer: IBM SVC is an IBM storage
virtualization tool that uses replication services at the source
and destination servers. IBM SVC has a hardware component
called an engine, or SVC node, that contains 8GB of high-speed
RAM. Because the nodes must be installed in pairs, when you set up
an SVC system, you are essentially creating a high speed cluster.
You can use SVC to keep a remote backup database synchronized
with a production database using the SVC feature called Metro
Mirror. Metro Mirror provides a synchronous copy process.
When a host writes to the primary volume, confirmation of the write
is not received until the write has been completed on both the
primary node and the secondary node. This ensures that the
backup is always up to date with the primary node, in the event that
the primary node fails. The usage of Metro Mirror is
limited by the distance between sites, due to the large impact
latency and bandwidth between nodes has on performance.
You can also use SVC to keep a remote backup using the Global
Mirror feature. Global Mirror provides an asynchronous copy
process. When a host writes to the primary volume, it receives
confirmation of the I/O before the copy process to the backup is
completed. If the primary node fails, the application must
recover and apply any updates that were not committed to the
secondary node. If I/O operations are paused on the primary
node for a small length of time, the secondary node can become an
exact duplicate of the primary node. This feature is
comparable to a continuous backup process where the last few updates
are always missing. When you use SVC Global Mirror for
disaster recovery, you must always have a plan for handling the
missing updates.
Burleson Consulting provides complete IBM SVC replication
services.
 |
|
Get the Complete
Oracle SQL Tuning Information
The landmark book
"Advanced Oracle
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
buy it
for 30% off directly from the publisher.
|
