Title: Oracle Exadata Maximum Availability Architecture Emre Baransel
1Oracle Exadata Maximum Availability
ArchitectureEmre Baransel Advanced Support
Engineer
2Oracle 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
3Oracle Exadata Maximum Availability
ArchitectureExadata MAA yapisi
4Oracle 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
5Oracle 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
6Oracle Exadata Maximum Availability
ArchitectureYedekleme ve Yedekten Dönme
25TB/hour 27 TB/hour 9 TB/hour 8
TB/hour
7Oracle 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
8Oracle 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
9Oracle 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
10Oracle Exadata Maximum Availability
ArchitectureExadata Backup Recovery
11Oracle 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)
12Oracle 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
13Oracle 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
14Oracle 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.
15Oracle 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