Oracle 19c DBA

• Describe the differences in Oracle Database editions, options, and packs
• List the database offerings in Oracle Cloud
• Explain the sample database that will be used in the course practices

• List the major architectural components of Oracle Database
• Explain memory structures
• Describe background processes 
• Correlate logical and physical storage structures
• Describe multitenant architecture

• Connect to an Oracle Database
• Describe the tools used to access an Oracle Database
• Describe the Oracle-supplied user accounts for Oracle Database
• Query the data dictionary in an Oracle Database

• Describe initialization parameter files and initialization parameters
• View and modify initialization parameters in SQL*Plus
• Start up and shut down Oracle databases
• Open and close PDBs
• Work with the Automatic Diagnostic Repository (ADR)
• Query dynamic performance views

• Describe Oracle Net Services
• Explain how listeners work
• Configure listeners for dynamic or static service registration
• Configure local naming for database connections
• Test Oracle Net connectivity with tnsping
• Configure communication between databases by creating database links
• Explain the difference between dedicated and shared server configurations

• Create database users
• Grant privileges to database users
• Create and grant roles to users or other roles
• Revoke privileges and roles from users and other roles
• Create and assign profiles to users
• Explain the various authentication options for users
• Assign quota to users
• Apply the principle of least privilege

• Describe the methods and tools used to create PDBs
• Create PDBs from seed by using SQL*Plus
• Clone PDBs by using SQL*Plus
• Unplug and plug in PDBs by using SQL*Plus
• Drop PDBs by using SQL*Plus

Explain how table data is stored in the database

• Use SQL*Plus to:

   Create and drop tablespaces

   Alter tablespaces

   View tablespace information

• Implement Oracle Managed Files (OMF)
• Use SQL*Plus to move and rename online data files
• Implement tablespace encryption

• Describe how the Oracle Database server automatically manages space
• Save space by using compression
• Proactively monitor and manage tablespace space usage
• Describe segment creation in the Oracle database
• Control deferred segment creation
• Reclaim wasted space from tables and indexes by using the segment shrink functionality
• Manage resumable space allocation

• Explain DML and undo data generation
• Monitor and administer undo data
• Describe the difference between undo data and redo data
• Configure undo retention
• Guarantee undo retention
• Enable temporary undo
• Use the Undo Advisor

• Describe ways to move data
• Explain the general architecture of Oracle Data Pump
• Use Data Pump Export and Import to move data between Oracle databases
• Use SQL*Loader to load data from a non-Oracle database (or user files)
• Use external tables to move data via platform-independent files
• Describe methods that can be used to migrate databases to Oracle Database Cloud Service

Identify DBA responsibilities regarding database backup and recovery

Identify the types of failure that can occur in an Oracle database

Describe instance recovery

Describe complete and incomplete recovery

• About Configuring the Environment for RMAN Backups
• Configuring the Fast Recovery Area
• Multiplex the control file
• Multiplex redo log files
• Configure ARCHIVELOG mode
• Configuring the Backup Retention Policy
• Backup Optimization and the CONFIGURE command
• Configuring an Archived Redo Log Deletion Policy

• Overview of the RMAN Environment
• Starting RMAN and Connecting to a Database
• Showing the Default RMAN Configuration
• Backing Up a Database
• Reporting on RMAN Operations
• Maintaining RMAN Backups
• Diagnosing and Repairing Failures with Data Recovery Advisor
• Rewinding a Database with Flashback Database
• Restoring and Recovering Database Files

• About the RMAN Environment
• About RMAN Command-Line Client
• About RMAN Channels
• About the RMAN Repository
• About Media Management Using RMAN
• About the Fast Recovery Area
• About RMAN in a Data Guard Environment
• About RMAN in a Recovery Appliance Environment

• About Consistent and Inconsistent RMAN Backups
• About Online Backups and Backup Mode
• About Backup Sets
• About RMAN Image Copies
• About Multiple Copies of RMAN Backups
• About RMAN Control File and Server Parameter File Autobackups
• About RMAN Incremental Backups
• About Backup Retention Policies

• Overview of RMAN Backups
• Specifying Backup Output Options
• Backing Up Database Files with RMAN
• Backing Up CDBs and PDBs
• Backing Up Application Containers
• Backing Up Sparse Databases with RMAN
• Backing Up Archived Redo Logs with RMAN
• Making and Updating RMAN Incremental Backups
• Making Database Backups for Long-Term Storage
• Backing Up RMAN Backups

• Create consistent database backups
• Back up your database without shutting it down
• Create incremental backups

• Overview of the RMAN Recovery Catalog
• Creating a Recovery Catalog
• Registering a Database in the Recovery Catalog
• Cataloging Backups in the Recovery Catalog
• Creating and Managing Virtual Private Catalogs
• Protecting the Recovery Catalog
• Managing Stored Scripts
• Maintaining a Recovery Catalog
• Dropping a Recovery Catalog

• Determine the need for performing recovery
• Describe and use available options, such as Recovery Manager (RMAN) and the Data Recovery Advisor
• Recover data files
• Restore and recover a DBCS database

• Overview of Complete Database Recovery
• Preparing for Complete Database Recovery
• Performing Complete Database Recovery
• Performing Complete Recovery of CDBs
• Performing Complete Recovery of Application Containers
• Performing Complete Recovery of Sparse Databases with RMAN

• Overview of RMAN TSPITR
• TSPITR Restrictions, Special Cases, and Limitations
• Planning and Preparing for TSPITR
• Running RMAN TSPITR:

       – Performing Fully Automated RMAN TSPITR

       – Overriding Defaults for RMAN TSPITR with an RMAN-Managed Auxiliary Database

       – Performing RMAN TSPITR Using Your Own Auxiliary Database

• Troubleshooting RMAN TSPITR

• Overview of Recovering Tables and Table Partitions from RMAN Backups
• Preparing to Recover Tables and Table Partitions
• Recovering Tables and Table Partitions
• Recovering Tables and Table Partitions in PDBs
• Examples: Recovering Tables and Table Partitions From RMAN Backups

• Understand flashback technologies from various types of errors
• Configure your database to use flashback technologies
• Perform flashback query, version query, transaction backout
• Perform flashback table, recyclebin, flashback data archive

• Describe Flashback Database architecture
• Configure your database to support Flashback Database

• List the purposes and create duplicate database with RMAN
• Duplicate a database based on a running instance

• Describe the activities that you perform to manage database performance
• Use Enterprise Manager Database Express and performance views to monitor database instance performance
• Describe the Oracle performance tuning methodology
• Describe the server statistics and metrics that are collected by the Oracle Database server
• Configure and monitor memory components for optimal performance

• Describe the SQL tuning methodology
• Manage optimizer statistics
• Use SQL Tuning Advisor to identify and tune SQL statements that are using the most resources
• Use SQL Access Advisor to tune a workload