Expert Oracle RAC Tips [ Burleson ]

Expert Oracle RAC Tips Oracle RAC Cluster Tips by Burleson Consulting

---

• Activating Existing Resources
• Adding Instances to Nodes
• Adding Nodes at the Vendor Clusterware
  Layer in UNIX/Linux
• Additional Wait Events of Concern
• Administering ASM Instances with SRVCTL in RAC
• Advantages of the RAC Database
• Analysis of Performance Issues
• Application Deployment Issues
• ASM Related Initialization Parameters
• Asynchronous I/O
• Automatic Segment Space Management
• Automated Storage Management Configuration
• Automatic Shared Memory Management
• Availability, Reliability and Serviceability
• Avoiding Split Brain
• Before and After Oracle 9i RAC
• BFT ROWID Format
• Blade Servers
• Block Access Modes and Buffer States
• Block Access, Grants, and Interrupts
• Block Transfers Using Cache Fusion - Example
• BRTOOLS
• Cache Fusion
• CFS Multiple Tape Drive Backup
• Cluster File System (CFS)
• Cluster Interconnect
• Cluster Interconnect Products
• Cluster Ready Services (CRS)
• Cluster Ready Services (CRS)
• Cluster Software
• Cluster Volume Management (CVM)
• ClusterWare
• Clusters vs. Grids
• Cold Backup Using Scripts
• Compartmenting Transactions to Specific Nodes
• Components of a Cluster
• Compute Backbone - JP Morgan Chase’s Grid Story
• Concept of Past Image (PI)
• Concept of Redo Thread
• Concurrency and Consistency
• Concurrent Database Access
• Configuration of OEM with RAC
• Configure OCFS for Linux
• Configure PolyServe Cluster File System for Linux
• Configuring Virtual IPs for 10g RAC
• Context Dependent Symbolic Link (CDSL)
• Conversion of a Single Instance on a Cluster Running
  from a RAC-Disabled Oracle Home
• Convert Datafiles using RMAN
• Create, Run, Stop, Copy, and Drop a Job
• Creating a Recovery Catalog
• Creating a Single Instance on a Cluster to Oracle
  Database 10g RAC
• Data and Resource Storage
• Database Block Buffers
• Database Consolidation
• Database Created Manually
• DB Optimized Option
• Deletion of Backed-Up Archive Logs
• Designing Equipment for Real Application Clusters
• Determine Platform Endianness
• Direct Attached Storage (DAS)
• Example:  Converting Tablespace on the Target Platform
• Exploring Grid Technology
• Fabric Fencing
• Failover Cluster Architecture
• Failover Database Clusters
• Failure Groups
• Fault-Tolerant Systems
• General Installation Steps
• General Parallel File System - GPFS
• Global Cache Service (GCS)
• Global Cache Services (GCS): Main Function
• Grid Clusters
• Grid Computing vendors
• Grid Software Components
• High Performance Computing and Availability
• Highly Available Databases
• IBM Offered Parallel Database Systems
• Implementing the Oracle Hardware Assisted Resilient
  Data (HARD) Initiative for the OCR
