| High Availability |
| PDF |
The
High Availability Database Server Cookbook
This paper examines the many features Oracle provides
to increase database availability, and will examine the tradeoffs of different
approaches to availability. |
| PDF |
Oracle9i
LogMiner
Oracle LogMiner is the only Oracle-endorsed method of
accessing the redo stream. LogMiner allows relational access to Oracle's
redo stream through the v$logmnr_contents view. A list of recently archived
and online redo logs can be obtained from database control files. |
| PDF |
Oracle9i
LogMiner Features Overview
LogMiner provides you with extensive auditing capabilities,
without introducing any of the overheads normally associated with auditing
large systems. If your audits show that erroneous changes were made to enterprise
data, LogMiner gives you the ability to undo those changes. |
| PDF |
Oracle9i
Flashback Query
Oracle9i introduces Flashback Query to provide a simple,
powerful and completely non-disruptive mechanism for recovering from human
errors. It allows users to view the state of data at a point in time in
the past without requiring any structural changes to the database. |
|
|
|
| Disaster
Recovery |
| PDF |
Oracle
Data Guard Technical Whitepaper
This technical
white paper discusses the architecture, technology, and key features of
Oracle Data Guard in Oracle9i Database Rel 2. |
| PDF |
Oracle
Data Guard Technology Overview
This presentation provides a technology overview of Oracle Data Guard in
Oracle 9i Database Rel 2, outlining its architecture, differentiation
from similar products and key features, all of which contribute to make
Oracle Data Guard the most effective solution available today for enterprise
data protection and disaster recovery. |
|
|
|
| Backup & Recovery |
| PDF |
Oracle9i Recovery Manager Features
Overview
Database backup, restore, and recovery are critical
processes underlying any mission-critical system. Oracle9i Recovery Manager (RMAN)
features enhance database availability and manageability by providing the
capability to recover corrupted database blocks while the datafile remains
online, create persistent backup/restore configurations which provides consistent
operation behavior, and automatic control file backup and restore to protect
against disaster. |
| PDF |
Recovery
Manager Quick Reference
Recovery Manager (RMAN) is an Oracle utility that can
back up, restore, and recover database files. This Quick Reference shows
the basic uses and syntax for RMAN. |
| 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. |
| PDF |
HP Enterprise Libraries Reach New Performance
Levels
The goal of these benchmarks is 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 |
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 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 Oracle9i
This paper offers best practices for using RMAN to setup and backup standby databases managed by Data Guard. RMAN brings rich functionality such as online backups, incremental backups, block media recovery, automation of backup management tasks, and integration with 3rd party tape management systems into the Data Guard environment. Backups can be offloaded to the standby database, making more efficient use of resources on the primary system; backups from either database can be used for recovery. |
| 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. |
|
|
|
| Data
Storage |
|
| 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 |
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. Click here for 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 |
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. |
| PDF |
Oracle9i
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. Oracle9i
further extends Oracle's online capabilities with new features allowing
database administrators to perform not only data reorganization online but
also data redefinition online. |
| PDF |
Oracle8i
and Oracle9i Data Reorganization and Feature Comparisons
This paper provides a comparison of the Oracle8i and
Oracle9i data reorganization features.
|
|
|
|
Bookmark
