|
| Technical Information |
| |
|
|
| |
|
|
| High Availability |
|
PDF |
Oracle Database 11g 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 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. |
|
PDF |
Oracle Database 10g High Availability
In today's fast moving economy, IT
high availability infrastructure is very important to most of the
enterprises because companies cannot afford to have extended
downtime. This paper will examine the causes of downtime and look
at the technology available within the Oracle Database, with particular
emphasis on the new capabilities in the Oracle Database 10g
Release 2, that enable costly downtime avoidance and rapid recovery
from failures that can not be prevented. Click here for the
Oracle Database 10g Release 1 version of this paper. |
|
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 |
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 UDB: Focus on High Availability
Oracle Database 10g Release 2 comes
with an 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 10g Release 2, and IBM DB2 Universal
Database (DB2 UDB) version 8.2. Click here
for the Oracle9i and DB2v8.1 version of this paper. |
|
PDF |
Response to IBM's document: A Technical
discussion of High Availability and Crash Recovery
Customers and industry experts have
acknowledged that the Oracle9i Database is the best database for
high availability and data protection. This document is Oracle's
response to the misleading and inaccurate statements contained in IBM's
document: "A Technical Discussion of High Availability and Crash
Recovery" |
|
|
| Disaster Recovery |
|
PDF |
Technical White Paper - Oracle Data Guard 11g -
The Next Era in Data Protection and Availability
Oracle Data Guard 11g
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. |
|
PDF |
Data Sheet - Oracle Data Guard
Oracle Data Guard, an included feature of the Oracle database
Enterprise
Edition, is the disaster recovery (DR) solution for Oracle databases.
Data Guard operates by maintaining one or more standby databases as
synchronized copies of a production database. This data sheet provides
a quick glimpse into Data Guard's capabilities, demonstrating how Data
Guard offers excellent data protection and preserves high levels of
business continuity in the event of failures, disasters, errors, and
data corruptions. |
|
PDF |
Technical White Paper - Oracle Data Guard 10g
Release2:
Ensuring Disaster Recovery for the Enterprise
Oracle Data Guard is the most effective solution available today to
protect the core asset of any enterprise - its data, and make it
available on a 24x7 basis despite disasters and other outages. This
paper discusses Data Guard technology in Oracle Database 10g
Release 2, and demonstrates how it is a key factor in the business
continuity infrastructure of any enterprise. Click here for the Oracle
Database 10g Release 1 version of this paper. |
| |
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, inlcuding: Data Recovery Advisor, Recovery Manager
(RMAN), Flashback
Technologies, Logminer, and Oracle Secure Backup. |
|
PDF |
Oracle Recovery Manager 10g
Oracle's Recovery Manager (RMAN) continues
to mature with each new release and the revolutionary technological
advances included in Oracle Database 10g will provide the
simple, reliable, and automatic recovery tool that you have been
waiting for. This paper presents the new Oracle Database 10g
features that simplify the implementation and on-going maintenance of
your Oracle data protection strategy. |
|
PDF |
Oracle Recovery Manager 10g New Features
Overview
This paper summarizes the exciting new
RMAN capabilities in Oracle Database 10g, including proactive
management of disk backups with the flash recovery area, faster
incremental backups with block change tracking, and shorter restore
windows with incrementally updated backups, among many other new
features. |
|
PDF |
Oracle Recovery Manager 10g Release 2 New
Features Overview
This paper summarizes new RMAN
capabilities in Oracle Database 10g Release 2, including backup
encryption and unused block compression. |
|
PDF |
Oracle Recovery Manager: Performance Testing at
Sun Customer Benchmark Center
In today's demanding market,
downtime is not an option. Thus, developing a fast and reliable online
backup solution is one of the most important aspects of achieving high
availability.The goal of this paper is to prove that Oracle9i RMAN
provides superior performance. |
|
ZIP |
HP Enterprise Libraries Reach New Performance
Levels
The goal of these benchmarks was to
demonstrate that an online backup of an Oracle9i Release 2
(9.2.0.2) database could be accomplished using a single HP ESL Ultrium
460 Tape Library with 16 tape drives at a rate of over 3 TB/hr (actual
result 3.16 TB/hr including library load and unload time). A
corresponding restore rate of over 1 TB/hr (actual result 1.23 TB/hr
including library load and unload time) was also achieved. |
|
PDF |
Fast-Start: Quick Fault Recovery in Oracle
This paper highlights Fast-Start
Fault Recovery, an important availability feature in Oracle, designed
to expedite recovery from unplanned outages. Fast-Start allows the
administrator to configure a running system to impose predictable
bounds on the time required for crash recovery. |
|
PDF |
Tuning Oracle Recovery Manager
Backup and recovery is one of the
most important aspects of database administration. Whether companies
operate a single database or multiple databases that store hundreds of
gigabytes or even terabytes of data, they share a common factor: the
need for a fast and reliable backup solution. Oracle's Recovery Manager
(RMAN) utility provides this solution. |
|
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 |
RMAN and Media Manager Troubleshooting Guide
This paper presents an overview of
the RMAN environment and how it interacts with the media manager,
followed by common troubleshooting procedures when integrating and
working with 3rd party media managers. |
|
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. |
|
|
| Data Storage |
|
| |
|
Oracle Storage Compatibility
Program (OSCP)
Through OSCP technical and
marketing programs, members receive tools and resources they need to
build Oracle compatible storage solutions for Oracle customers.Click here to view the OSCP White Papers.
|
|
PDF |
Oracle File Mapping
Oracle File Mapping feature allows
a DBA to map Oracle files and database objects through the I/O layers
and down to the physical devices. This paper gives an overview of
the File Mapping feature, describing how it works, including a number
of mapping examples. |
|
PDF |
Oracle Disk Manager
ODM is a disk management interface defined
by Oracle to enhance file management and disk I/O performance. When
implemented in a file system or a logical volume manager, ODM provides
many benefits including simplified file administration, improved file
integrity, and reduced system overhead.. |
|
PDF |
Oracle Disk Manager Implementation
This technical white paper
discusses the ODM feature in depth and shows how users can enable the
ODM interface with the VERITAS ODM library |
|
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. |
|
PDF |
Optimal Storage Configuration Made Easy (SAME)
Storage configuration does not have
to be complicated. A simple, efficient, and highly available storage
configuration is possible. The basic idea of this configuration it to
make extensive use of striping across large sets of disk using a
methodology called S.A.M.E. Presentation |
|
PDF |
Configuring the Oracle Database with VERITAS
Software and EMC Storage for Optimal Scalability, Mangeability, and
Performance (using the SAME method)
The goal of this white paper is to
provide a list of recommendations that will allow customers to optimize
overall scalability, manageability, and performance. Oracle, EMC, and
VERITAS understand what customers are asking for as well as the
challenges faced in trying to meet their objectives. |
|
PDF |
SAME and the HP XP512
Our purpose was to evaluate SAME on
the HP XP512 Storage Array. We wanted to test the notion that the
separation of the log files and datafiles would provide significant
performance improvement in the SAME environment |
|
PDF |
How to Avoid Fragmentation
Fragmentation is an issue of great
concern to database administrators. Oracle has a multitude of commands,
options, views, and statistics that address various aspects of
fragmentation, but it is not obvious how these capabilities should be
used on a day-to-day basis. |
|
PDF |
Hierarchical Storage Management
There is a class of storage
subsystem, referred to as HSM, this is commonly used in today's large
enterprise. This paper describes several strategies that allow users to
successfully use Oracle with HSM nearline storage technology. |
|
PDF |
Achieving Mainframe-Class Performance on Intel
Servers Using InfiniBand Building Blocks
Recent tests by Oracle and Dell, in
association with Topspin and Mellanox, demonstrate that InfiniBand
provides a two to four times performance improvement for Oracle9i Real
Application Clusters. Even better performance is expected as the
number of nodes is scaled up. |
|
|
| 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. |
|
|
|
|
Bookmark
