Infosys’ blog on industry solutions, trends, business process transformation and global implementation in Oracle.

« Establishing The Centroid Of Magic Triangle - Hitting the Bull's Eye of CMO Engagement | Main | Asset Management in Electricity Distribution Utility: "The Challenges of Getting Softer" »

BACKUP and RECOVERY in EXADATA

Guest post by
Vinayak Gangadhar Kurdekar, Technology Lead, Infosys

 

Businesses today need to increasingly leverage a unified platform to host all their database and applications at one place. To meet this challenge, Oracle has designed the Exadata server technology that bundles database and applications together to provide high performance, high availability, scalability and throughput. Mere implementation of the exadata server and its components is not enough. Disasters can strike at anytime. To ensure survivability and safeguard against any major disasters, effective backup and recovery solution is a must. The backup and recovery strategy needs to be not only precise but proven in all aspects. To achieve this Oracle has come out with multiple backup and recovery solutions designed in-house and third party.

  1. Disk based backup and recovery.
  2. Tape based backup and recovery.
  3. Backup and recovery using dataguard.

Oracle's solution for effective backup and recovery of exadata is achieved using time tested recovery manager. Using recovery manager or RMAN in short we can take full backups and even incremental backups of the exadata server. RMAN is designed to work intimately with exadata server providing for block corruption detection during back and restore. The backups can be automatically parallelized across the exadata storage servers to save time. In addition, the backups can also be compressed using native compression methods and Exadata hybrid columnar compression resulting in substantial savings in terms of storage space and time required to perform the backup and restore operations. Disk based backups have the added advantage that they can be used directly without any type of restoration required. Approximate backup and recovery rates using exadata database machine for physical files are:

Machine Type

Full Image Backup

Incremental Backup

Backup Restore

Recovery

Full Rack

7.1 TB/Hr

10-46 TB/Hr

24 TB/Hr

2.1 TB/Hr

Half Rack

7.1 TB/Hr

10-46 TB/Hr

13 TB/Hr

2.1 TB/Hr

Exadata has been designed to integrate with Oracle Secure backup (OSB) and other third party solutions for taking tape based backups. Using Oracle secure backup we can backup both the filesystem and the database. OSB can be used to encrypt backups for increased security and reliability. Tape based backups can also be scaled linearly by adding media servers and tape drives. Multiple copies of tape based backups can be stored at offsite for added safety. If dataguard is configured as a high availability measure then both disk and tape backups can be performed on the physical standby environment without impacting the performance of the primary system.

The backup and recovery solution for performing either disk or tape backups can be fully automated by using RMAN scripts. This requires minimal human intervention and removes the manual effort required for performing daily backups, resulting in huge cost savings to the customer. Many customers have successfully adopted this concept in their production environments.
___________________________________________________________________________________________

Meet Infosys experts at Oracle OpenWorld 2011, Booth No. 1813, Moscone South

Explore more at  http://www.infosys.com/Oracle/news-events/Pages/oracle-openworld-sanfrancisco11.aspx

Follow us on Twitter -  http://twitter.com/infosysoracle

____________________________________________________________________________________________  

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)

Please key in the two words you see in the box to validate your identity as an authentic user and reduce spam.

Subscribe to this blog's feed

Follow us on

Blogger Profiles