Oracle Exadata Maximum Availability Architecture Emre Baransel

1
Oracle Exadata Maximum Availability
ArchitectureEmre Baransel Advanced Support
Engineer
2
Oracle Exadata Maximum Availability
ArchitectureMAA Nedir?
Oracle MAA asagidaki konulari detayli inceleyen
bir projedir
Yüksek Erisilebilirlik - High Availability
(HA) Felaketten Kurtarma - Disaster Recovery
(DR) Yedekleme ve Yedekten Dönme - Backup and
Recovery (BR)
Oracle test ortamlarinda hazirlanir - Oracle
müsteri sistemlerinde hayata geçirilir ve
dogrulanir. Operasyon ve konfigürasyon
açisindan Best Practice uygulamalari
belirler Hata/Ariza Toleransi ve hizli sorun
giderme Online degisiklikler and rolling
güncellemeler Minimum kesinti
3
Oracle Exadata Maximum Availability
ArchitectureExadata MAA yapisi
4
Oracle Exadata Maximum Availability
ArchitectureExadatada Varolan MAA Komponentleri

• 2-8 Database Servers ? RAC
• 3-14 Storage Servers ? ASM (normal-high
  redundancy)
• REDUNDANT DB node local disks drives (3-7 disk
  RAID5 - 1 disk Hot Spare)
• // Infiniband switches
  Dual-port (QDR) Host Channel Adapters
• // power supply

• Oracle Hardware Assisted Resilient Data (HARD)
• Automatic Service Request
• Rolling Upgrades - Online Redefinition - Exachk

5
Oracle Exadata Maximum Availability
ArchitectureKurulum Sonrasi MAA Tavsiyeleri

• Archivelog Mode
• Force Logging
• Fast Recovery Area
• Oracle Flashback Technologies
• Flashback Database
• Flashback Query, Flashback Version Query,
  Flashback Transaction Query, Flashback Table,
  Flashback Drop (Recycle Bin)
• ASM High Redundancy

Understanding ASM Capacity and Reservation of
Free Space in Exadata Doc ID 1551288.1
6
Oracle Exadata Maximum Availability
ArchitectureYedekleme ve Yedekten Dönme
25TB/hour 27 TB/hour 9 TB/hour 8
TB/hour
7
Oracle Exadata Maximum Availability
ArchitectureDisk Backup Best Practiceler
Incrementally Updated Backup Merged Backup
Image Copy Block Change Tracking

• Disk backup performansi için
• - Tüm db instancelari kullanin ve her
  instancea iki RMAN kanali ile baslayin.
• Performans iyilestirme gerektiginde ikiser
  kanal eklenebilir.
• - FILESPERSET1 incremental backuplarda
  kullanilmali.
• (tek file restore/recovery hizini arttirir)
• "_file_size_increase_increment"2143289344
• (RMAN ASMden 2GBlik alanlar tahsis edecek,
  default 64MB)
• "_backup_disk_bufcnt"64
• "_backup_disk_bufsz"1048576
• "_backup_file_bufcnt"64
• "_backup_file_bufsz"1048576

8
Oracle Exadata Maximum Availability
ArchitectureZFS Yedekleme Konfigürasyonu

• Exadata - ZFS konfigürayonu Oracle development
  tarafindan test edilir, dogrulanir ve
  desteklenir.
• Read-only Snapshot ve read-write Clone
  veritabanlari (HCC uncompress gerekli degil)

Backup and Recovery Performance and Best
Practices using Oracle Sun ZFS Storage Appliance
and Oracle Exadata Database Machine http//www.or
acle.com/technetwork/database/features/availabilit
y/maa-wp-dbm-zfs-backup-1593252.pdf "Oracle
Exadata Backup Configuration Utility for Sun ZFS
Storage Appliance" tool http//www.oracle.com/tec
hnetwork/server-storage/sun-unified-storage/downlo
ads/zfssa-plugins-1489830.html
9
Oracle Exadata Maximum Availability Architecture
Tape Backup Best Practiceler

• RMAN ile uyumlu tüm tape yedekleme ürünleri
  desteklenir
• Exadata ile Tape Library arasinda bir Media
  Server bulunmalidir
