Solidify Oracle RMAN with Oracle Sun Storage 7000

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

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

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 3

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

Line of Unified Storage Systems Sun Storage 7110 1 socket Up to 8 GB RAM 14 x SAS 10 K RPM Drives 2 TB or 4. 2 TB Only 2 U 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 Orhan BIYIKLIOGLU feat Husnu SENSOY 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 5

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

Analytics Orhan BIYIKLIOGLU feat Husnu SENSOY 7

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 8

Database Backup & Recovery Challenges of Today No compression option 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 9

Now Recovery Image backup/Backupset Level 0 #1 #2 One Week Ago #3 #4 Three Days Before Recovery Range run { RESTORE DATABASE FROM TAG WEEKLY_FULL_BCKP; } run { [SET UNTIL SCN x|SEQUENCE x|TIME ‘x’] RECOVER DATABASE FROM TAG DAILY_INC_BCKP; } Orhan BIYIKLIOGLU feat Husnu SENSOY 10

Incremental Recovery of Datafile Image Copies Image Backup #1 #2 #3 #4 #5 #6 #7 One Week Ago Faster recovery due to minimized Advantage incremental applies. Orhan BIYIKLIOGLU feat Husnu SENSOY Image copies can’t benefit from RMAN binary compression No way to go back more than a day Disadvantag 11

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

Sample ZFS & RMAN Compression Ratios 120 100 100 80 60 50. 25 40 60 31. 75 29. 41 27. 70 37. 26 40 20 30. 64 20 P 9 ZI G P 4 ZI G G ZI P 1 B LZ J N on e 0 0 None Orhan BIYIKLIOGLU feat Husnu SENSOY LOW MEDIUM 13

Design for Different Recovery Ranges Image #4 #30 Image #3 Image #2 Image #1 #1 #2 One Month Ago #3 #4 #5 #6 #7 Now … #30 #8 #9 #10 #11 #12 #13 #14 #15 … #30 Two Weeks Ago Last Night One Week Ago Orhan BIYIKLIOGLU feat Husnu SENSOY 14

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

How do we move disk backup to Tape ? • • Ternary Storage Open Storage 7000 Ternary Storage Database Host NDMP NFS Database Host RMAN will build a logical channel between Open Storage 7000 to ternary storage This cause • CPU consuption on database host • HBA utilization on database host • NIC utilization on databse host Backup Host Orhan BIYIKLIOGLU feat Husnu SENSOY Snapshot Open Storage 7000 16

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

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

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 ? Bad transaction SCN Older version than you need Image Backup #1 #2 Bad transaction is already applied #3 #4 Orhan BIYIKLIOGLU feat Husnu SENSOY 19

Unified Storage Systems allow you to play with UNTIL clause 1. 2. 3. Clone Database Host Image Copies FRA Incremental Backupsets INC 4. 5. 6. Archivelogs 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 Controlfile Autobackup OTHR Open Storage 7000 Orhan BIYIKLIOGLU feat Husnu SENSOY 20

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

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

Unified Storage Systems Performance • Use IB or 10 Gbit network fabric to access unified storage systems. Workload RDBMA IPo. IB NFS Streaming Read 2. 11 GB/s 1. 47 GB/s NFS Streaming Write 984 MB/s 753 MB/s • 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 23

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

Unified Storage Systems Configuration/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 25

Sample Designs using Unified Storage Systems Solidify Oracle RMAN with Oracle Sun Storage 7000 Unified Storage Systems RMAN Backup Share Configuration RMAN Restore & Recovery Solution Orhan BIYIKLIOGLU feat Husnu SENSOY 26

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'; Image BACKUP Copies INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG ‘DAILY_BACKUP‘ DATABASE; } RUN { ALTER DATABASE MOUNT; SWITCH DATABASE TO COPY; RECOVER DATABASE; ALTER DATABASE OPEN; Incremental Backupsets Archivelogs Controlfile Autobackup FRA Open Storage 7000 } Orhan BIYIKLIOGLU feat Husnu SENSOY 27

Advanced Solution 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 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’; } RUN { ALTER DATABASE MOUNT; RESTORE DATABASE FROM TAG ‘DAILY_BACKUP’ RECOVER DATABASE; ALTER DATABASE OPEN; } } • • Quick recovery using SWITCH is not an option Two recovery capabilities are necessary • To Just now • To somewhere in last week • DEDUP LZJB Image Copies FRA Unified Storage Systems pool is at comparable size with production size. Orhan BIYIKLIOGLU feat Husnu SENSOY Incremental Backupsets INC Archivelogs ARCHLZJB Open Storage 7000 28

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

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

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