Oracle DBA 21c

Learn complete Oracle Multitenant Database Administration 21c

Oracle DBA 21c

What you’ll learn

  • Oracle Architecture.
  • InstallationOfOracleLinux8OnOracleVM.
  • Practice 1 Creating a CDB.
  • Practice 2 Creating PDBs from the Seed.
  • Practice 3 Performing Basic CDB Administration Tasks.
  • Practice 4 Managing Common and Local Users.
  • Practice 5 Backup and Recovery in CDB and PDBs.
  • Practice 6 Flashback and Point-in-time Recovery.

Course Content

  • Introduction –> 1 lecture • 1min.
  • Oracle-21c-Architecture –> 1 lecture • 5min.
  • InstallationOfOracleLinux8OnOracleVM –> 1 lecture • 22min.
  • Practice 1 Creating a CDB –> 1 lecture • 44min.
  • Practice 2 Creating PDBs from the Seed –> 1 lecture • 21min.
  • Practice 3 Performing Basic CDB Administration Tasks –> 1 lecture • 33min.
  • Practice 4 Managing Common and Local Users –> 1 lecture • 43min.
  • Practice 5 Backup and Recovery in CDB and PDBs –> 1 lecture • 38min.
  • Practice 6 Flashback and Point-in-time Recovery –> 1 lecture • 42min.

Auto Draft

Requirements

  • Database concept.

Oracle DBA 21c

 

This course is about Oracle 21c DBA. Oracle 21c is the latest database software from Oracle and it’s a innovation release which means it has shorter support life span. Oracle 21 c is the first release of oracle database with CDB only option. You can not create a non-CBD database in Oracle 21c. In this course we will be doing hands on practice sessions with the following:-

 

Oracle Architecture

InstallationOfOracleLinux8OnOracleVM

Practice 1 Creating a CDB

Practice 2 Creating PDBs from the Seed

Practice 3 Performing Basic CDB Administration Tasks

Practice 4 Managing Common and Local Users

Practice 5 Backup and Recovery in CDB and PDBs

Practice 6 Flashback and Point-in-time Recovery

 

Oracle Database 21c is the latest innovation release of world’s most popular database. Oracle Database 21c is now available on Oracle cloud and on-premises for linux including Exadata.

You can directly upgrade to Oracle Database 21c from the following releases:
– Oracle Database 19c
– Oracle Database 18c
– Oracle Database 12c Release 2 (12.2)

Top New features in Oracle Database 21c:

 

– Blockchain Tables

– Immutable Tables
– Oracle Machine Learning- Native JSON Datatype- SQL Macros- In database JavaScript execution- Compare explain plans / cursors

We all should be aware that Innovation Releases have shorter support windows than Long Term Releases such as Oracle Database 19c.

Oracle Database Innovation Releases include many enhancements and new capabilities which will be included in the next Long Term Release. Oracle Database Innovation Releases does not have extended support. As Oracle Database 21c is also an innovation release, which means it will only have 2 years of premium support.

Oracle Database Long Term Releases usually have 5 years of Premier Support followed by 3 years of Extended Support. Personally I would not like to upgrade my production servers to an innovation release (Oracle Database 21c). I would like to upgrade (or stay with my Oracle Database Server with Oracle Database 19c which has Premier Support till April 30, 2024 and after that Extended Support will start for Oracle Database 19c.

 

Get Tutorial