|
|
 |
|
| Technical Information |
| |
|
|
| |
|
|
| High Availability |
|
PDF |
Oracle Database 11g Release 2 High Availability
Enterprises understand the critical
value in maintaining highly available technology infrastructures to
protect critical data and information systems. Building on decades of
innovation, Oracle Database 11g Release 2 introduces revolutionary new
availability and data protection technologies to provide customers with
new and more effective ways of maximizing their data and application
availability. Oracle’s comprehensive set of technologies provides
businesses unparalleled protection against any kind of outages – be it
due to a planned maintenance activity or an unexpected failure. Click here
for the
Oracle Database 11g Release 1 version of this whitepaper. Click here
for the
Oracle Database 10g Release 2 version of this whitepaper. |
|
PDF |
Database Rolling Patch Updates with Real
Application Clusters
In order to deliver continuous and
uninterrupted database service, Oracle is now providing technology to
perform maintenance of the database software without incurring any
database downtime. Database software patches can be applied to
Real Application Clusters systems with zero downtime. This new
technology is being offered in addition to High Availability, Online
Operations, Data Protection, Self Healing, Human Error Prevention, and
Disaster Prevention technology Oracle already provides. |
|
PDF |
Technical Comparison of Oracle Database vs. IBM
DB2: Focus on High Availability
Oracle Database 11g Release 1
comes with a comprehensive and integrated set of High Availability (HA)
capabilities that help organizations ensure business continuity by
minimizing the various kinds of downtime that can affect their
businesses. This paper provides an in-depth comparative assessment of
the HA capabilities available with Oracle Database 11g Release
1, and IBM DB2 version 9.5 for Linux, Unix and Windows. Click here
for the Oracle Database 10g vs. DB2v8.2 version of this paper.
Click here
for the Oracle9i vs. DB2v8.1 version of this paper. |
|
PDF |
Technical Comparison of Oracle Database vs.
Microsoft SQL Server 2008: Focus on High Availability
Oracle Database 11g Release 1
comes with a comprehensive and integrated set of High Availability (HA)
capabilities that help organizations ensure business continuity by
minimizing the various kinds of downtime that can affect their
businesses. This paper provides an in-depth comparative assessment of
the HA capabilities available with Oracle Database 11g Release
1, and Microsoft SQL Server 2008. Click here for a paper
focused on the Replication differentiators. |
|
|
| Disaster Recovery |
|
PDF |
Technical White Paper - Oracle Data Guard with
Oracle Database 11g Release 2
Oracle Data Guard 11g Release 2
redefines what users should expect from a
disaster recovery solution. It can address both High Availability and
Disaster Recovery requirements, and is the ideal complement to Oracle
Real Application Clusters (Oracle RAC). Data Guard has the requisite
knowledge of the Oracle database to reliably protect a standby database
from corruptions that attempt to propagate from a primary database. It
is straightforward to implement and manage. It also enables all standby
databases, both physical and logical, to be used for productive
purposes while in standby role. Click here
for the
Oracle Database 11g Release 1 version of this whitepaper. Click here
for the
Oracle Database 10g Release 2 version of this whitepaper. |
|
PDF |
Data Sheet - Oracle Active Data Guard 11g
Active Data Guard provides the management, monitoring, and automation
software to create and maintain one or more synchronized replicas
(standby databases) of a production database (primary database). An
Active Data Guard standby database is an exact copy of the primary that
is open read-only while it continuously applies changes transmitted by
the primary database. An active standby can offload ad-hoc queries,
reporting, and fast incremental backups from the primary database,
improving performance and scalability while preventing data loss or
downtime due to data corruptions, database and site failures, human
error, or natural disaster. |
| |
PDF |
The Right Choice for Disaster Recovery: Data
Guard, Stretch Clusters or Remote Mirroring
Various solutions are available today to
protect business-critical data, and enable enterprises to quickly
restore their business operations in the event of outages or disasters.
This paper discusses three such technologies - Oracle Data Guard in a
Maximum Availability Architecture (MAA) configuration (i.e. Data Guard
combined with Oracle Real Application Clusters (RAC)), Stretch Clusters
based on RAC, and Remote Mirroring. It describes their capabilities
using a DR solution assessment framework, and makes best practice
recommendations regarding their applicability to various business
situations. Presentation |
|
|
| Backup&Recovery |
|
PDF |
Technical White Paper: Oracle Database 11g
Data
Repair Technologies (Data Recovery Advisor, RMAN, Flashback,
Logminer, and Oracle Secure Backup)
Oracle Database 11g
provides all the tools needed to implement the most reliable, flexible,
performant, and cost-effective data recovery strategies in the face of
hardware or human mishaps. This technical white paper describes Oracle
Database 11g repair
technologies, including: Data Recovery Advisor, Recovery Manager
(RMAN), Flashback
Technologies, Logminer, and Oracle Secure Backup. Click here
for the Recovery Manager 10g
Release 2 New Features Overview. |
|
|
| OracleWorld |
|
|
Oracle World
There are many availability related
sessions at Oracle World every year, and the session papers and
presentations are available at the link below.
Oracle
World Technical Papers and Presentations. |
|
|
|
|
| Oracle Database 10g |
|
PDF |
Flashback Technology - Recovering from Human
Errors
According to many studies, 40% of
application outages are caused by operator or user errors. Part of
being human is making mistakes. But these errors are extremely
difficult to avoid and in can be particularly difficult to recover from
without advance planning and the right technology. This paper focuses
on the Oracle Database 10g architecture that leverages the
unique technological advances in the area of database recovery due to
human errors - Flashback Technology. |
|
PDF |
RMAN Backup and Recovery Optimization
This paper explains the factors
that affect the performance of backup, restore, and recovery
operations, and provides guidance on proactively monitoring and
improving performance. |
|
PDF |
Using Recovery Manager with Oracle Data Guard in
Oracle Database 10g
RMAN brings rich functionality such
as online backups, incremental backups, block media recovery,
automation of backup management tasks, and integration with 3rd party
media management systems into the Data Guard configuration. Since RMAN
and Data Guard are part of the integrated Oracle High Availability
technology stack, RMAN backups can be seamlessly offloaded to a
physical standby database, allowing customers to gain more value out of
their disaster recovery investment. This paper outlines RMAN procedures
to setup and backup physical standby databases managed by Data Guard in
an Oracle Database 10g environment. |
|
PDF |
Preventing, Detecting, and Repairing Data
Corruption
Oracle provides sophisticated
techniques for detecting most block corruptions and recovering from
them. These techniques include block-level recovery, automated backup
and recovery, tablespace point-in-time recovery, remote standby
databases, and transactional recovery. In addition, implementing
techniques to prevent data corruptions can save much time,
effort, and stress dealing with their possible consequences -- lost
data and downtime. This paper discusses the essential tools and
techniques for prevention, detection, and repair of block corruptions
in the Oracle database. |
|
PDF |
Best Practices for Cloning ASM-managed Databases
Cloning and refreshing databases
for development, testing, and reporting purposes is a common activity
for most DBAs. The methods used can range from third party tools to OS
or storage-level procedures, and can require additional licensing costs
as well as specialized expertise in hardware and storage technologies.
As DBAs know their data the best, DBAs should be fully empowered to
clone the database for their own needs. By utilizing Oracle's built-in
set of cloning tools, available in both command-line and GUI, DBAs can
do just that, with no additional software costs and full support from
Oracle. This paper presents three techniques for cloning ASM-managed
databases: RMAN DUPLICATE, the DBMS_FILE_TRANSFER package, and the
Enterprise Manager Clone Database feature. |
|
PDF |
Very Large Database (VLDB) Backup & Recovery
Best Practices
The dramatic rise in database
sizes imposes unique challenges for database administrators, who are
expected to protect large volumes of data in a timeframe that is ever
shrinking due to stringent service level requirements. This paper
outlines best practices for meeting the challenges associated with
backing up and recovering VLDBs to protect against media corruptions,
data failures, as well as human and application errors. A customer case
study is also included to illustrate a real-life design and
implementation of a VLDB backup and recovery strategy. |
|
PDF |
Oracle Database 10g Online Data
Reorganization and Redefinition
Online data reorganization, or the
ability to allow users full access to the database during a data
reorganization, improves the overall database availability and reduces
planned downtime. Oracle's online data reorganization capability also
allows users to redefine tables online. |
|
|
|
|
|
|
|
|
Bookmark
