Transcript Disk Group
OUGF 15v Juhlaseminaari 6.11.2003 Marko Hotti Product Manager, Oracle10g Oracle Finland Oy Problem with Today’s IT Infrastructure Islands of Computing Resource – – Some are melting down Some are almost idle High Costs – – – Hardware Labor Software CRM ERP Hard to Align with Business Priorities DW Solution: Computing On Demand Mainframe Model Partitioning of one large server Built with high quality, high cost parts Complete, integrated software High quality of service at high cost Grid Computing Model Coordinated use of many small servers Built with low cost, standard, modular parts Open, Complete, integrated software High quality of service at low cost Requirements for Enterprise Grids Run all your applications Stores all your information Highly scalable, available, reliable Secure Easy to manage – – Make individual systems self-managing Manage thousands of servers at once Grid Computing Policy Manager Resource Manager Workload Manager Policy-Based Workload Management BLADE FARM (Local Grid) High Speed Interconnect Dynamically Provisioned & Registered BLADES Oracle Database 10g – The First Database Designed for the Grid Oracle Database 10g – Database for the Grid Storage for All Your Data Real Application Clusters High Availability Ease of Management Data Provisioning across Grid Business Intelligence on the Grid Application Development on the Grid Oracle10i - Stores All Your Data Complete Integrated Max size 8 HB No LOB size restr. Relational Characters, Numbers and Dates Oracle Text Text management and search Oracle interMedia Multimedia management Oracle Locator Location and Proximity Searching XML DB Integrated Native XML Database OCS Files Low-cost and Easy Oracle Database 10g – Align Storage with the Business Problem: Islands of storage – “My storage is 50% utilized and growing 30% a year” CRM ERP DW Automatic Storage Management – Dynamically Provision and Tune Storage Portable, high performance file system Eliminates need for conventional file system and volume manager Automatic mirroring Automatic I/O tuning – Stripes data across disks to balance load ASM Extends SAME Concept SAME = Stripe and Mirror Everything – – Spread I/Os across as many LUNs as possible Eliminates manual I/O tuning in static storage configurations ASM = Automatic Storage Management – – – Allows dynamic and online reconfiguration of storage resources Efficient relocation of data during rebalance Eliminate manual I/O tuning in all storage configurations Why We Stripe Unstriped Disks Striped Disks Automatic Storage Management Extends SAME – – – Allows dynamic and online reconfiguration of storage resources Efficient relocation of data during rebalance Eliminate manual I/O tuning in all storage configurations Operational Stack ASM TODAY Tables Tables Tablespace Files Tablespace 0010 0010 0010 0010 0010 0010 0010 0010 0010 0010 Files File System File System Logical Vol Logical Vol Disk Group Disk Group NO mapping required Simpler to set up ASM Objectives Easier management of storage resources Optimize productivity of DBAs – – – – – Eliminate day to day I/O tuning tasks Built in best practices Eliminate database physical configuration layout Manage disk groups not files Non-intrusive storage resource addition/reduction Common storage management interface – – Works the same on any OS Same interface for any storage Disk Groups & Failure Groups Controller 1 Controller 2 Storage resources organized into Disk Groups and Failure Groups A Disk Group is a collection of disks managed as a logical unit in which ASM files are stored Disk Groups assigned by DBAs A Failure Group is a set of disks sharing a common resource whose failure needs to be tolerated – Redundant copies of an extent are stored in separate Failure Groups Failure Groups assigned by DBAs or automatically by ASM Failure Group 1 Failure Group 2 Disk Group Flash Recovery Area Weekly Archive To Tape Fully automatic disk based backup and recovery – Set and Forget Nightly incremental backup rolls forward recovery area backup Nightly Apply Validated Incremental – – – Database Area Flash Recovery Area Production DB Backup of DB & Archive Logs Two Independent Disk Systems – 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 Optimized Incremental Backup Optimizes incremental backups Redo Generation Redo Log List of Changed Blocks – Oracle10i is integrated with the change tracking file – – Change Tracking File 1011001010110 0001110100101 1010101110011 Track which blocks have changed since last backup Changed blocks are tracked as redo is generated RMAN backup automatically uses changed block list Flashback Error Correction Database Customer Recovery at all levels Database Level – Flashback Database restores the whole database to time Uses Flashback Logs Table Level – Order – Flashback Table restores rows in a set of tables to time Uses UNDO in database Flashback Drop restores a dropped table or a index Recycle bin for DROPs Row Level – Flashback Rows restores rows to time Uses Flashback Query Oracle Database 10g RAC Capacity on Demand for the Grid Only Cluster Database that runs Real Applications and Scales Highly Available Runs on standard, low cost servers Proven – – Hundreds of customers Certified with leading apps ERP CRM DW Oracle Database 10g RAC Complete, Integrated Clusterware Complete Oracle cluster software solution Single-vendor support Low Cost – – No need to purchase additional software Easy to install, manage High quality and functionality across all platforms Common event and management API’s – Multi-tier HA & minimal MTTR Support for third-party clusterware Services Framework Cluster Control/Recovery Messaging and Locking Connectivity Benefits of Integrated Clusterware Lower software cost Easy – – Deploys in hours not days Single integrated target for cluster management provides improved single system image Less Risk – – Same high functionality and quality across platforms Single vendor support Software Cloning “Our administrators spend about 25% of their time on installs and cloning” -Verizon Information Services DBA Reduce manual labor in software life-cycle – Automate mass provisioning of reference systems Intelligent Cloning makes context-specific adjustments – – 1 From hours to minutes DB: home, host name, listener iAS: IP address, host name, web listener Select Software (and Instances) to Clone Clone to Selected Targets 2 3 Update Inventory Scalable Software Maintenance - Automated Patch Management Real-time discovery of new patches – Security patch rapid deployment dramatically reduces vulnerabilities Automatic staging and application – From hours to minutes Rolling RAC upgrade 2 Determine Applicability 3 Apply Patch 4 1 Patch Published Update Inventory Rolling a Patch on RAC for 10g Shutdown instance 1 Patch instance 1 Start instance 1 Test the patch Shutdown instance 2 Patch instance 2 Start instance 2 Shutdown instance 3 Patch instance 3 Start instance 3 Result: Zero Downtime Oracle Database 10g Ease of Management Self-Managing Database OEM Grid Control – – Grid-wide operations Scale from one to hundreds of systems with little incremental cost Oracle Database 10g Self-managing Database Built-in Intelligent Infrastructure – – Automatic Database Diagnostic Monitor – Automatic performance diagnostic engine in the database Automatic Tuning Optimizer – Code instrumentation Data warehouse to analyze performance of customer workloads SQL Profile to tune packaged applications Automatic PGA and SGA Memory Management Lots more … Automatic Workload Repository Advisory Infrastructure Server-generated Alert Infrastructure Automatic Maintenance Task Infrastructure Automatic Workload Repository Automatically collect and compute important statistics, SQL workload, feature usage Direct memory access Periodically flush snapshots to disk Base-lining capability Primarily build for automating internal components Automatic Workload Repository ADDM finds top problems MMON SYSAUX WR Schema 7:00am In memory statistics 7:30am Snapshot 2 8:00am Snapshot 3 8:30am SGA 8:30am Snapshot 1 Snapshot 4 Oracle10g System Management – Automatic Diagnostic Monitor (ADDM) Performance expert in a box Automatically provides databasewide performance diagnosis, including RAC Pinpoints root cause and non-problem areas Runs proactively Oracle10g System Management – Automatic SGA Management Online Users Buffer Cache Large Batch Jobs Buffer Cache Large Pool Large Pool SQL Cache SQL Cache Java Pool Java Pool sort sort Only 2 memory parameters Advisor helps set parameters Automatically resizes with changes in SGA Pool workload Maximize usage PGA Pool of available memory Oracle10g System Management – Self Optimizing SQL Management Packaged Applications High-load SQL Custom Applications Optimizer Auto SQL Tuning Auto SQL Analysis Access Advisor SQL Profile SQL Advice Indexes & MVs Packaged Applications Custom Applications Custom Applications Well-tuned SQL Automated capture and identification of high-load SQL Automatic SQL Tuning Automatic SQL Analysis SQL Access Advisor otn.oracle.com Join Over 3,000,000 Developers! Free Technical Advice Free Software Downloads OTN Service Network Oracle Database 10g – New Manageability Features - On Friday, 21st of November, 2003 at 9am (-4pm) - Oracle University, Oracle House, Espoo - Trainer: Stefan Lindblad, Oracle University, EMEA Email: [email protected]