Data Guard Technology Overview

1
Oracle 11G New Features Technology
Workshop Asaf Lev Ofir Manor asaf.lev_at_orac
le.com ofir.manor_at_oracle.com http//tech.theoracl
es.co.il
2
Agenda

• Introduction to the Technology Workshops
• Administering using 11G Database Control
• 11G New Features
• Using Database Advanced Compression
• Total Recall
• Real Application Testing
• SQL Performance Analyser
• Transparent Database Encryption
• Summary

3
Agenda
900 905 Workshop Environment Introduction
905 920 Workshop Review Part I
DBConsole 11G
Advanced Compression
Total Recall
1055 1115 Workshop Review Part II
Real Application Testing
Development Performance Feature (SPA)
Transparent Data Encryption (TDE)
1315 1330 Summary Lunch !!!
4
Technology Workshops

• Workshop Environment
• Windows
• Vmware
• Virtual Machines running OEL 5.1
• Firefox, SQLDeveloper, SQLPlus
• 11g DB running DB control

5
Technology Workshops

• System Environment
• Windows
• Vmware
• Virtual Machines running OEL 5.1
• Firefox, SQLDeveloper, SQLplus
• 11g DB running DB control
• THIS IS NOT A SUPPORTED CONFIGURATION

6
Workshop Contents Part I
7
11g Grid Directions

• Simplicity - Make the grid as easy as a single
  system
• Expert system for cross-cluster performance
  diagnostics
• Zero-configuration node management
• Quality of service management
• Seamlessly manage resources across middle-tier,
  database, and storage
• Policy-based performance and workload management

8
11g Value Proposition

• Easiest to Manage
• Highest Quality of Service
• Highest Performance and Scalability
• Fault Tolerant
• Most Secure
• Best Information
• Lowest Risk of Change

9
Self Managing Database
Auto-Tuning
Advisory
Storage Backup Memory Apps/SQL Schema
RAC Recovery Replication
Instrumentation
10
Self Managing Database
Auto-Tuning
Advisory
Storage Backup Memory Apps/SQL Schema
RAC Recovery Replication
Instrumentation
11
11g Database Console

• Objective get familiar with the DB Control UI,
  and navigation through the menus
• Performance tab
• Data Movement tab
• Enterprise Manager, Grid Control, DB Console?!?!

12
Advanced Compression

• Oracle 9i - compresses data only during bulk load
  
• Data warehousing
• Table compression is now viable for all
  applications
• Compress during random updates
• Typical compression ratio of 2x to 3x
• Database directly reads compressed data bypassing
  decompression overhead
• Strategy - Compress 10 largest tables in a
  database
• Reduce table data by half, increase CPU usage 5

13
OLTP Table Compression Process
14
Compression Results
15
Compression Results
16
Compression Results
17
Compression Results
18
Flashback Data Archive Total Recallhttp//ww
w.youtube.com/watch?vliO8UK2K-p4
ORDERS
19
Flashback for Rapid Recovery from Human Error
FlashbackData Archiveand Transaction
20
Flashback Data Archive

• Flashback Data Archive
• Easy, practical way to add time dimension to
  your data
• For change tracking, auditing, compliance,
• Query data AS OF any time in the past
• Efficient storage / retrieval of undo data
• DFA Vs. Other Flashback Tech
• Historical data can be accessed from any
  specified duration, far and beyond the undo or
  flashback log data.

ORDERS
Total Recall
21
Flashback Data Archive

• FBDA process
• Collects and writes the original data to
  flashback data archive
• Works Asynchronously
• Default sleeps for 5min (Changes dynamically
  according to traffic)
• Flashback Data Archive
• Based on new data dictionary objects
• Uses Advanced Compression
• Uses partitioning in its internal scheme
• Based upon quota retention policy definitions
  for flashback archive
• The internal history table is a replica of the
  tracked table with addition timestamp column

