Transcript ATA - Oracle

Session id: 36675
Oracle Database 10g RMAN and
ATA Storage in Action
Paul Tsien
Oracle Corporation
Bob Ng
EMC Corporation
Agenda
 Oracle, EMC, and the New Disk
Economics
 Oracle Recovery Manager (RMAN) 10g
Overview
 Automatic Disk Based Backup and
Recovery
 Incrementally Updated Backups
 EMC ATA technology offering
 Testing with Oracle 10g and EMC ATA
 Summary and Q&A
Disk Dollar Per Megabyte
Trend For The Last 20 Years
$1,000.00
$300.00
Dollars per Megabyte
$100.00
$35.00
$10.00
$/MB
$2.00
$1.00
1983
1988
1993
1998
2003
$0.10
$0.04
$0.01
$0.01
Oracle, EMC and the New Disk
Economics
 Oracle and EMC both are leveraging the
new disk economics to deliver superior
value propositions to our customers
 Oracle disk based backup and recovery is
faster, simpler and more reliable
 EMC ATA storage technology is right
answer to support Oracle disk based
backup/recovery
New World:
Disk Based Data Recovery
1980’s - 200 MB
 Disk economics are close to tape
 Disk is better than tape
–
1000x increase
Random access to any data
 We rearchitected our recovery
strategy to take advantage of
these economics
–
Random access allows us to
backup and recover just the
changes to the database
 Backup and Recovery goes from
hours to minutes
Trade cheap disk space for expensive down time
2000’s - 200 GB
Recovery Manager:
Oracle’s Backup & Recovery Utility
 Over 25 Man Years of Engineering
Technology provides:
Recovery
Manager
–
–
Enterprise Manager
& 3rd Party Tools
–
–
–
Media Management Layer
–
Network
–
Intimate knowledge of database file
formats and recovery procedures
Manages and automates the backup,
restore, and recovery process
Creates and maintains backup
policies
Catalogs all backup and recovery
activities
Operates on-line and in parallel for
fast processing
Corrupt block detection during
backup and restore and the ability to
validate backups
Integrated with Enterprise Manager
& 3rd party network backup
products
Flash Recovery Area


Unified storage location for all recovery files and recovery related
activities in an Oracle Database.
– Centralized location for control files, online redo logs, archive
logs, flashback logs, backups
– A flash recovery area can be defined as a directory, file system,
or ASM disk group
– A single recovery area can be shared by more than one database
Minimize the number of initialization parameters to set when you
create a database
– Define a database area and flash recovery area location
– Oracle creates and manages all files using OMF
Database Area
Flash Recovery Area
Flash Recovery Area Space
Management
Archive Logs &
Database File
Backups
Flash
Recovery
Area
Disk limit is
reached and a
new file needs
to be written
into the Flash
Recovery Area
Space Pressure
occurs
Warning Issued
to user
RMAN updates
list of files that
may be deleted
1
2
Backup Files
to be deleted
Oracle
delete files that
are no longer
required on
disk.
Benefits to Using a Flash
Recovery Area
 Unifies the storage location of related
recovery files
 Manages the disk space allocated for
recovery files automatically
 Simplifies database administrator tasks
 Much faster backup
 Much faster restore
 Much more reliable due to inherent reliability of
disks
Incrementally Updated
Backups
RMAN
incremental
backup
Incrementally
Updated Backups
RMAN
RECOVER COPY OF
DATAFILE
Initiate Merge


Eliminates the need to perform a whole database backup.
Reduces the time required for media recovery since the image
copy is updated with the latest block changes.
Eliminate Shrinking Backup
Windows Syndrome!
 Fully automatic disk based
backup and recovery
–
Set it and Forget it
 Nightly incremental backup rolls
forward recovery area backup
–
Database
Area
Nightly Flash Recovery
Apply
Area
Validated
Incremental
Weekly
Archive
To Tape
Two Independent Disk Systems
Much Faster & Easier
Changed blocks are tracked
in production DB
 Full scan is never needed
–
–
Dramatically faster (20x)
Blocks validated to prevent
corruption of backup copy
 Use low cost ATA disk array for
recovery area
Disk Based Backup/Recovery
Benefits
 Much faster backup
– Just propagate changes to recovery area
– Dramatic difference for large databases
 Much faster restore
– Copy backup files from Recovery Area
– Or simply use the copy in the Recovery Area
 Much more reliable due to inherent reliability of disks
– Tapes not needed for normal backup/recovery,
only for archiving
EMC ATA Storage Technology
 Ideal for satisfying the added storage space
