1 / 31

Solidify Oracle RMAN with Oracle Sun Storage 7000 Unified Storage Systems

Solidify Oracle RMAN with Oracle Sun Storage 7000 Unified Storage Systems. Hüsnü Şensoy h usnu.sensoy@globalmaksimum.com Founder & VLDB Expert Global Maksimum Data & Information Technologies. Orhan Bıyıklıoğlu orhan.biyiklioglu@turkcell.com.tr System Architect TURKCELL

fagan
Download Presentation

Solidify Oracle RMAN with Oracle Sun Storage 7000 Unified Storage Systems

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Solidify Oracle RMAN with Oracle Sun Storage 7000 Unified Storage Systems Hüsnü Şensoy husnu.sensoy@globalmaksimum.com Founder & VLDB Expert Global Maksimum Data & Information Technologies OrhanBıyıklıoğlu orhan.biyiklioglu@turkcell.com.tr System Architect TURKCELL Communication Services Orhan BIYIKLIOGLU featHusnu SENSOY

  2. Who are we ? Orhan Bıyıklıoğlu Hüsnü Şensoy Oracle Development & DBA experience over 6 years. Oracle DBA of the Year 2009. on BI. ORACLEExadata v2experience over 120 TB of customer data. • UNIX/Linux experience over 10 years. • Certified Engineer. • Member of the systems administration team responsible with more than 2000 UNIX servers. Orhan BIYIKLIOGLU feat Husnu SENSOY

  3. Agenda • Unified Storage Systems 101 • Solutions to Database B&R Challenges using Unified Storage Systems. • Unified Storage Best Practices for B&R. • Sample Designs using Unified Storage Systems • Conclusion Orhan BIYIKLIOGLU feat Husnu SENSOY

  4. Unified Storage Systems 101 Solidify Oracle RMAN with Oracle Sun Storage 7000 Unified Storage Systems Orhan BIYIKLIOGLU feat Husnu SENSOY

  5. Line of Unified Storage Systems • Sun Storage 7410 • 4 / 8 sockets • Up to 256 GB / 512 GB RAM • Up to 576 TB raw storage • Up to 600 GB / 1.2 TB SSD Read Flash Accelerator (SSD) • Write Flash Accelerator option (SSD) • Hybrid Storage Pool I/O Acceleration • Sun Storage 7310 • 2 / 4 sockets • Up to 64 GB / 128 GB RAM • Up to 192 TB raw storage • Up to 600 GB / 1.2 TB SSD Read Flash Accelerator (SSD) • Write Flash Accelerator option (SSD) • Hybrid Storage Pool I/O Acceleration • Sun Storage 7110 • 1 socket • Upto8GB RAM • 14x SAS 10K RPM Drives • 2 TB or 4.2 TB • Only 2U Orhan BIYIKLIOGLU feat Husnu SENSOY

  6. Open Storage 7000 Series Architectural Overview Application ZFS Hybrid Storage Pool ZIL L2ARC Pool Write SSDs Read SSDs HDDs Orhan BIYIKLIOGLU feat Husnu SENSOY

  7. Analytics Orhan BIYIKLIOGLU feat Husnu SENSOY

  8. Solutions to Database B&R Challenges using Unified Storage Systems Solidify Oracle RMAN with Oracle Sun Storage 7000 Unified Storage Systems Orhan BIYIKLIOGLU feat Husnu SENSOY

  9. Database Backup & Recovery Challenges of Today • No compressionoption for image backups available in RMAN • No storage conservative way to store multiple copies of same data item in RMAN. • Host interference in tiering to ternary storage. • Full/Partial replication of multiple databases using same backup. • Restore need of base backup in case of an erroneous recovery during point in time recovery. • Replication of disk backup to remote destination. Orhan BIYIKLIOGLU feat Husnu SENSOY

  10. Recovery Now Image backup/Backupset Level 0 #1 #2 #3 #4 RecoveryRange OneWeekAgo Three DaysBefore • run { • RESTORE DATABASE FROM TAG WEEKLY_FULL_BCKP; • } • run { • [SET UNTIL SCN x|SEQUENCEx|TIME ‘x’] • RECOVER DATABASE FROM TAG DAILY_INC_BCKP; • } Orhan BIYIKLIOGLU feat Husnu SENSOY

  11. Incremental Recovery of DatafileImage Copies Image Backup #1 #2 #3 #4 #5 #6 #7 OneWeekAgo Orhan BIYIKLIOGLU feat Husnu SENSOY

  12. Unified Storage Systems can Compress your Image Backups RMAN Compression ZFS Compression Orhan BIYIKLIOGLU feat Husnu SENSOY

  13. Sample ZFS & RMAN CompressionRatios Orhan BIYIKLIOGLU feat Husnu SENSOY

  14. Design for Different Recovery Ranges Now Image #4 #30 … Image #3 #30 … Image #2 #8 #9 #10 #11 #12 #13 #14 #15 #30 TwoWeeksAgo OneWeekAgo OneMonthAgo LastNight … #30 #1 #2 #3 #4 #5 #6 #7 #8 #9 #10 #11 #12 #13 #14 #15 Image #1 Orhan BIYIKLIOGLU feat Husnu SENSOY

  15. Unified Storage Systemscan Deduplicate your backups • Assume a database of size 10 TB • Daily change rate of 500 GB • 4x10 TB image backups • (30+23+15+1)x500 GB incremental backups • 75 TB of backup storage   Orhan BIYIKLIOGLU feat Husnu SENSOY

  16. How do we move disk backup to Tape ? • RMAN willbuild a logicalchannelbetween Open Storage 7000 toternarystorage • Thiscause • CPU consuption on databasehost • HBA utilization on databasehost • NIC utilization on databsehost Ternary Storage Ternary Storage Database Host Open Storage 7000 Database Host NDMP Snapshot NFS Backup Host Open Storage 7000 Orhan BIYIKLIOGLU feat Husnu SENSOY

  17. Clone Database • It was always a hard issue to clone a database before 11g. • Active Database Duplication makes it impressively easier in terms of configuration. • But it is still a time consuming event. Orhan BIYIKLIOGLU feat Husnu SENSOY

  18. Create Clone Databases Instantly with Unified Storage Systems • Create a readonly snapshot • Make it read & write clone • Expose those clones to clone host over NFS • Do classical database recovery Clone Database Host Image Copies IncrementalBackupsets Archivelogs ControlfileAutobackup FRA INC OTHR Open Storage 7000 Orhan BIYIKLIOGLU feat Husnu SENSOY

  19. Point in Time Recovery • Did you ever rollback a single database tablespace to get a previous state of a table before an erroneous update operation ? • How do you decide on parameter for UNTIL clause ? • What if you make a wrong decision ? Badtransaction SCN Olderversionthanyouneed Image Backup #1 #2 Badtransaction is alreadyapplied Image Backup #1 #2 #3 #4 Orhan BIYIKLIOGLU feat Husnu SENSOY

  20. Unified Storage Systems allow you to play with UNTIL clause • Create a readonly snapshot • Make it read & write clone • Expose those clones to clone host over NFS • Do classical database recovery • Check the data • If there seems to be a problem return to step 1 Clone Database Host Image Copies IncrementalBackupsets Archivelogs ControlfileAutobackup FRA INC OTHR Open Storage 7000 Orhan BIYIKLIOGLU feat Husnu SENSOY

  21. Easy Replication with Unified Storage Systems Database Host WAN Open Storage 7000 Open Storage 7000 Remote Host Remote Host Remote Host Remote Host Ternary Storage Orhan BIYIKLIOGLU feat Husnu SENSOY

  22. Unified Storage Best Practices for Backup & Recovery Solidify Oracle RMAN with Oracle Sun Storage 7000 Unified Storage Systems Orhan BIYIKLIOGLU feat Husnu SENSOY

  23. Unified Storage Systems Performance • Use IB or 10 Gbit network fabric to access unified storage systems. • Remember that current bottleneck on Unified Storage Systems is PCIe 1.0 I/O interconnects. • Refer to followings for more performance details on Unified Storage Systems. • Link 1 • Link 2 Orhan BIYIKLIOGLU feat Husnu SENSOY

  24. Unified Storage SystemsPerformance Best Practices • Choose 64K/128K blocksize for your • Image copy • Backupset • archivelogs • Remember that dedup and compression options for shares are CPU demanding operations. Don’t use them unless you need them. • Use RMAN compression whenever possible unless you have a host CPU bottleneck because it will increase you effective write speed. • 11g Release 2 : LOW or MEDIUM • 11g Release 1 : LZIB • Don’t use fast recovery with SWITCH option • Unless your production storage has a comparable performance with unified storage systems • For fully parallelise the backup of BIGFILE datafiles use SECTION option with 11g Release 1. Orhan BIYIKLIOGLU feat Husnu SENSOY

  25. Unified Storage SystemsConfiguration/Administration Best Practices • Design multiple shares differentiated depending on your need. • You can asynchronously move your backups to tape drivers from unified storage systems • But since those backup copies will require a restore from tape before database restore or SWITCH operation. • In case of a conflict with routine backup activity, use read-only snapshots as tape copy source. • Cleanup unnecessary snapshots & clones. Orhan BIYIKLIOGLU feat Husnu SENSOY

  26. Sample Designs using Unified Storage Systems Solidify Oracle RMAN with Oracle Sun Storage 7000 Unified Storage Systems Orhan BIYIKLIOGLU feat Husnu SENSOY

  27. Basic Solution • A system already running on NFS or another storage with a comparable performance. • A single disk copy is sufficient. • Quick recovery from failure is neccessary in case of a primary storage loss. • Database size very small with compared to Unified Storage Systems pool size. ALTER SYSTEM SET DB_RECOVERY_DEST=‘/export/fra’; • RUN { • RECOVER COPY OF DATABASE • WITH TAG ‘DAILY_BACKUP'; • BACKUP • INCREMENTAL LEVEL 1 • FOR RECOVER OF COPY WITH TAG ‘DAILY_BACKUP‘ • DATABASE; • } ControlfileAutobackup IncrementalBackupsets Archivelogs Image Copies FRA Open Storage 7000 • RUN { • ALTER DATABASE MOUNT; • SWITCH DATABASE TO COPY; • RECOVER DATABASE; • ALTER DATABASE OPEN; • } Orhan BIYIKLIOGLU feat Husnu SENSOY

  28. Advanced Solution ALTER SYSTEM SET DB_RECOVERY_DEST=‘/export/fra’; • Quick recovery using SWITCH is not an option • Two recovery capabilities are necessary • To Just now • To somewhere in last week • Unified Storage Systems pool is at comparable size with production size. • RUN { • RECOVER COPY OF DATABASE • WITH TAG ‘DAILY_BACKUP'; • BACKUP • INCREMENTAL LEVEL 1 • FOR RECOVER OF COPY WITH TAG ‘DAILY_BACKUP‘ • DATABASE TO DESTINATION ‘/export/inc’; • } • RUN { • SET COMPRESSION ALGORITHM ‘MEDIUM’; • RECOVER COPY OF DATABASE • WITH TAG ‘WEEKLY_BACKUP‘ • UNTIL TIME ‘SYSDATE-7’; • BACKUP AS COMPRESSED BACKUPSET • INCREMENTAL LEVEL 1 • FOR RECOVER OF COPY WITH TAG ‘WEEKLY_BACKUP‘ • DATABASE TO DESTINATION ‘/export/inc’; • } IncrementalBackupsets Image Copies Archivelogs • RUN { • ALTER DATABASE MOUNT; • RESTORE DATABASE FROM TAG ‘DAILY_BACKUP’ • RECOVER DATABASE; • ALTER DATABASE OPEN; • } DEDUP FRA INC ARCH LZJB LZJB Open Storage 7000 Orhan BIYIKLIOGLU feat Husnu SENSOY

  29. Conclusion Solidify Oracle RMAN with Oracle Sun Storage 7000 Unified Storage Systems Orhan BIYIKLIOGLU feat Husnu SENSOY

  30. To Sum Up • Oracle 7000 Unified Storage Systems based on • CommodityHardware • ZFS • Analytics is a strong product that will solidfy your RMAN backup & recovery routines. • You can start testing Unified Storage Systems capabilities by downloading VirtualBox& Oracle’s Sun Unified Storage Simulator • UnconferencesessionUnified Storage Systems • On Monday the 20th from 4-5pm I • In Mason room @ the Hotel Parc 55 (55 Cyril Magnin Street, SF). Orhan BIYIKLIOGLU feat Husnu SENSOY

  31. Thank You… OrhanBıyıklıoğlu orhan.biyiklioglu@turkcell.com.tr System Architect TURKCELL Communication Services Hüsnü Şensoy husnu.sensoy@globalmaksimum.com Founder & VLDB Expert Global Maksimum Data & Information Technologies Orhan BIYIKLIOGLU feat Husnu SENSOY

More Related