Technical Information
 
High Availability Disaster Recovery Backup & Recovery
Data Storage OracleWorld  
     
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"
TOP
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
TOP 
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.
TOP
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.
TOP
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.
TOP
   
E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy