<Insert Picture Here> Oracle Database 11g Highly Available Grid made easy with Oracle Enterprise Manager Venkat Maddali, Director of Development, Oracle Jagan Athreya, Director of Product Management, Oracle
The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.
Oracle Highly Available Grid strategy • Scale-Out architecture • Commodity hardware building blocks • Inherently highly scalable & redundant Application • Scalability & Availability responsibility moves out of hardware/OS to scale-out savvy software • First Web & Application server tiers • Application servers Database • Then DB tier • Shared disk and shared nothing databases • Then storage tier • Scale-out storage software Storage
Agenda • Oracle’s Highly Available Grid in 10g • Highly available Grid In 11g • Setup • Manage • Customer perspective on Highly available Grid
Getting on to Oracle’s HA Grid – 10g recap Convert file Create Convert Single system to Standby database SI to RAC instance ASM database database
Convert Single Instance to RAC db • Wizard-driven interface to convert single instance into multi-instance Single Instance RAC RAC database • Various pre-req checks prior to submitting the operation • Automates all necessary steps • Move database files/recovery area files to shared storage (if necessary) • Create additional undo TS, redo logs, password files, oratab/registry entries etc. • Configure listeners • Register with cluster-ware • Pre-requisites: • All nodes must be running Oracle Clusterware (CRS)
Migrate from filesystem to ASM • Migrate database, and • Simplify management of recovery files to ASM Oracle database files diskgroups and switch • Avoid single point of storage • Migration with with minimal device failure. downtime
RAC Management • Manage “many as one” • RAC/Cluster Topology views • Cluster-aware monitoring • Cluster and RAC db metrics to avoid duplicate monitoring • Load average across the cluster • Interconnect monitoring • Global Cache Coherency • Identify top node(s)/ instance(s) involved in block transfers • Identify top segments with extreme concurrency profile across some nodes • Monitor Clusterware • Cluster-aware jobs • Configure and Manage HA Services.
Agenda • Oracle’s Highly Available Grid in 10g • Highly available Grid in 11g • Setup • Manage • Customer perspective on Highly available Grid
Highly Available Grid in 11g • Setup : Provision RAC, ASM and HA configurations to implement Highly Available Grid • Manage : Extend “Manage many as one” to • Provide Service Centric monitoring • Diagnose as many
Getting on to Oracle’s HA Grid – 11g Provision Convert SI Convert Single Convert SI Clusterware db to RAC FS to instance ASM to and Oracle database ASM database Clustered ASM software
Getting on to Oracle’s HA Grid – 11g Convert Standby Create DB to RAC Standby database standby
New Feature: Convert SI ASM to Clustered ASM • Simple wizard to convert single instance ASM to Clustered ASM • Automated as an EM job • Pre-requisite to migrating the Single Instance Database to RAC Database on ASM storage
Demo
New Feature: Convert SI ASM to Clustered ASM • Pre-reqs prior to performing cluster-wide operations • Cluster verification • Node accessibility • Oracle Database Software on all selected nodes • Ensure that ASM is not in use by any database that is up • Automates • Setup of parameter files across cluster hosts • Listener configuration across all cluster hosts • Mount shared diskgroups on all nodes • Register CRS resources for ASM • Update oratab/registry • Enable monitoring by enterprise manager • Restore SI ASM back if something were to fail, so retry can be attempted after fixing the root cause (Similar to SI-RAC DB conversion)
New Feature: Setup Standby Database Grid Challenge • Deliver same High Availability and Primary Site Standby Site Scalability as Primary Production Database Solution Broker • Create Standby RAC database from Primary RAC database Benefit: • Automated creation of standby RAC database Standby Primary Database • Uninterrupted scalability and Database availability as primary database
New Feature: Manage Standby Database Grid • Manage Clustered Standby databases same as Single instance • High Availablility for Fast-Start Failover Observer • Grid Control will automatically restart the Data Guard Observer on an alternative host if the primary Observer host fails • Complete support for 11.1 DB features such as Snapshot standby, Active Data Guard, etc. • EM Management integrated with DR operations on role changes
Demo
Agenda • Oracle’s Highly Available Grid in 10g • Highly available Grid • Setup • Manage • Customer perspective on Highly available Grid
Managing Highly Available Grid in 11g • Menu based navigation • HA Console to Manage RAC/HA environment • Fast notifications on RAC DB/Instance Availability • ADDM for RAC • Service centric monitoring • Manage as one, Diagnose as many
HA Console • Configuration wide view for RAC/HA • HA Configuration standards setup instead of individual targets • Show key HA information • Summary/Chart view for HA Services • Launch HA Operations in context • Show Availability related events
Demo
ADDM for RAC Database-Level ADDM • A Performance Expert, now a RAC Specialist too! • Identifies the most “Globally Self-Diagnostic Engine Significant” performance issues • Automatically runs every hour • Cluster-wide analysis of: • Global cache interconnect issues • Lock manager congestion issues Instance-Level ADDMs • Global resource contention, e.g. IO bandwidth, hot blocks • Globally high-load SQL • Skew in instance response times Node 1 Node 2 Node 3
Service Centric monitoring • Setup HA Services with Preferred/Available configurations and carry-out required operations • Test connectivity to service • Create tns alias files for services as well as ability to export this to client machines. • Summary view of health of RAC services at RAC home page as well as HA Console
Service Centric monitoring • Drilldown to show all HA Services with configuration, status, service response time and CPU utilization metrics
Service Centric monitoring • Workflows to show Service Activity by Waits and Instances drilldowns to identify SQL/Session
Service Centric monitoring • Drilldowns to identify SQL/Session
Manage as one, Diagnose as many • Augment Summary/roll-up views with Tile charts to view selected metric across all nodes/instances of the cluster
Manage as one, Diagnose as many •Provide cluster-wide views of metrics using Tile charts •Cluster metrics (CPU, Memory and Disk I/O) across cluster hosts •Host Load Average
Manage as one, Diagnose as many
Manage as one, diagnose as many •Provide cluster-wide views of metrics using Tile charts •Wait metrics •Cache Coherency metrics (e.g. Blocks transferred, etc.)
Manage as one, Diagnose as many • Customizable tile charts • Number of charts per row • Order by • Average over 1 hr • Maximum over 1 hr • Instance ID • User defined
Demo
Agenda • Oracle’s Highly Available Grid in 10g • Highly available Grid • Setup • Manage • Customer Perspective on Highly Available Grid
<Insert Picture Here> HA management in Oracle Database 11g using Oracle Enterprise Manager Julian Dontcheff, Senior DBA, Nokia
Availability Enterprise Manager 11g Database Control
Availability Enterprise Manager 11g Database Control • Browser-Based Enterprise Manager Integrated Interface for LogMiner • Enhanced Oracle RAC Monitoring and Diagnostics in Enterprise Manager
Availability Enterprise Manager 11g Database Control
Availability Enterprise Manager 11g Database Control • Browser-Based Enterprise Manager Integrated Interface for LogMiner
Availability Enterprise Manager 11g Database Control Browser-Based Enterprise Manager Integrated Interface for LogMiner
Availability Data Guard
Availability Data Guard • Use OEM to create the standby database • Use RMAN to duplicate the database for standby
Oracle Highly Available Grid Enterprise Enterprise • Automate migration to Manager Manager Storage Grid • Automated migration to Application Highly available Database Grid • Management of Highly Management Database Available Oracle grid Console • Highly available monitoring Storage
Recommend
More recommend