• Importing the Oracle Cluster Registry with OCR Exports
• Initialization Parameters for UNDO Management
• Install the CRS
• Installing Cluster Ready Services (CRS)
• Installing CRS and RAC
• Introduction to Oracle RAC and Grid
• Issues with Failover (FO) Clusters - Hidden Risks
• I/O Fencing
• Java Pool
• JDBC Connectivity
• Large Batch Jobs
• Layered Grid Architecture and Technology
• Limitations of ASM for RAC Database Use
• Load Balancing
• Log Shipping
• Managing Grid Using Grid Control (OEM)
• Manual Space Management
• Media Recovery in RAC Instances
• Migration to RAC Databases
• Migration Features
• Minimizing Table Locks to Optimize Performance
• Mirrored Stripes or Striped Mirrors
• Mirroring
• Monitoring Current Blocks
• Monitoring RAC with Grid Control
• Multiple Access Paths to Host
• Multi-Valued Parameters
• Multi-Version Consistency Model Architecture
• Multiple Block Sizes in RAC Environment
• Nature of Cache Fusion
• New Parameters for Data Pump Import
• NICS and HBAs
• NUMA Architecture
• Online and Real-Time Access to Corporate Data
• Oracle 10g - Automated Storage Management (ASM)
• Oracle 10g - The Database for the Grid
• Oracle and Data Grid Computing
• Oracle Data Pump
• Oracle Database and Database Instance
• Oracle Database Creation - Required Services
• Oracle Database Creation
• Oracle Database Software with RAC Option
• Oracle Disk Manager (ODM)
• Oracle eBusiness Suite
• Oracle Managed Files (OMF)
• Oracle Parallel Databases
• Oracle RAC Database Nodes
• Oracle RAC Database Resonance
• Oracle RAC Grid Evolution
• Oracle RAC Grid Computing Fundamentals
• Oracle RAC Grid Trends
• Oracle RAC Specific Processes
• Oracle RAC - Types of Grid computing
• Oracle RAC Software Installation
• Oracle Real Application Cluster
• Oracle Recovery Manager (RMAN)
• Oracle Row-Level Locks
• Original Import Utility Parameter
• Overview of RAC Backup and Recovery
• Overview of Transparent Application Failover (TAF)
• Parallel Database Clusters (PDB)
• Parallel DDL Statements
• Parallel Execution or Processing
• Parallel Query: SELECT
• Parallel Processing
• Parallelism in Oracle Relational Database
• Parameter Management
• Partitions Within the Server
• Password File
• Perform the Pre-Installation Steps
• Procedure to Implement and Manage DRM
• PSFS File System
• Public and Private Rollback Segments
• RAC Additional SGA Areas
• RAC Grid Suitability for Packaged Applications
• RAC Processes
• RAC and STATSPACK
• Raw Devices
• Raw Devices in Linux
• RAID and RAID Administration
• Recovery in a Raw File System Environment
• Recovery in the RAC Environment
• Recovery Process - Re-mastering Resources
• Redo Log Buffers
• Redo Log Files
• Redo Thread Maintenance
• Redundancy Features
• Requirements for Conversion
• Server Control Utility (SRVCTL)
• Server Parameter File (SPFILE)
• SGA Components and Locking
• Shared-Disk Model
• Shared Server Configuration
• Shared Storage
• Shared Storage Configuration
• Single Instance
• Status of Oracle RAC/SAP Certification
• Storage Design and Redundancy
• Storage Redundancy Components
• Support for Infiniband Technology
• Tablespace Design in Real Application Clusters
• Tablespaces
• The Architecture of RAC
• The Concept of a Virtual Server
• The Master Table
• The Oracle Cluster Registry in RAC (OCR)
• The RAC System
• The RMAN CONVERT Clause
• The Voting Disk File
• Transferring Oracle_home to Other Nodes
• Transportable and Big Tablespace
• Types of ASM Disk Groups
• UDB EEE Architecture
• Understanding Oracle Grid and Clustering
• Undesirable Global Cache Statistics
• UNDO Management in RAC
• Unix Utility - Fuser
• Unpredictable Loads
• Upgrading and Downgrading the OCR in RAC
• Using Concurrent Conventional Path Loads
• Using Fast-Start Parallel Rollback
• Using HACMP
• Using OCI Driver
• Using SELECT for Measuring Latency
• Using Sun Cluster 3.x Environment
• Using the Oracle Interface Configuration Tool (OIFCFG)
• Verifying TAF Configurations
• Viewing Information About ASM
• Waits and Statistics for RAC Monitoring
• WebLogic and RAC Database
• What are the Effects of Component Failure?
• What is Automated Storage Management (ASM)?
• What is Cluster Interconnect
• What is Context Dependent Symbolic Link?
• What is Oracle Data Grid?
• What is a Oracle RAC Database?
• What is a Web Service?