book

Expert Oracle RAC 12c

by Syed Jaffar Hussain, Tariq Farooq, Riyaj Shamsudeen, Kai Yu

August 2013

Intermediate to advanced

464 pages

15h 7m

English

Apress

Read now

Unlock full access

High Availability and ScalabilityWhat Is High Availability?Database ScalabilityOracle RACDatabase Clustering ArchitectureRAC ArchitectureHardware Requirements for RACRAC ComponentsOracle RAC: Cache FusionRAC Background ProcessesAchieving the Benefits of Oracle RACHigh AvailabilityAgainst Unplanned DowntimeHigh Availability Against Planned DowntimeOracle RAC One Node to Achieve HARAC ScalabilityConsolidating Database Services with Oracle RACConsiderations for Deploying RACCost of OwnershipHigh Availability ConsiderationsScalability ConsiderationsRAC or NotSummary
Clusterware 12cR1 and Its ComponentsStorage Components of Oracle ClusterwareClusterware Software StackClusterware Startup SequenceASM and Clusterware: Which One is Started First?Clusterware ManagementClusterware Management Tools and UtilitiesStart Up and Stop ClusterwareManaging Oracle ClusterwareManaging OCR and the Voting DiskManaging CRS ResourcesAdding and Removing Cluster NodesTroubleshooting common Clusterware Stack Start-Up FailuresDiagnose, Debug, Trace Clusterware and RAC IssuesDebugging Clusterware Components and ResourcesGrid Infrastructure Component Directory StructureOracle Clusterware Troubleshooting - Tools and UtilitiesCHMSummary

