1z0-083: Oracle Database Administration II
Creating CDBs and Regular PDBs – Oracle Database: Managing Multitenant Architecture Ed 1
- Configure and create a CDB
- Create a new PDB from the CDB seed
- Explore the structure of PDBs
Manage CDBs and PDBs – Oracle Database: Managing Multitenant Architecture Ed 1
- 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 – Oracle Database: Managing Multitenant Architecture Ed 1
- Perform Backup and Recover CDBs and PDBs
- Duplicate an active PDB
- Duplicate a Database
Upgrading and Transporting CDBs and Regular PDBs – Oracle Database: Managing Multitenant Architecture Ed 1
- Upgrade an Oracle Database
- Transport Data
Manage Application PDBs – Oracle Database: Managing Multitenant Architecture Ed 1
- 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 – Oracle Database: Managing Multitenant Architecture Ed 1
- 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 – Oracle Database: Managing Multitenant Architecture Ed 1
- Restore and Recovering Databases with RMAN
- Perform CDB and PDB flashback
Backup Strategies and Terminology – Oracle Database: Backup and Recovery Workshop
- Perform Full and Incremental Backups and Recoveries
- Compress and Encrypt RMAN Backups
- Use a media manager
- Create multi-section backups of very 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 – Oracle Database: Backup and Recovery Workshop
- Employ the best Oracle Database recovery technology for your failure situation
- Describe and use Recovery technology for Crash, Complete, and Point-in-time recovry
Using Flashback Technologies – Oracle Database: Backup and Recovery Workshop
- Configure your Database to support Flashback
- Perform flashback operations
Duplicating a Database – Oracle Database: Backup and Recovery Workshop
- Duplicate Databases
Configuring and Using RMAN – Oracle Database: Backup and Recovery Workshop
- Configure RMAN and the Database for Recoverability
- Configureand Using an RMAN recovery catalog
Diagnosing Failures – Oracle Database: Backup and Recovery Workshop
- Detect and repair database and database block corruption
- Diagnosing Database Issues
Performing Recovery – Oracle Database: Backup and Recovery Workshop
- Restore and Recovering Databases with RMAN
- Perform Non RMAN database recovery
Transporting Data – Oracle Database: Backup and Recovery Workshop
- Transport Data
RMAN Troubleshooting and Tuning – Oracle Database: Backup and Recovery Workshop
- Interpret the RMAN message output
- Diagnose RMAN performance issues
Install Grid Infrastructure and Oracle Database – Oracle Database: Deploy, Patch and Upgrade Workshop
- Install Grid Infrastructure for a Standalone server
- Install Oracle Database software
Patching Grid Infrastructure and Oracle Database – Oracle Database: Deploy, Patch and Upgrade Workshop
- Patch Grid Infrastructure and Oracle Database
Upgrading to Oracle Grid Infrastructure – Oracle Database: Deploy, Patch and Upgrade Workshop
- Upgrade Oracle Grid Infrastructure
Oracle Database 18c: New Features – Oracle Database: Deploy, Patch and Upgrade Workshop
- Image and RPM based Database Installation
Creating an Oracle Database by using DBCA – Oracle Database: Deploy, Patch and Upgrade Workshop
- Create, Delete and Configure Databases using DBCA
Oracle Restart – Oracle Database: Deploy, Patch and Upgrade Workshop
- Configure and use Oracle Restart to manage components
Upgrade the Oracle Database – Oracle Database: Deploy, Patch and Upgrade Workshop
- Plan for Upgrading an Oracle Database
- Upgrade an Oracle Database
- Perform Post-Upgrade tasks
Install Grid Infrastructure for a Standalone server – Oracle Database: Deploy, Patch and Upgrade Workshop
- Rapid Home Provisioning
Using General Overall Database Enhancements – Oracle Database 19c: New Features for Administrators
- Install Oracle Database software
- Create, Delete and Configure Databases using DBCA
- Creating CDBs and Regular PDBs
- Use Miscellaneaous 19c New Features
Using Availability Enhancements – Oracle Database 19c: New Features for Administrators
- Use an RMAN recovery catalog
- Use Flashback Database
Using Diagnosibility Enhancements – Oracle Database 19c: New Features for Administrators
- Use new Diagnoseability Features
Monitoring and Tuning Database Performance – Oracle Database: Administration Workshop
- 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)
Tuning SQL Statements – Oracle Database: Administration Workshop
- Understanding The Oracle Optimizer
- Using The SQL Tuning Advisor
- Managing Optimizer Statistics
- Using The SQL Access Advisor
- Understanding The SQL Tuning Process