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:
- Gain comprehensive knowledge of Oracle Database architecture.
- Learn how to install, create, and manage Oracle Database 19c.
- Understand Database Administrator (DBA) tasks, assess and mitigate security-related issues, and safeguard data integrity.
- Grasp the concepts of backup and recovery, including configuring the database for recoverability and performing backup and recovery using RMAN (Recovery Manager).
- Acquire skills to monitor database performance and manage performance issues effectively.
- 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
Module 2: Oracle Software Installation Basics
- 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
Module 3: Installing Oracle Database Software
- System Requirements for Oracle Database
- Creating Operating System Groups and Users
- Types of Installations
Module 4: Creating an Oracle Database by Using DBCA
- 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)
Module 5: Managing the Database Instance
- 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
Module 6: Administering User Security
- Database User Accounts (overview)
- Predefined Administrative Accounts
- Creating a User
- Authentication
- Unlocking a User Account and Resetting the Password Privileges
- Roles Profiles
Module 7: Managing Database Storage Structures
- 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
Module 8: Managing Space
- 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
Module 9: Managing Undo Data
- 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
Module 10: Managing Data Concurrency
- Overview of Locks Locking Mechanism
- Data Concurrency DML Locks
- Enqueue Mechanism
- Lock Conflicts
Module 11: Backup and Recovery Concepts
- 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
Module 12: Backup and Recovery Configuration
- 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
Module 13: Performing Database Backups
- 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
Module 14: Performing Database Recovery
- 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
Module 15: Restore and Recovery Concepts
- Restoring and Recovering
- Instance Failure and Instance/Crash Recovery
- Media Failure
- Complete Recovery (Overview)
- Point-in-Time Recovery (Overview)
- Recovery Through RESETLOGS
Module 16: Performing Recovery-1
- 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
Module 17: Performing Recovery-2
- 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
Module 18: Moving Data
- Oracle Data Pump Architecture
- Oracle Data Pump Export Import
Module 19: Performing Database Maintenance
- 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
Module 20: Managing Performance
- 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!