What
is Oracle
Data Guard?
We have experience in installing Oracle
Data Guard which is a product available
from Oracle in the Enterprise edition of
the
database. This product enables 99.9% uptime
through seamless failover to a standby site
in the event of failure of the primary site.
In the instance of CAAZ the primary site
would be J.M. Nkomo Airport and the standby
site would be Charles Prince Airport. This
can
be achieved with minimal human intervention.
The diagram below shows our proposed implementation
of Oracle data Guard.
Data Guard helps to safeguard your precious
database from any kind of corruptions, disasters,
errors and failures. It not only
manages but also provides an automation
software infrastructure to create, monitor
and maintain enterprise standby databases
as
synchronized copies from the production
database that may be located at a remote
location. Data guard would help to prevent
any kind
of data loss if your production database
is corrupted or destroyed due to any unforeseen
reason.
Data Guard is designed with such features
that it would not let the corruptions
to propagate to the stored standby database
in Data
Guard storage from your primary database.
You can also use your standby databases
for production purposes. Various advantages
of Data
Guard include its:
• Capability to deal with quick switching
between primary databases and standby
databases. This helps to minimize the
downtime
you would have wasted when primary database
fails to perform.
• Resolve problems like user errors
or logical corruptions in primary database.
The redo data is always validated before
it is
applied to the standby database to ensure
more security.
• The workload of primary database
can also be reduced as all the functions
that require read only feature can utilize
standby
database.
Many people are confused what would happen
if the network connection disconnects for
sometime between the primary and standby
database. Now you need not to worry as all
the redo data that was not sent during the
disconnection phase is detected and updated
by
the Data Guard automatically. No manual
intervention or support is required in this
case. With its simple and centralized management
framework or design you can easily monitor
and manage various tasks of multiple databases
once, you configure your Data Guard for
the
same.
|