ORDERS
Total Recall
22
Workshop Part I
http//tech.theoracles.co.il/
23
Workshop Contents Part II
24
Lifecycle of Change Management New Change
Assurance Capabilities
Detect and TunePerformance Changes
Capture andReplay Workload
Provision - Upgrade or Clone
Set Up TestEnvironments
Configure and Maintain Production System
Package Incidentsfor Support
Online Hot Patching
25
Make Change Safe - Realistic Testing with
Database Replay

• Recreate actual production database workload in
  test environment
• No test development required
• Replay workload in test with production timing
• Analyze fix issues before production

Production
Test
Replay DB Workload
Middle Tier
Capture DB Workload


Test migration to RAC
Oracle DB
Storage
26
Make Change Safe Find Regressed SQL with SQL
Performance Analyzer
27
Make Change Safe - Online Upgrades

• Major online upgrade enhancements
• Online database upgrades for Data Guard Physical
  Standby
• Physical Standby is Data Guards high performance
  disaster recovery solution
• uses new Transient Logical Standby feature for
  online upgrades
• Online database patching
• for one-off patches including diagnostic patches

28
Make Change Safe Fault Resolution

• New facilities to speed fault resolution
• Automatic Fault Diagnostics
• New facilities to capture and manage relevant
  information for incidents (faults) to speed
  Support processes
• Support Workbench
• Repair Advisors
• Speed analysis of root cause for faults
• Advise DBAs on repair strategy

29
Transparent Data Encryption

• Building on transparent column level encryption
  in Oracle Database 10g Release 2
• Tablespace level encryption
• For encrypting entire application data
• Supports foreign keys and range scan
• LOB encryption
• Master Key protection in hardware using PKCS 11
• Integrates with LogMiner, Logical Standby,
  Streams, Datapump

30
Workshop Part II
http//tech.theoracles.co.il/
31
Summary and Feedback http//tech.theoracles.co
.il/
32
Other Oracle Database 11g Highlights

• Security
• Tablespace and LOB Encryption
• Secure Configuration
• Business Intelligence
• BI Publisher Reporting
• Supermodels for Data Mining
• Unstructured Data Management
• Enhanced XML indexing
• Storage Query of Semantic Content
• Developer Productivity
• APEX 3.0 including support for Flash Charting and
  PDF output
• Improved PHP Scalability
• .NET Improvements
• Simple compilation of PLSQL and Java Stored
  Procedures

• Performance and Scalability
• Query Result Cache
• TimesTen Cache Enhancements
• RAC Scalability Enhancements
• High Availability
• Data Recovery Advisor
• Readable Physical Standby
• VLDB/ILM
• Interval and Referential Partitioning
• Enhanced Compression
• Manageability and Diagnosability
• Support Workbench
• SQL Performance Analyzer
• SQL Test Case Builder

33
Oracle SecureFilesConsolidated Secure Management
of Data

• Many applications have both files and relational
  data
• e.g. Document Management, Medical, CAD, Imaging
• SecureFiles breaks the performance barrier that
  has kept file data out of databases
• Similar to LOBs but much faster, and with more
  capabilities
• Transparent encryption, compression,
  deduplication, etc.
• Preserves security, reliability, and scalability
  of database
• Superset of LOB interfaces for easy migration
  from LOBs
• Benefits
• Single security model
• Single view of data
• Single management of data
• High performance

34
Unlocking the Value of Standby DBs
Logical Standbyfor RealtimeQuery
Standbyfor OnlineUpgrade,Auto Failover
Standbyfor Testing,ReadablePhysical
Standbyfor DRand Backup
35
Physical Standby with Real-Time Query
Real-time Queries
Concurrent Real-Time Query
Continuous Redo Shipment and Apply
Primary Database
Physical Standby Database

• Read-only queries on physical standby concurrent
  with redo apply
• Supports RAC on primary / standby
• Queries see transactionally consistent results
• Immediate appeal to the many users of physical
  standby
• DR with real time query is unique in the industry
  no idle resources
• Handles all data types, but not as flexible as
  logical standby