• Backup - restore hizi tape okuma yazma ve
  baglanti hizina baglidir

Disk backupla birlikte tape backup kullanimi
tavsiye edilir Artilari Veri Exadata
kutusunun disinda yedeklenir Yedeklerin uzak
lokasyonlarda saklanmasi kolaydir Birden fazla
yedek düsük maliyetle saklanabilir
10
Oracle Exadata Maximum Availability
ArchitectureExadata Backup Recovery
11
Oracle Exadata Maximum Availability
ArchitectureFelaketten Kurtarma
Data Guard ve Active Data Guard

• Kesinti aninda otomatik failover
• Standby-First Patch Apply (gt11.2.0.1)
• Primary veritabanindan yük azaltma
• (Active Data Guard, backup, corruption detection,
  flashback database)
• Exadatada çok yüksek recovery hizi (290 MB/s)

12
Oracle Exadata Maximum Availability
ArchitectureNon-Exadata Standby

• Failoverda HCC tablolarin uncompress edilmesi
  gerekir.
• Standbyda daha fazla disk ihtiyaci ortaya çikar
• Active Data Guard HCC tablolar üzerinde
  kullanilamaz

13
Oracle Exadata Maximum Availability Architecture
Corruptiondan Korunma
DB_BLOCK_CHECKSUM OFF (FALSE) TYPICAL (TRUE) TYPICAL (TRUE) FULL Physical Corruption
DB_BLOCK_CHECKING OFF (FALSE) LOW MEDIUM FULL (TRUE) Logical Corruption
DB_LOST_WRITE_PROTECTTYPICAL (Exadata da
default TYPICAL)
Best Practices for Corruption Detection,
Prevention, and Automatic Repair - in a Data
Guard Configuration ID 1302539.1
14
Oracle Exadata Maximum Availability
ArchitectureDiger MAA Tavsiyeleri

• Erisilebilirlik SLAlerinin (hangi sorunda hangi
  aksiyon alinacak, ne kadar kesinti olacak vs.),
  RTO, RPO degerlerinin dökümante edilmesi.
• SLAler ile uyusan kesinti/çözüm matrislerinin
  hazirlanmasi ve dogrulanmasi.
• 888828.1 - Database Machine and Exadata Storage
  Server 11g Release 2 (11.2) Supported Versions
  My Oracle Support notundaki tavsiye edilen patch
  seviyelerinin düzenli test edilerek uygulanmasi.
• 1270094.1 - Exadata Critical Issuesnotundaki
  kritik problemlerin takip edilmesi.
• Belirli periyodlarla, 1070954.1 - Oracle
  Exadata Database Machine exachk or HealthCheck 
  notundaki en güncel exachk versiyonunun
  çalistirilmasi.
• Belirli periyodlarla Data Guard switchoverin
  test edilmesi.
• EM Cloud Control Exadata monitoring ve Automatic
  Service Request araçlarinin kullanilmasi.

15
Oracle Exadata Maximum Availability
ArchitectureExadata MAA Ilgili Linkler

• Deploying Oracle Maximum Availability
  Architecture with Exadata Database Machine
• http//www.oracle.com/au/products/database/exadata
  -maa-131903.pdf
• Best Practices for Database Consolidation On
  Exadata Database Machine
• http//www.oracle.com/technetwork/database/feature
  s/availability/exadata-consolidation-522500.pdf
• Backup and Recovery Performance and Best
  Practices for Exadata Cell and Oracle Exadata
  Database Machine
• http//www.oracle.com/au/products/database/maa-tec
  h-wp-sundbm-backup-11202-183503.pdf
• Backup and Recovery Performance and Best
  Practices using Oracle Sun ZFS Storage Appliance
  and Oracle Exadata Database Machinehttp//www.ora
  cle.com/technetwork/database/features/availability
  /maa-wp-dbm-zfs-backup-1593252.pdf
• Oracle Data Guard Disaster Recovery for Oracle
  Exadata Database Machine
• http//www.oracle.com/au/products/database/maa-wp-
  dr-dbm-130065.pdf
• Exadata Maximum Availability Tests Video
• http//vimeo.com/62754145