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

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