Oracle RAC 12c Training in Chennai SQLSTAR Global
Oracle Database 12c: RAC Administration Ed 1
Duration: 5 Days
What you will learn
This Oracle Database 12c: RAC Administration training will teach you about Oracle RAC database architecture. Expert Oracle University instructors will deep dive into Global
Resources and Cache Fusion.
- Administer ASM files, directories, templates, and disk groups. Manage
- Install Oracle RAC software. Create cluster databases.
- Administer both administrator and policy-managed Oracle RAC databases.
- Monitor and address performance issues.
- Learn about services in a RAC environment as well as highly available connection
features including Application Continuity and Transaction Guard.
- Create and administer a RAC One Node Database.
- Create and manage multitennant RAC databases.
Benefits to You
Ensure fast, reliable, secure and easy to manage performance. Optimize database
workloads, lower IT costs and deliver a higher quality of service by enabling consolidation
onto database clouds.
Modify initialization parameters in a RAC environment Perform post-database-creation tasks Configure RMAN for the RAC environment Describe the benefits of Oracle RAC Explain the necessity of global resources Configure the RAC database to use ARCHIVELOG mode and the fast recovery area Convert a single-instance Oracle Database to RACs Create a cluster database a in an understanding of the Oracle Database Define redo log files in a RAC environment Define undo tablespaces in a RAC environment Describe global cache coordination Describe how Grid Plug and Play affects Clusterware Describe the Oracle Clusterware architecture Explain the principles and purposes of clusters Install the Oracle Database software
Overview of Oracle Architecture
Oracle ASM Instance Administration
ASM Instance AdministrationInstance ParametersASM_DISKGROUPSAdjusting ASM Instance Parameters in SPFILEsInstance Startup and ShutdownRelevant V$Views
Administering ASM Disk Groups
ASM Disk Group OverviewDisk Group AttributesCompatibility AttributesDisk Group ManagementDisk Group MetadataViewing Connected ClientsDisk Group RebalanceASM Fast Mirror Resync
Administering ASM Files, Directories, and Templates
Interaction Between Database Instances and ASMAccessing ASM FilesFully Qualified ASM File NamesASM File CreationView ASM Aliases, Files, and DirectoriesASM Directories OverviewManaging ASM DirectoriesManaging Alias File Names
Grid Infrastructure Overview and Review
What is a Cluster?What is a Flex ClusterClusterware CharacteristicsOracle ClusterwareHardware and Software Concepts (High level)RAC Databases Overview & ArchitectureOverview of Oracle RACRAC One NodeCluster-Aware Storage SolutionsBenefits of Using RACScaleup and SpeedupI/O Throughput BalancedGlobal ResourcesRAC and Flex ASM
Installing and Configuring Oracle RAC
Installing the Oracle Database SoftwareInstallation optionsCreating the Cluster DatabasePost-installation TasksSingle Instance to RAC ConversionCleaning Up Unsuccessful Installs
Oracle RAC Administration
Parameters and RAC - SPFILE, Identical and Unique ParametersInstance Startup, Shutdown and QuiesceUndo Table spacesRedo ThreadsUse Enterprise Manager Cluster Database PagesRAC AlertsRAC Metrics
Managing Backup and Recovery for RAC
Overview of Upgrades and Patching Release and Patch SetUpgrades PSU, CPU and Interim Patches Merge PatchesPerforming Out Of Place Database Upgrades Planning and Preparing for UpgradePerforming Out of Place Release Install or Upgrade Post Upgrade Tasks
RAC Backup and Recovery
Instance Failure And Recovery In RAC - LMON and SMON Redo Threads and ArchiveLog Configurations and Admin Parameter Settings Affecting Parallel Recovery andMTTR Instance Failure And Recovery In RAC - LMON and SMON RAC and the FastRecovery AreaRMAN ConfigurationRMAN Admin For RAC: Channels, Instances, Backup Distribution RMAN Restore And Recovery RAC Considerations
RAC Global Resource Management and Cache Fusion
Globally Manage d Resources and ManagementLibrary Cache ManagementRow cache managementBuffer cache fusionBuffer Cache Management RequirementsAccessing single blocks in RACMulti-block read considerations in RACUndo and read consistency considerations in RAC
RAC Database Monitoring and Tuning
OCPU and Wait Time LatenciesWait Events for RACCommon RAC TuningSession and System StatisticsRAC specific V$ ViewsAutomatic Database Diagnostic Monitor for RAC
Managing High Availability of Services in a RAC Environment
Oracle ServicesServices for Policy - and Administrator-Manage d Databases CreatingServicesManaging ServicesUse Services with Client Applications Services and ConnectionLoad Balancing Services and Transparent Application FailoverServices and the Resource Manager
Managing High Availability of Connections
Types of Workload DistributionClient-Side Load BalancingServer-Side Load BalancingRuntime Connection Load Balancing and Connection PoolsFast Application NotificationThe Load Balancing Advisory FAN EventServer-Side CalloutsConfiguring the Server-Side ONS
What is AC?What problem does it solve?Benefits of ACHow AC worksAC ArchitectureSide EffectsRestrictionsApplication requirements
RAC One Node
RAC One Node Concepts Online database migrationAdding Oracle RAC One Node Database to an Existing Cluster Convert anOracle RAC One Node database to a RAC database Convert an Oracle RAC database to a RAC One Node databaseUse DBCA to convert a single instance database to a RAC One Node database
Multitenant Architecture and RAC
Non-CDB ArchitectureMultitenant Architecture: BenefitsCDB in a Non-RAC EnvironmentContainersTerminology and Data Dictionary ViewsConnection to a Non-RAC CDBOracle RAC and Multitenant ConfigurationOracle RAC and Multitenant Architecture
Quality of Service Management
QOS Management conceptsDescribe the benefits of using QoS Management QoS Management componentsQoS Management functionality