OCP 19c Oracle Database Administration II Exam:1Z0-083

Creating and Managing Oracle Multitenant Architecture: Learn to create CDBs (Container Databases) and Regular PDBs (Pluggable Databases) in Oracle Database. This covers the fundamental structure and management of multitenant environments.

CDB and PDB Management: Gain expertise in managing both CDBs and PDBs, including configuring PDB service names and connections, and ensuring startup, shutdown, and high availability. Explore different PDB modes and settings and understand their impact.

Performance Management in Oracle Databases: Discover techniques to control CDB and PDB resource usage using Oracle Resource Manager. Implement strategies for effective performance management and monitoring.

Backup and Recovery Strategies: Master backup and recovery procedures for CDBs and PDBs. Learn to perform full and incremental backups, utilize RMAN (Recovery Manager), and implement backup strategies including compression, encryption, and media management. Cover topics like multi-section backups, duplexed backups, and archival backups.

Database Cloning and Transport: Efficiently clone PDBs and application containers. Learn to transport data between databases and upgrade existing Oracle databases.

Application PDB Administration: Understand the purpose of the application root and application seed. Learn to define, create, install, upgrade, and patch application PDBs. Cover application PDB administration best practices.

Database Security in Multitenant Environments: Implement robust security management within multitenant databases. Learn to manage PDB lockdown profiles, audit users, and apply other security policies.

Recovery and Flashback Technologies: Utilize RMAN for restore and recovery. Understand and apply Flashback technologies for point-in-time recovery and data retrieval. Explore different recovery scenarios including crash, complete, and point-in-time recovery.

Database Duplication: Learn how to duplicate databases for testing, development, or disaster recovery purposes.

RMAN Configuration and Troubleshooting: Configure RMAN for optimal recoverability and learn to troubleshoot RMAN issues. Interpret RMAN output and diagnose performance bottlenecks.

Oracle Database Installation and Patching: Cover the process of installing Grid Infrastructure and Oracle Database on standalone servers. Learn to patch both Grid Infrastructure and the database. Explore upgrading Oracle Grid Infrastructure and the Oracle Database.

Oracle Database 18c & 19c New Features: Discover key new features introduced in Oracle Database 18c and 19c, including image and RPM-based installation, DBCA (Database Configuration Assistant) enhancements, and availability enhancements.

Oracle Restart Configuration: Configure and utilize Oracle Restart to manage database components and ensure high availability.

Database Performance Monitoring and Tuning: Learn to monitor database performance using tools like AWR (Automatic Workload Repository) and ADDM (Automatic Database Diagnostic Monitor). Understand wait events, sessions, and services. Master SQL tuning techniques, including using the SQL Tuning Advisor and understanding the Oracle Optimizer. Apply the performance tuning methodology for optimal database performance.

Memory Management: Understand memory components and their configuration within the Oracle Database.

Advanced 19c Features: Explore advanced features in Oracle Database 19c such as availability enhancements, diagnosability enhancements, and miscellaneous new features.