Oracle Database 23ai: High Availability New Features

Asseco Academy » Training » Oracle Database 23ai: High Availability New Features

Training D1106068GC10

Oracle Database 23ai: High Availability New Features

IT Solutions Oracle Database Oracle

Accreditation

Training

Price of training from PLN 5,225 ^net

Lowest price in the last 30 days: PLN 5,225 ^net

Language: polish

*the price depends, among others on the form of training and the date

Download PDF

Additional products

No additional books or exams are specified for this training.

Czas trwania: 16h dydaktycznych

materiały szkoleniowe w języku angielskim

Training description

This course covers the latest improvements and enhancements in the high availability area of Oracle Database 23ai. It equips Oracle Database Administrators with new capabilities and enhancements for Clusterware, ASM, RAC, Data Guard, and Diagnosability. With hands-on practices, you'll be be able to reinforce the learning of the new high availability features and capabilities of Oracle Database 23ai. This course is targeted at Database Administrators, Oracle Grid Infrastructure Administrators, Oracle RAC Administrators, Data Guard Administrators, and Database Architects

Scope

Oracle Clusterware

Objectives

Improve Monitoring and Auto Correct Resource States

Typical Problems Applicable and Remedies

Primary CRSD Hang: Example

Unmounted OCR Disk Group: Example

ASM Listener Issue Affecting Flex ASM Functionality: Example

Detecting and Resolving Memory Leaks: Example

New crsctl Commands: Example

CVU Enhancements: Diagnostics

CVU Enhancements: Fixups

CVU Enhancements: Error Reporting

Autonomous Health Framework (AHF) Repository

Review of CHM and CHA

CHM Improved Diagnosability

New oclumon Commands: Example

FPP Overview: Background

High-Level FPP Architecture

FPP Archiving of Gold Images

Summary

Oracle ASM

Objectives

On-Demand Scrubbing: Background

Extent-Based Scrubbing

Summary

Oracle RAC

Objectives

Simplified Database Deployment

Automatic PDB Resource Management

PDB Placement Choice: Fill or Spread

Ranking and CPU

Rank and CPU: Startup Order

Failure Handling

Last Node Standing

Configuring a PDB with Cardinality and Rank: Example

Oracle RAC Connection Management: Overview

Distribute Connections Based on Service Attribute

Load Balancing Options in Oracle RAC: Example

Performance Considerations

Smart Connection Rebalance

Testing Smart Connection Rebalance: Example

Outcome without Smart Connection Rebalance: Example

Outcome with Smart Connection Rebalance: Example

Index Block Contention: Background

Sequence Usage in Oracle RAC

Right-Growing Index Optimizations

Ordered Sequence Enhancement in Oracle RAC

Ordered Sequence Optimization in 19c: Example

Ordered Sequence Optimization in 23ai: Example

Review of Buddy Recovery for Reconfiguration

Smooth Reconfiguration

Single-Server Rolling Database Maintenance: Overview

Local Rolling Database Maintenance: Overview

Patching Oracle RAC Database in Local Rolling Mode: Example

Oracle RAC Two-Stage Rolling Patches: Overview

Summary

Oracle Data Guard Part 1

Objectives

Oracle Active 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

Easier Checking of 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 without Fast-Start Failover

Max Performance with Fast-Start Failover

Automatic Failover with MaxPerformance

Minimized Stall in Fast-Start Failover Maximum Performance

Choose the Lag Type for Maximum Performance Mode

Strict Validation of Switchover Readiness

New Command: VALIDATE DGConnectIdentifier

New Commands: SHOW|EDIT ALL MEMBERS

Summary

Oracle Data Guard Part 2

Objectives

Traditional Per-CDB Data Guard Architecture

Oracle Data Guard for Container Databases

Data Guard Per PDB (DGPDB)

DGPDB Integration Enhancements

Current Limitations in DGPDB

DGPDB Implementation: Overview

Two Primary CDBs

Prepare Both CDBs for Data Guard

Set Up the Passwords in the Wallet

Two Data Guard Configurations

Add the Broker Configurations

Internal Communication between CDBs

Prepare the Configuration for DGPDB

Add Target Pluggable Databases to Data Guard

Check the PDBs Before Adding Them

Add the PDBs to DGPDB

Target Pluggable Databases Require Manual Copy

Manual Copy: Example with scp on File System

Manual Copy: Example with RMAN and ASM

Transport Architecture

Add the Standby Redo Logs to the Target PDBs

The Apply Architecture

Start the Redo Apply

Show the Status of the PDBs

PDB Switchover

DGPDB and Transparent Data Encryption

Copy the TDE Encryption Keys

Application Continuity: Overview

Use Cases

What is Hybrid Data Guard?

Hybrid DR Configurations: Challenges

Possible Solutions

How to Use It: Examples

Summary

Training schedule

Remote

… if you value the opportunity to learn with a trainer and other participants, from anywhere without having to commute.

Stationary

… if you want to learn while sitting in the same room with the trainer and other participants.

Online

… if you want to learn from materials available via the interenet anywhere at any time

Filters:

Date guarantee

location:

Training: D1106068GC10

Oracle Database 23ai: High Availability New Features

Currently, there is no trainings in the selected form.

Filters:

Date guarantee

location:

Training: D1106068GC10

Oracle Database 23ai: High Availability New Features

Currently, there is no trainings in the selected form.

Filters:

Date guarantee

form:

Training: D1106068GC10

Oracle Database 23ai: High Availability New Features

Currently, there is no trainings in the selected form.

Szukasz szkolenia w innym terminie?

Co nowego?

Newest
Uncategorized

Dołącz do Membership

Cykl online’owych spotkań, podczas których przybliżamy nowe kierunki rozwoju metod zarządzania usługami IT, jak również najciekawsze zagadnienia obszaru programowania, zarządzania Read more

Jak ugryźć innowacyjność

Cykl online’owych spotkań, podczas których przybliżamy nowe kierunki rozwoju metod zarządzania usługami IT, jak również najciekawsze zagadnienia obszaru programowania, zarządzania Read more

Nowoczesne metody supportu – testowy wpis

Cykl online’owych spotkań, podczas których przybliżamy nowe kierunki rozwoju metod zarządzania usługami IT, jak również najciekawsze zagadnienia obszaru programowania, zarządzania Read more

Chcesz z nami porozmawiać?

Zadzwoń do nas: tel. 801 30 30 30