Migrate a 1TB Datawarehouse in 20 Minutes

“Migrate a 1TB Datawarehouse in 20 Minutes” video series, Andrew Holdsworth, Senior Director of Oracle’s Real World Performance (RWP) team, shows the most efficient method for loading 1TB of data into an Oracle Exadata Database Machine.



Enhancing Oracle Database Protection With EMC RecoverPoint

This paper explains the benefits of using EMC RecoverPoint local and remote replication to provide operation and disaster recovery of Oracle environments.

RecoverPoint provides crash-consistent and application-consistent recovery points that can be utilized in response to a number of possible scenarios, enhancing the native availability within an Oracle environment. Oracle support third-party enterprise replication techologies to protect Oracle environments.

EM RecoverPoint provides full support for data replication and disaster recovery when working with Oracle Databases. RecoverPoint supports Oracle whether the Oracle databases are stored as raw disks or on a file system.

Click link below


“RecoverPoint EMC”


Leveraging DS8000 Series Advanced Copy Services for Oracle User-Managed Backup and Recovery

This white paper documents the use of IBM® System Storage™ DS8000™ Series Advanced Copy Services for backing up and recovering Oracle Real Application Clusters 10g (RAC) databases using Oracle Automatic Storage Management (ASM). Both Oracle RAC and ASM technologies introduce some differences with regard to Oracle Backup and Recovery when using IBM FlashCopy® technologies, as compared to single-instance, filesystem-based Oracle configurations. Deploying DS8000 Advanced Copy Services can be highly effective in any production shop that runs Oracle RAC 10g databases on ASM.

This white paper shows the robustness, speed, and ease with which you can backup, restore and recover databases, no matter their size.
The procedures are based on an Oracle User Group white paper that is titled Backup and Recovery Generic Guidelines with Point-in-Time Copy Solutions and Automatic Storage Management (located at: http://ioug.itconvergence.com/pls/apex/CILOUG.download_my_file?p_file=403).
This white paper demonstrates the use of Advanced Copy Services FlashCopy and Metro Mirror to do the following:

• Backup and restore an Oracle RAC database with Oracle Database 10g ASM
• Clone an Oracle RAC database with Oracle ASM to a local Oracle RAC
• Clone an Oracle RAC database with Oracle ASM to a remote DS8000 and Oracle RAC
• Backup and recover the Oracle RAC cluster services information

For demonstration purposes, 4-node Oracle RAC clusters were used. The process was repeated on the Linux and AIX® operating systems to demonstrate the operating-system (OS)-independence of the procedures. On all of the test beds, Oracle Clusterware, ASM and database binaries were installed in separate local directories. On the DS8000, volumes were allocated for the Oracle Cluster Registry, voting disks and the ASM diskgroups. The volumes were created by using a consistent naming convention for understanding the relationships between DS8000 volumes, DS8000 copy relationships and the ASM diskgroups. One DS8000 volume was allocated for each Oracle RAC cluster to serve as the mountable backup disk. Consistent naming allows the user to know at a glance what portion of the database is being acted upon in the backup and recovery scenarios.

Click on link below:

Ora DB RAC ASM Bkup Recovery using DS8k Adv Copy Services


EMC CLARiiON: Oracle Database 10g/11g/11gR2 with Storage Replication Consistency


This white paper is intended of database and system administrators interested in implementing backup and remote disaster protection plan on Linux and Windows Plataform for Oracle databases using the consistenty features of EMC CLARiiON SnapView nad MirrorView/S. The reader should be familiar with Oracle Database software and ASM and EMC CLARiion SnapView and MirrorView replication  technologies.

Click link below…



Deploying Oracle Database 11g Release 2 on EMC Unified Storage


This white paper is intended to help users of Oracle udersand the deployment gidlines and considerations of Oracle Database 11g Release 2 on x86_64 and x86-based Linux servers in envornments with EMC unified storage. Based on enginnering testing done at EMC Labs, this paper covers the important deployment not intended to cover every feature of Oracle Database Release 2. For Specific features not cover in this white paper please refer to the appropriate Oracle Database 11g Release 2 documentation.

See link below..




Oracle 10g R2 with Automatic Storage Management and IBM System Storage FlashCopy Backup and Recovery Procedures

The purpose of this white paper is to document the procedures necessary for an end-to-end backup andrecovery solution of an Oracle 10g R2 database according to these criteria:

1. The database implements disk sharing using Automatic Storage Management (ASM).

2. The FlashCopy capability of the IBM System Storage DS6000™ or DS8000™ is utilized to makea point-in-time copy of the production database volumes.

3. The combination of Oracle Recovery Manager (RMAN) and IBM Tivoli® Storage Managerproducts implement the backup and recovery of the database.

a.Full backups will be made to tape without shutting down the Production database.

b. The Archive Logs will be backed up as well as the datafiles.

c. Backups can be made whenever a new Archive Log is created or as frequent as databaseactivity dictates.

4. The Database point-in-time recovery (DBPITR) will be performed from tape, back to theProduction server.

NOTE: Some of the configuration details in this document may not be well suited for other scenarios suchas point-in-time restore from the FlashCopy.

The general outline of this document is as follows:

1. Install the software: AIX®, Oracle Database, IBM Tivoli Storage Manager Server, Data Protection for Oracle, Backup-Archive Clients and the DS6800 command line interface (dscli).

2. Create and Configure the database.3. Configure TSM.

4. FlashCopy the volumes and backup the database. This step is performed on a regular basis (eg.daily).

5. Recover the database.

Steps 1-3 will be summarized, while steps 4 and 5 will be documented in detail.

Throughout this document, the IBM Tivoli Storage Manager for Databases: Data Protection for Oracleproduct will be referred to as Data Protection for Oracle.

The IBM Tivoli Storage Manager Backup-Archive Client for AIX will be referred to as the BA Client.

Click link below…



Best Practices for Running Oracle RAC Database with ASM on IBM DS4800 Storage Subsystems

Owning state-of-the-art storage subsystems is not enough to excel in today’s competitive business climate.

Even with the best storage subsystems, the continuous demands upon the IT environment can create challenges:

• Unused capacity on expensive equipment becomes a financial waste.

• Continuous hardware and software sprawl create an ever-changing environment that constantly must be re-tuned to adjust to new conditions.

• New equipment is hot-added when possible, often resulting in a convoluted configuration that makes tuning for high performance complex and difficult to manage.

The purpose of this document is to detail optimum performance settings for IBM® DS4800  storage subsystems with the Oracle® Database application.

This document identifies parameters for optimizing a high-performance storage subsystem. For each parameter, this document explains how to monitor, evaluate, adjust, and confirm that the adjustment was appropriate and positive.

The process of keeping the parameters tuned involves the following tasks:• Identify the relevant parameters. • Take a baseline to determine the benchmark value for each relevant parameter.

• Continuously monitor each parameter on an ongoing basis. Only continuous monitoring can isolate the triggers that impact performance. Also, continue monitoring after any adjustment so that the effectiveness of the adjustment can be evaluated.

• Adjust parameters while the system remains in production.

• Watch how adjustments in one parameter are affecting other parameters.

Click link below..