need to support Oracle Database 10g backupto-disk model
–
–
–
–
–
–
–
Reliable
Satisfactory performance
Capacity, Ease of expansion
Manageability
Cost effective
Interoperability
Investment Protection
EMC CLARiiON HA Architecture
Storage
Processor
Storage
Processor
SP Fibre x 4
SP Fibre x 4
Power Supply
Mirrored Cache
CPU
CPU
FC
FC
Fan
SPS
Fan
Fan
Power supply
LCC
SPS
CPU
CPU
FC
FC
LCC
LCC
LCC
LCC
Mirrored Cache
AT A
D I S K S
LCC
240
drives
per
storage
system
Flexibility….
15 ATA Drives
25-250 GB ATA Drives
15-250 GB ATA Drives
20-250 GB ATA Drives
Mix and Match
ATA
Fibre
Fibre
Katana
ATA
Katana
ATA
Klondike
Katana
Katana
Fibre
ATA
Klondike
Klondike
Katana
Katana
Fibre
Klondike
Klondike
ATA
Klondike
Klondike
Katana
Katana
Fibre
Katana
Katana
30-73 GB Fibre Drives
15-146 GB Fibre Drives
15-15k rpm Fibre drives
15-73 GB Fibre Drives
CX600 SPE Assembly
EMC ATA Technology Meeting
the Need
Reliability
Performance
Delivered with time proven CLARiiON HA architecture. Disk
storage RAID protection of your choice
CLARiiON 6th generation storage system driven with dual Intel
2GHz processors and sophisticated caching technology
Capacity
Up to 200+ ATA drives at 250GB (and higher). Modular
expansion and flexibility to accommodate growth
Manageability
Web Based Management from anywhere of one or more
CLARiiON systems with EMC CC Navisphere Manager
Cost effectiveness
ATA storage cost per MB approach point of matching tapes
with significantly faster read/write efficiency
Interoperability
EMC SAN Copy capability allow block storage data to be
exchanged between CLARiiON and other storage on SAN
Investment
Protection
EMC CLARiiON CX family supports upgrade path from low
end entry system to high end to accommodate your growth
Testing RMAN 10g Backup to
ATA Flash Recovery Area
 Test configuration
–
–
–
–
–
Server : Dell 2650
2x2.8Ghz CPUs, 4GB
RAM
OS : SuSE SLES 8.0
kernel 2.4.19
Oracle Software : 10g
beta for Linux 10.0.1.0
Host I/O Adapters :
QLOGIC 2340 (two)
FC SAN DB storage
ATA area 1
ATA area 2
RMAN
10g
DB
files
DLT tape drive 1
DLT tape drive 2
Testing Objectives
 Compare RMAN full backup to ATA based disk
recovery area versus tape type channel
 Compare RMAN restore and recover from ATA
disk vs. tape
Observations
• RMAN backup and restore streaming I/O @ 40+MB/s
− Oracle RMAN drives full backup/recovery I/O at 1MB per
OS request whenever possible
− Ideal for CLARiiON 8+1 RAID-5 read/write when data
stripes over the 8 spindles at 64KB or 128KB per stripe
element
− CLARiiON write cache ensures full stripe data transfer
to/from storage area
− Slower ATA disk seek does not significantly affect full stripe
I/O as service time dominated by data transfer time
• Backup writes to tape channels max out @ 15MB/s
per parallel RMAN backup channel
Note: RMAN backup and restore speed is limited by available hardware
Conclusions from Testing
Backup/Recovery from disk obviously more
effective than with traditional tape approach
EMC ATA disk technology does the job
Related Technologies
 CLARiiON storage based data replication/cloning software
–
–
Allows captured disk data to be effectively replicated to another
storage area or storage system without server resource
Second disk image copy can be repurposed and used without
interfering with primary copy usage
 Oracle Data Guard
–
–
Automates the creation and maintenance of one or more
transactionally consistent copies (standby) of the production (or
primary) database
If the primary database becomes unavailable (disasters,
maintenance), a standby database can be activated and assume
the primary role
Summary
 Joint Oracle/EMC test data shows that disk based
backup and recovery is faster, simpler, and more
reliable
 EMC ATA storage is ideal for satisfying the added
storage space required for Oracle disk based backup
and recovery
 Oracle10g disk based backup and recovery and EMC
ATA storage technology deliver superior solutions by
leveraging the new disk economics
Next Steps
High Availability Sessions from Oracle
Tuesday in Moscone Room 304
Wednesday in Moscone Room 304
11:00 AM
8:30 AM
How Oracle Database 10g
Revolutionizes Availability and
Enables the Grid
Oracle Database 10g - RMAN and ATA
Storage in Action
11:00 AM
3:30 PM
Oracle Recovery Manager (RMAN)
10g: Reloaded
Oracle Data Guard: Maximum Data
Protection at Minimum Cost
1:00 PM
5:00 PM
Proven Techniques for Maximizing
Availability
Oracle Database 10g Time Navigation:
Human-Error Correction
4:30 PM
Data Guard SQL Apply: Back to the
Future
For More Info On Oracle HA Go To http://otn.oracle.com/deploy/availability/
Next Steps
High Availability Sessions from Oracle
Thursday
Database HA Demos All Four Days
In The Oracle Demo Campground
8:30 AM in Moscone Room 304
Oracle Database 10g Data
Warehouse Backup and Recovery:
Automatic, Simple, Reliable
8:30 AM in Moscone Room 104
Building RAC Clusters over
InfiniBand
See EMC’s ATA technology in
action at the EMC booth #1302
Real Application Clusters
Data Guard
Database Backup & Recovery
Flashback Recovery
LogMiner, Online Redefinition, and
Cross Platform Transportable
Tablespaces
http://www.emc.com/products/systems/clariion.jsp
For More Info On Oracle HA Go To http://otn.oracle.com/deploy/availability/
Reminder –
please complete the
OracleWorld online session
survey
Thank you.
QUESTIONS
ANSWERS