Workload ManagementServicesService MetricsLoad Balancing GoalsRuntime FailoverService in Second NetworkGuidelines for ServicesSCAN and SCAN ListenersSCAN Listener in Second Network (12c)Guidelines for SCAN ListenersGlobal Database Services (12c)Failover in RACTAFFast Connection FailoverWebLogic Active GridLinkTransaction Guard (12c)Application Continuity (12c)Policy-Managed DatabasesTemporary TablespacesMassive Data ChangesPerformance Metrics CollectionParameter File ManagementPassword File ManagementManaging Databases and InstancesManaging VIPs, ListenersMiscellaneous TopicsProcess PriorityMemory StarvationSGA sizeFilesystem CachingSummary
Oracle Flex ClustersOracle Flex Cluster ArchitectureScalability and Availability of Flex ClustersConfiguring Flex ClustersFlex ASM ArchitectureOracle Flex ASM ArchitectureFlex ASM and Flex ClustersConfiguring Flex ASMASM Clients and RelocatingNew ASM Storage LimitsReplacing ASM Disk in Disk GroupScrubbing ASM Disk Groups and FilesReading Data Evenly in ASM Disk GroupMeasure and Tune Rebalance OperationWhat-If Command EvaluationPDBs on Oracle RACPDB Architecture OverviewPDBs on Oracle RAC12cR1: Miscellaneous New Features for RACPublic Networks for RAC: IPv6 Support AddedGlobal Data ServicesOnline Resource Attribute ModificationRAC 12cR1: Policy-Based Management and AdministrationASM Disk Group: Shared ASM Password FileValid Node Checking: Restricting Service Registration12cR1: Shared GNSRAC 12cR1: Restricting Service RegistrationOracle ASM, ACFS, and ADVM: Improvements and New FeaturesNFS High Availability12cR1: CHM EnhancementsWindows: Support for Oracle Home UserOUI: Enhancements and Improvements12cR1: Installations/Upgrades—Running Scripts Automatically12cR1: Introducing Application ContinuityTransaction Idempotence and Java Transaction GuardDeprecated and Desupported FeaturesSummary
Storage Architecture and Configuration for Oracle RACStorage Architecture and I/O for RACRAID ConfigurationStorage ProtocolsMultipath Device ConfigurationSet Ownership of the DevicesASMASM InstanceASM Storage StructureManage ASM Using SQL Command and V$ASM ViewsStore OCR and Voting Disk in ASMChoose ASM for OCR and Voting Disk at GI InstallationMove OCR and Voting Disk Files to a New ASM DiskgroupACFSCreate ACFSCreate ACFS for Oracle RAC Home with ASMCASummary
Localized InsertsExcessive TRUNCATE or DROP StatementsSequence CacheFreelists and ASSMExcessive CommitsLong Pending TransactionsLocalized AccessSmall Table UpdatesIndex DesignInefficient Execution PlanExcessive Parallel ScansFull Table ScansApplication AffinityPipesApplication Change DeploymentSummary
Shared vs. Non-Shared Oracle HomesServer PoolsTypes of Server PoolsSystem-Defined Server PoolsUser-Defined Server PoolsCreating and Managing Server PoolsPlanning and Designing RAC DatabasesPolicy-Managed DatabasesInstance CagingSmall- vs. Large-Scale Cluster SetupsSplit-Brain Scenarios and How to Avoid ThemUnderstanding, Debugging, and Preventing Node EvictionsNode Evictions—Synopsis and OverviewExtended Distance (Stretch) Clusters—Synopsis, Overview, and Best PracticesExtended Distance (Stretch) Clusters: Setup/Configuration Best PracticesSetup and Configuration—Learning the New Way of ThingsOUIOracle Enterprise Manager Cloud Control 12cRAC Installation and Setup—Considerations and Tips for OS Families: Linux, Solaris, and WindowsRAC Database Performance Tuning: A Quick n’ Easy ApproachThe 3 A’s of Performance TuningSummary
RMAN SynopsisMedia Management LayerOnline Backup and Recovery PrerequisitesNon-RAC vs. RAC DatabaseShared Location for Redo and Archive LogsSnapshot Control File ConfigurationMultiple Channels Configuration for RACParallelism in RACInstance/Crash Recovery in RACReal-World ExamplesManage RMAN with OEM Cloud Control 12cOCR recoverySummary
Types of NetworkNetwork LayersProtocolsVIPsSubnettingCluster InterconnectJumbo FramesLoad Balancing and FailoverKernel ParametersNetwork Measurement ToolsGC Lost Block IssueConfiguring Network for Oracle RAC and ClusterwareEstablishing IP Address and Name ResolutionNetwork Specification in Grid Infrastructure InstallationNetwork Configuration in ClusterwareNetwork FailoverSecond NetworkSummary
Introduction to Cache FusionCache Fusion ProcessingGRDBL Resources and LocksPerformance AnalysisAnalysis of the Receiving SideRAC Wait EventsGC Current Block 2-Way/3-WayGC CR Block 2-Way/3-WayGC CR Grant 2-Way/Gc Current Grant 2-WayGC CR Block Busy/GC Current Block BusyGC CR Block Congested/GC Current Block CongestedPlaceholder Wait EventsSending-Side AnalysisBlock Types ServedGCS Log Flush SyncDefending LMS ProcessGC Buffer Busy Acquire/ReleaseUnique IndexesTable BlocksDRMOverview of DRM ProcessingDRM StagesGRD FreezeParametersChanges in 12cDRM and UndoTroubleshooting DRMAWR Reports and ADDMASH ReportsSummary
Resources and LocksSGA Memory AllocationResource TypesLock ModesLock-Related ViewsPluggable Databases (12c)Troubleshooting Locking ContentionEnqueue ContentionTX Enqueue ContentionTM Enqueue ContentionHW Enqueue ContentionDFS Lock HandleSV ResourcesCI ResourcesDFS Lock Handle SummaryLibrary Cache Locks/PinsTroubleshooting Library Cache Lock ContentionEnqueue Statisticsv$wait_chainsHanganalyzeDeadlocksLMD Trace File AnalysisSummary
OverviewPX Execution in RACPlacement of PX ServersMeasuring PX TrafficPX and Cache FusionPEMSParallelism Features and RACDebugging PX ExecutionIndex Creation in RACParallel DML in RACConcurrent Union Processing (12c)Partition-Wise JoinSummary
ConfigurationPre-Upgrade ChecklistInitiating an Oracle Clusterware UpgradeThe Importance of the Rootupgrade.sh ScriptPost-Upgrade TasksClusterware DowngradeDatabase UpgradeDeploying Manual Database UpgradePost-Database Upgrade StepsDatabase Upgrade Using the DBUADBUA AdvantagesDatabase DowngradeSummary
The Big PictureUpgrading to 11.2.0.2 or HigherDeploying RAC One Node BinariesDeploying a RAC One Node DatabaseSatisfying PrerequisitesInitiating DBCA’s Creation ProcessParameters Specific to RAC One NodeManaging RAC One Node DatabaseVerifying Configuration DetailsVerifying the Online Relocation StatusStop and Start the DatabasePerforming Online Database RelocationHandling Unplanned Node and Cluster RebootsConverting Between RAC One Node and Standard RACScaling Up to Standard RACScaling Down to RAC One NodeManaging RAC One Node with Cloud Control 12cDatabase Relocation with Cloud Control 12cThird-Party Cold Failover vs. RAC One NodeSummary