Oracle Database 23ai: New Features for Administrators

Cui îi este dedicat cursul?

The Oracle Database 23c: New Features for Administrators Live Class is ideal for IT professionals looking to enhance their database administration skills with the latest updates.

• Database Administrators (DBAs)
• Senior Database Administrators
• Data Architects
• IT Managers
• Database Engineers
• Solution Architects
• System Administrators
• Technical Consultants
• Oracle Certified Professionals
• Cloud Database Administrators
• Database Developers
• IT Infrastructure Specialists
• Technical Support Engineers

Cunoștințe și abilități inițiale

To successfully undertake training in the Oracle Database 23c: New Features for Administrators Live Class course, students should meet the following prerequisites:

• Basic Knowledge of Oracle SQL and PL/SQL: A solid understanding of SQL and PL/SQL is essential as it will help you comprehend various database operations and scripting involved in the course.
• Experience with Oracle Database Administration: Familiarity with Oracle Database architecture, concepts, and administration tasks is highly recommended. This experience could come from previous courses or hands-on experience managing Oracle Databases.
• Experience with Oracle Database Backup and Recovery: Basic understanding and experience with Oracle Recovery Manager (RMAN) will be helpful, as the course involves database migration and backup concepts

Prezentarea cursului

This course covers the latest additions and improvements in Oracle Database 23ai. It equips Oracle Database Administrators with knowledge about enhanced tools for better management, focusing on performance, architecture, security, and database sharding. The topics include updates to Blockchain Tables, Data Migration with RMAN, Wide Tables, and Lock-Free Reservations.

Ce subiecte abordează cursul

• Oracle Clusterware
  Improve Monitoring and Auto Correct Resource States
  Typical Problems Applicable and Remedies
  Primary CRSD Hang
  Unmounted OCR Disk Group: Example
  ASM Listener Issue Affecting Flex ASM Functionality
  Detecting and Resolving Memory Leaks
  New crsctl Commands
  CVU Enhancements: Diagnostics, Fixups, Error Reporting
  Autonomous Health Framework (AHF) Repository
  Review of CHM and CHA
  CHM Improved Diagnosability
  New oclumon Commands: Example
  High-Level FPP Architecture 1-25
  FPP Archiving of Gold Images 1-26
   
• Oracle ASM
  On-Demand Scrubbing
   
• Oracle RAC
  Simplified Database Deployment
  Automatic PDB Resource Management
  PDB Placement Choice: Fill or Spread
  Ranking and CPU
  Failure Handling
  Configuring a PDB with Cardinality and Rank
  Oracle RAC Connection Management:
  Distribute Connections Based on Service Attribute
  Load Balancing Options in Oracle RAC
  Performance Considerations and Smart Connection Rebalance
  Testing Smart Connection Rebalance
  Outcome with and without Smart Connection Rebalance
  Index Block Contention
  Sequence Usage in Oracle RAC
  Right-Growing Index Optimizations
  Ordered Sequence Enhancement in Oracle RAC, 19c and 23ai
  Review of Buddy Recovery for Reconfiguration
  Smooth Reconfiguration
  Single-Server and Local Rolling Database Maintenance
  Patching Oracle RAC Database in Local Rolling Mode
  Oracle RAC Two-Stage Rolling Patches
   
• Oracle Data Guard
  Automatic Primary Database Preparation
  Creating a Temp File after PDB Creation
  Automatic Temp File Creation on the Standby Database
  DML on Active Data Guard
  Improved Performance of Redirected Transactions
  PL/SQL API for Data Guard Broker Management
  ORDS REST API for Data Guard Management
  Easier Checking of Data Guard Configurations, Fast-Start Failover Configurations
  Easier Tracking of Role Transitions
  Fast-Start Failover Lag Histogram
  Enhanced Observer Diagnostic
  Remote Snapshot Configuration for ADG Database
  Simplified AWR Snapshots on Active Data Guard
  Max Performance with / without Fast-Start Failover
  Automatic Failover with MaxPerformance
  Minimized Stall in Fast-Start Failover Maximum Performance
  Strict Validation of Switchover Readiness
  New Command: VALIDATE DGConnectIdentifier, SHOW|EDIT ALL MEMBERS
  Oracle Data Guard for Container Databases 5-5
  DGPDB Integration Enhancements 5-7
  Current Limitations in DGPDB
  DGPDB Implementation
  Two Primary CDBs
  Prepare Both CDBs for Data Guard
  Add the Broker Configurations
  Prepare the Configuration for DGPDB
  Add Target Pluggable Databases to Data Guard
  Add the PDBs to DGPDB
  Target Pluggable Databases Require Manual Copy
  Manual Copy
  Add the Standby Redo Logs to the Target PDBs
  The Apply Architecture
  Start the Redo Apply
  PDB Switchover 5-29
  DGPDB and Transparent Data Encryption
  Copy the TDE Encryption Keys