Sumário Itens Encontrados: 293Chapter 1: Overview of Oracle RACHigh 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 NotChapter 2: Clusterware Stack Management and TroubleshootingClusterware 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 UtilitiesCHMChapter 3: RAC Operational PracticesWorkload 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 CachingChapter 4: New Features in RAC 12cOracle 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 Overview12cR1: 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 FeaturesChapter 5: Storage and ASM PracticesStorage 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 ASMCAChapter 6: Application Design IssuesLocalized InsertsExcessive TRUNCATE or DROP StatementsSequence CacheFreelists and ASSMExcessive CommitsLong Pending TransactionsLocalized AccessSmall Table UpdatesIndex DesignInefficient Execution PlanExcessive Parallel ScansFull Table ScansApplication AffinityPipesApplication Change DeploymentChapter 7: Managing and Optimizing a Complex RAC EnvironmentShared vs. Non-Shared Oracle HomesServer PoolsTypes of Server PoolsSystem-Defined Server PoolsUser-Defined Server PoolsCreating and Managing Server PoolsPlanning and Designing RAC 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 TuningChapter 8: Backup and Recovery in RACRMAN 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 recoveryChapter 9: Network PracticesTypes 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 NetworkChapter 10: RAC Database OptimizationIntroduction 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 ReportsChapter 11: Locks and DeadlocksResources and LocksSGA Memory AllocationResource TypesLock ModesLock-Related ViewsPluggable Databases (12c)Troubleshooting Locking ContentionEnqueue ContentionTX Enqueue ContentionTM Enqueue ContentionHW Enqueue ContentionDFS Lock HandleSV ResourcesCI ResourcesLibrary Cache Locks/PinsTroubleshooting Library Cache Lock ContentionEnqueue Statisticsv$wait_chainsHanganalyzeDeadlocksLMD Trace File AnalysisChapter 12: Parallel Query in RACOverviewPX 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 JoinChapter 13: Clusterware and Database UpgradesConfigurationPre-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 DowngradeChapter 14: RAC One NodeThe 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 Node