Overview

Are you ready to prepare for the 1Z0-083 Oracle Database Administration II exam ?An Oracle Database Administration 2019 Certified Professional has proven theoretical understanding of and the practical skills required to configure and manage Oracle Databases up to and including Oracle 19c. Passing this second exam in a two exam path proves your skills in: installation, upgrades, patching, SQL programming skills, database and network administration and backup and recovery. This person also demonstrates fluency with some advanced skills such as multi-tenant, SQL performance monitoring and problem determination.Review exam topics:-Creating CDBs and Regular PDBs - Oracle Database: Managing Multitenant Architecture Ed 1Configure and create a CDBCreate a new PDB from the CDB seedExplore the structure of PDBsManage CDBs and PDBs - Oracle Database: Managing Multitenant Architecture Ed 1Manage PDB service names and connectionsManage startup, shutdown and availability of CDBs and PDBsChange the different modes and settings of PDBsEvaluate the impact of parameter value changesPerformance management in CDBs and PDBsControl CDB and PDB resource usage with the Oracle Resource ManagerBackup and Duplicate - Oracle Database: Managing Multitenant Architecture Ed 1Perform Backup and Recover CDBs and PDBsDuplicate an active PDBDuplicate a DatabaseUpgrading and Transporting CDBs and Regular PDBs - Oracle Database: Managing Multitenant Architecture Ed 1Upgrade an Oracle DatabaseTransport DataManage Application PDBs - Oracle Database: Managing Multitenant Architecture Ed 1Explain the purpose of application root and application seedDefine and create application PDBsInstall, upgrade and Patch applicationsCreate and administer Application PDBSClone PDBs and Application containersPlug and unplug operations with PDBs and application containersComparing Local Undo Mode and Shared Undo ModeManage Security in Multitenant databases - Oracle Database: Managing Multitenant Architecture Ed 1Manage Security in Multitenant databasesManage PDB lockdown profilesAudit Users in CDBs and PDBsManage other types of policies in application containersRecovery and Flashback - Oracle Database: Managing Multitenant Architecture Ed 1Restore and Recovering Databases with RMANPerform CDB and PDB flashbackBackup Strategies and Terminology - Oracle Database: Backup and Recovery WorkshopPerform Full and Incremental Backups and RecoveriesCompress and Encrypt RMAN BackupsUse a media managerCreate multi-section backups of very large filesCreate duplexed backup setsCreate archival backupsBackup of recovery filesBackup non database filesBack up ASM meta dataRestore and Recovery Concepts - Oracle Database: Backup and Recovery WorkshopEmploy the best Oracle Database recovery technology for your failure situationDescribe and use Recovery technology for Crash, Complete, and Point-in-time recovryUsing Flashback Technologies - Oracle Database: Backup and Recovery WorkshopConfigure your Database to support FlashbackPerform flashback operationsDuplicating a Database - Oracle Database: Backup and Recovery WorkshopDuplicate DatabasesConfiguring and Using RMAN - Oracle Database: Backup and Recovery WorkshopConfigure RMAN and the Database for RecoverabilityConfigureand Using an RMAN recovery catalogDiagnosing Failures - Oracle Database: Backup and Recovery WorkshopDetect and repair database and database block corruptionDiagnosing Database IssuesPerforming Recovery - Oracle Database: Backup and Recovery WorkshopRestore and Recovering Databases with RMANPerform Non RMAN database recoveryTransporting Data - Oracle Database: Backup and Recovery WorkshopTransport DataRMAN Troubleshooting and Tuning - Oracle Database: Backup and Recovery WorkshopInterpret the RMAN message outputDiagnose RMAN performance issuesInstall Grid Infrastructure and Oracle Database - Oracle Database: Deploy, Patch and Upgrade WorkshopInstall Grid Infrastructure for a Standalone serverInstall Oracle Database softwarePatching Grid Infrastructure and Oracle Database - Oracle Database: Deploy, Patch and Upgrade WorkshopPatch Grid Infrastructure and Oracle DatabaseUpgrading to Oracle Grid Infrastructure - Oracle Database: Deploy, Patch and Upgrade WorkshopUpgrade Oracle Grid InfrastructureOracle Database 18c: New Features - Oracle Database: Deploy, Patch and Upgrade WorkshopImage and RPM based Database InstallationCreating an Oracle Database by using DBCA - Oracle Database: Deploy, Patch and Upgrade WorkshopCreate, Delete and Configure Databases using DBCAOracle Restart - Oracle Database: Deploy, Patch and Upgrade WorkshopConfigure and use Oracle Restart to manage componentsUpgrade the Oracle Database - Oracle Database: Deploy, Patch and Upgrade WorkshopPlan for Upgrading an Oracle DatabaseUpgrade an Oracle DatabasePerform Post-Upgrade tasksInstall Grid Infrastructure for a Standalone server - Oracle Database: Deploy, Patch and Upgrade WorkshopRapid Home ProvisioningUsing General Overall Database Enhancements - Oracle Database 19c: New Features for AdministratorsInstall Oracle Database softwareCreate, Delete and Configure Databases using DBCACreating CDBs and Regular PDBsUse Miscellaneaous 19c New FeaturesUsing Availability Enhancements - Oracle Database 19c: New Features for AdministratorsUse an RMAN recovery catalogUse Flashback DatabaseUsing Diagnosibility Enhancements - Oracle Database 19c: New Features for AdministratorsUse new Diagnoseability FeaturesMonitoring and Tuning Database Performance - Oracle Database: Administration WorkshopManaging Memory ComponentsUnderstanding The Automatic Workload Repository (AWR)Understanding The Advisory FrameworkMonitoring Wait Events, Sessions, and ServicesManaging Metric Thresholds and AlertsUnderstanding and Using The Performance Tuning MethodologyPerforming Performance PlanningUnderstanding The Automatic Database Diagnostic Monitor (ADDM)Tuning SQL Statements - Oracle Database: Administration WorkshopUnderstanding The Oracle OptimizerUsing The SQL Tuning AdvisorManaging Optimizer StatisticsUsing The SQL Access AdvisorUnderstanding The SQL Tuning Process

Skills

Reviews