Technical Information
 
High Availability Disaster Recovery Backup & Recovery
OracleWorld Oracle Database 10g  
     
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.
TOP
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
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, 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.
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
   
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.
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