+1 (778) 681-0711

Oracle Database 19c: Administrator & Backup and Recovery Concept.

Duration : 5 Days (40 Hours)

Oracle Database 19c: Administrator & Backup and Recovery Concept. Course Overview:

The Oracle Database 19c: Administrator & Backup and Recovery Concept certification is designed to enhance comprehension of essential database principles, the responsibilities of a Database Administrator, and the backup and recovery procedures specific to Oracle 19c. This certification validates the skills necessary for effectively managing and maintaining enterprise-level databases, assuring employers of an individual’s expertise in Oracle databases.

Highly valued by IT industries that prioritize both efficiency and security, this certification signifies proficiency in devising backup strategies, implementing recovery techniques, and utilizing the Database Recovery Advisor. It serves as a solid foundation for mastering database technology and plays a crucial role in upholding a resilient and robust Oracle environment.

Intended Audience:

  • Database administrators seeking advanced knowledge
  • IT professionals working with Oracle Database 19c
  • Individuals interested in backup and recovery concepts
  • Tech enthusiasts wanting to enhance Oracle skills
  • Information Systems students or graduates.

Learning Objectives of Oracle Database 19c: Administrator & Backup and Recovery Concept.:

The learning objectives of the Oracle Database 19c: Administrator & Backup and Recovery Concept course are as follows:

  1. Gain comprehensive knowledge of Oracle Database architecture.
  2. Learn how to install, create, and manage Oracle Database 19c.
  3. Understand Database Administrator (DBA) tasks, assess and mitigate security-related issues, and safeguard data integrity.
  4. Grasp the concepts of backup and recovery, including configuring the database for recoverability and performing backup and recovery using RMAN (Recovery Manager).
  5. Acquire skills to monitor database performance and manage performance issues effectively.
  6. Enhance practical technical skills through hands-on practice sessions.
 Module 1: Exploring the Oracle Database Architecture
  • Oracle Database Architecture: Overview
  • Oracle Database Instance Configurations
  • Connecting to the Oracle Database Instance
  • Oracle Database Memory Structures (overview)
  • Process Architecture
  • Process Structures
  • Process Startup Sequence
  • Database Storage Architecture
  • Planning Your Installation
  • Configuring Oracle Linux with Oracle RDBMS
  • Pre-Install RPM Operating System Groups and Users
  • Environment Variables
  • Configuring the Oracle Software Owner Environment Using Oracle Universal Installer (OUI)
  • Installation Option: Silent Mode
  • System Requirements for Oracle Database
  • Creating Operating System Groups and Users
  • Types of Installations
  • Planning the Database Storage Structure
  • Types of Databases (based on workload)
  • Choosing the Appropriate Character Set
  • Understanding How Character Sets Are Used
  • Setting the NLS_LANG Initialization Parameter
  • Using the Database Configuration Assistant (DBCA)
  • Initialization Parameter Files
  • Starting an Oracle Database Instance
  • Shutting Down an Oracle Database Instance
  • Viewing Log Files
  • Using Trace Files
  • Using the Dynamic Performance Views
  • Data Dictionary
  • Database User Accounts (overview)
  • Predefined Administrative Accounts
  • Creating a User
  • Authentication
  • Unlocking a User Account and Resetting the Password Privileges
  • Roles Profiles
  • Understanding Storage of Data Database Block contents
  • Exploring the Storage Structure
  • Creating a New Tablespace
  • Overview of Tablespaces Created by Default Managing Tablespaces
  • Viewing Tablespace Information Using Oracle Managed Files
  • Space Management Overview
  • Block Space Management Row Chaining and Migration
  • Free Space Management Within Segments Types of Segments
  • Allocating Extents Allocating Space
  • Creating Tables Without Segments
  • Undo Data Overview
  • Transactions and Undo Data
  • Storing Undo Information
  • Comparing Undo Data and Redo Data Managing Undo
  • Configuring Undo Retention Guaranteeing Undo Retention
  • Changing an Undo Tablespace to a Fixed Size
  • Overview of Locks Locking Mechanism
  • Data Concurrency DML Locks
  • Enqueue Mechanism
  • Lock Conflicts
  • Categories of Failures Flashback Technology
  • Understanding Instance Recovery
  • Phases of Instance Recovery Tuning Instance Recovery
  • Using the MTTR Advisor
  • Comparing Complete and Incomplete Recovery
  • Oracle Data Protection Solutions
  • Configuring for Recoverability
  • Configuring the Fast Recovery Area
  • Multiplexing the Control File
  • Online Redo Log File
  • Multiplexing Online Redo Log File
  • Multiplexing Archived Redo Log Files
  • Archiver Process
  • Archived Redo Log File Naming and Destinations
  • Backup Solutions Overview
  • Oracle Secure Backup (overview)
  • User Managed Backup (overview)
  • Backup Terminology and Types of Backups
  • Using Recovery Manager (RMAN)
  • Configuring Backup Settings
  • Oracle-Suggested Backup
  • Backing Up the Control File to a Trace File
  • Data Recovery Advisor
  • Loss of a Control File
  • Loss of a Redo Log File
  • Loss of a Datafile in NOARCHIVELOG Mode
  • Loss of a Noncritical Datafile in ARCHIVELOG Mode
  • Loss of a System-Critical Datafile in ARCHIVELOG Mode
  • Restoring and Recovering
  • Instance Failure and Instance/Crash Recovery
  • Media Failure
  • Complete Recovery (Overview)
  • Point-in-Time Recovery (Overview)
  • Recovery Through RESETLOGS
  • RMAN Recovery in NOARCHIVELOG Mode
  • Performing Complete Recovery (of critical and noncritical data files)
  • Restoring ASM Disk Groups
  • Recovery with Image Files
  • Performing Point-in-Time (PITR) or Incomplete Recovery
  • Table Recovery from Backups
  • Recovery of Server Parameter File, Control File
  • Redo Log File Loss and Recovery
  • Password Authentication File Re-creation
  • Index, Read-Only Tablespace, and Tempfile Recovery
  • Restoring the Database to a New Host
  • Disaster Recovery
  • Restoring RMAN Encrypted Backups
  • Oracle Data Pump Architecture
  • Oracle Data Pump Export Import
  • Database Maintenance (overview)
  • Viewing the Alert History Terminology
  • Automatic Workload Repository (AWR) Statistic Levels
  • Automatic Database Diagnostic Monitor (ADDM)
  • Advisory Framework
  • Enterprise Manager and Advisors
  • Performance Monitoring Tuning Activities
  • Performance Planning Instance Tuning
  • Performance Tuning Methodology
  • Performance Tuning Data Monitoring
  • Performance Managing Memory

Oracle Database 19c: Administrator & Backup and Recovery Concept. Course Prerequisites:

• Basic understanding of relational database concepts
• Familiarity with Oracle Database architecture
• Knowledge on managing Oracle Database instances
• Prior experience in database backup and recovery
• Understanding of the SQL language
• Foundations in system administration
• Proficiency implementing and maintaining Oracle 19c databases.

Discover the perfect fit for your learning journey

Choose Learning Modality

Live Online

  • Convenience
  • Cost-effective
  • Self-paced learning
  • Scalability

Classroom

  • Interaction and collaboration
  • Networking opportunities
  • Real-time feedback
  • Personal attention

Onsite

  • Familiar environment
  • Confidentiality
  • Team building
  • Immediate application

Training Exclusives

This course comes with following benefits:

  • Practice Labs.
  • Get Trained by Certified Trainers.
  • Access to the recordings of your class sessions for 90 days.
  • Digital courseware
  • Experience 24*7 learner support.

Got more questions? We’re all ears and ready to assist!

Request More Details

Please enable JavaScript in your browser to complete this form.

Subscribe to our Newsletter

Please enable JavaScript in your browser to complete this form.
×