Oracle Database 19c Administration II (Oracle DBA II)

Creating CDBs and Regular PDBs
· Configure and create a CDB
· Create a new PDB from the CDB seed
· Explore the structure of PDBs
 
Manage CDBs and PDBs
· Manage PDB service names and connections
· Manage startup, shutdown and availability of CDBs and PDBs
· Change the different modes and settings of PDBs
· Evaluate the impact of parameter value changes
· Performance management in CDBs and PDBs
· Control CDB and PDB resource usage with the Oracle Resource Manager
 
Backup and Duplicate
· Perform Backup and Recover CDBs and PDBs
· Duplicate an active PDB
· Duplicate a Database
 
Upgrading and Transporting CDBs and Regular PDBs
· Upgrade an Oracle Database
· Transport Data
 
Backup Strategies and Terminology
· Perform Full and Incremental Backups and Recoveries
· Compress and Encrypt RMAN Backups
· Use a media manager
· Create multi-section backups of exceptionally large files
· Create duplexed backup sets
· Create archival backups
· Backup of recovery files
· Backup non database files
· Back up ASM meta data
 
Restore and Recovery Concepts
· Employ the best Oracle Database recovery technology for your failure situation
· Describe and use Recovery technology for Crash, Complete, and Point-in-time recovery
 
Using Flashback Technologies
· Configure your Database to support Flashback
· Perform flashback operations
 
Duplicating a Database
 
Install Grid Infrastructure and Oracle Database
· Install Grid Infrastructure for a Standalone server
· Install Oracle Database software
 
Patching Grid Infrastructure and Oracle Database
 
Upgrading to Oracle Grid Infrastructure
 
Oracle Database 18c: New Features
· Image and RPM based Database Installation
 
Using General Overall Database Enhancements
· Install Oracle Database software
· Create, Delete and Configure Databases using DBCA
· Creating CDBs and Regular PDBs
· Use Miscellaneous 19c New Features
 
Monitoring and Tuning Database Performance
· Managing Memory Components
· Understanding the Automatic Workload Repository (AWR)
· Understanding the Advisory Framework
· Monitoring Wait Events, Sessions, and Services
· Managing Metric Thresholds and Alerts
· Understanding and Using the Performance Tuning Methodology
· Performing Performance Planning
· Understanding the Automatic Database Diagnostic Monitor (ADDM)
 
Manage Application PDBs
· Explain the purpose of application root and application seed
· Define and create application PDBs
· Install, upgrade and Patch applications
· Create and administer Application PDBS
· Clone PDBs and Application containers
· Plug and unplug operations with PDBs and application containers
· Comparing Local Undo Mode and Shared Undo Mode
 
Manage Security in Multitenant databases
· Manage Security in Multitenant databases
· Manage PDB lockdown profiles
· Audit Users in CDBs and PDBs
· Manage other types of policies in application containers
 
Recovery and Flashback
· Restore and Recovering Databases with RMAN
· Perform CDB and PDB flashback
 
Configuring and Using RMAN
· Configure RMAN and the Database for Recoverability
· Configure and Using an RMAN recovery catalog
 
Diagnosing Failures
· Detect and repair database and database block corruption
· Diagnosing Database Issues
 
Performing Recovery
· Restore and Recovering Databases with RMAN
· Perform Non RMAN database recovery
 
Transporting Data
 
RMAN Troubleshooting and Tuning
· Interpret the RMAN message output
· Diagnose RMAN performance issues
 
Creating an Oracle Database by using DBCA
· Create, Delete and Configure Databases using DBCA
 
Oracle Restart
· Configure and use Oracle Restart to manage components
 
Upgrade the Oracle Database
· Plan for Upgrading an Oracle Database
· Upgrade an Oracle Database
· Perform Post-Upgrade tasks
 
Install Grid Infrastructure for a Standalone server
· Rapid Home Provisioning
 
Using Availability Enhancements
· Use an RMAN recovery catalog
· Use Flashback Database
 
Tuning SQL Statements
· Understanding the Oracle Optimizer
· Using the SQL Tuning Advisor
· Managing Optimizer Statistics
· Using the SQL Access Advisor
· Understanding the SQL Tuning Process