OCP 2019 – 1Z0-083

Creating CDBs and Regular PDBs – Oracle Database: Managing Multitenant Architecture Ed 1

  • Configure and create a CDB – POST I
  • Create a new PDB from the CDB seed – POST I
  • Explore the structure of PDBs – POST IPOST II

Backup and Duplicate – Oracle Database: Managing Multitenant Architecture Ed 1

  • Perform Backup and Recover CDBs and PDBs
  • Duplicate an active PDB
  • Duplicate a Database

Manage Application PDBs – Oracle Database: Managing Multitenant Architecture Ed 1

  • Explain the purpose of application root and application seed – POST I POST II
  • Define and create application PDBs – POST I
  • Install, upgrade and Patch applications – POST I
  • Create and administer Application PDBS  – POST I
  • Clone PDBs and Application containers – POST I
  • Plug and unplug operations with PDBs and application containers – POST IPOST II
  • Comparing Local Undo Mode and Shared Undo Mode

Recovery and Flashback – Oracle Database: Managing Multitenant Architecture Ed 1

  • Restore and Recovering Databases with RMAN – POST IPOST II
  • Perform CDB and PDB flashback

Backup Strategies and Terminology – Oracle Database: Backup and Recovery Workshop

  • Perform Full and Incremental Backups and Recoveries – POST I, POST II
  • Compress and Encrypt RMAN Backups
  • Use a media manager
  • Create multi-section backups of very large files – POST I
  • Create duplexed backup sets – POST I
  • 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 – POST I
  • Describe and use Recovery technology for Crash, Complete, and Point-in-time recovery – POST I, POST II, POST III

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

Diagnosing Failures – Oracle Database: Backup and Recovery Workshop

  • Detect and repair database and database block corruption – POST I
  • Diagnosing Database Issues – 

Transporting Data – Oracle Database: Backup and Recovery Workshop

  • Transport Data

Install Grid Infrastructure and Oracle Database – Oracle Database: Deploy, Patch and Upgrade Workshop

  • Install Grid Infrastructure for a Standalone server
  • Install Oracle Database software – POST IPOST II

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

Oracle Restart – Oracle Database: Deploy, Patch and Upgrade Workshop

  • Configure and use Oracle Restart to manage components

Install Grid Infrastructure for a Standalone server – Oracle Database: Deploy, Patch and Upgrade Workshop

  • Rapid Home Provisioning

Using Availability Enhancements – Oracle Database 19c: New Features for Administrators

  • Use an RMAN recovery catalog – POST I
  • Use Flashback Database

Monitoring and Tuning Database Performance – Oracle Database: Administration Workshop

  • Managing Memory Components
  • Understanding The Automatic Workload Repository (AWR) – POST I
  • Understanding The Advisory Framework
  • Monitoring Wait Events, Sessions, and Services
  • Managing Metric Thresholds and Alerts – POST I
  • Understanding and Using The Performance Tuning Methodology
  • Performing Performance Planning
  • Understanding The Automatic Database Diagnostic Monitor (ADDM) – POST I

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

Upgrading and Transporting CDBs and Regular PDBs – Oracle Database: Managing Multitenant Architecture Ed 1

  • Upgrade an Oracle Database – 
  • Transport Data

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

Configuring and Using RMAN – Oracle Database: Backup and Recovery Workshop

  • Configure RMAN and the Database for Recoverability
  • Configureand Using an RMAN recovery catalog – POST I

Performing Recovery – Oracle Database: Backup and Recovery Workshop

  • Restore and Recovering Databases with RMAN – POST I
  • Perform Non RMAN database recovery

RMAN Troubleshooting and Tuning – Oracle Database: Backup and Recovery Workshop

  • Interpret the RMAN message output
  • Diagnose RMAN performance issues – POST I

Creating an Oracle Database by using DBCA – Oracle Database: Deploy, Patch and Upgrade Workshop

  • Create, Delete and Configure Databases using DBCA

Upgrade the Oracle Database – Oracle Database: Deploy, Patch and Upgrade Workshop

  • Plan for Upgrading an Oracle Database – POST I
  • Upgrade an Oracle Database – POST IPOST II
  • Perform Post-Upgrade tasks – POST I

Using General Overall Database Enhancements – Oracle Database 19c: New Features for Administrators

  • Install Oracle Database software – POST I
  • Create, Delete and Configure Databases using DBCA – POST I
  • Creating CDBs and Regular PDBs – POST I
  • Use Miscellaneaous 19c New Features

Using Diagnosibility Enhancements – Oracle Database 19c: New Features for Administrators

  • Use new Diagnoseability Features

Tuning SQL Statements – Oracle Database: Administration Workshop

  • Understanding The Oracle Optimizer
  • Using The SQL Tuning Advisor – POST I
  • Managing Optimizer Statistics
  • Using The SQL Access Advisor – POST I
  • Understanding The SQL Tuning Process – POST I
Esse Blog é reconhecido pela
Sou um
Certificações
Sou articulista

Clique para seguir este blog e receber notificações via email de novos posts.

Tércio Costa

Tércio Costa

Meu nome é Tércio Costa, sou formado em Ciências da Computação pela UFPB, tenho a certificação OCA 12c, Oracle SQL Expert e OCP PL/SQL, mantendo um blog reconhecido pela OTN(oraclepress.wordpress.com), no qual também publico artigos técnicos no portal OTN, no portal http://www.profissionaloracle.com.br/gpo e na revista SQL Magazine. Além de tudo isto sou um Oracle ACE por estar sempre contribuindo para a comunidade com um bom nível de expertise.

Links Pessoais

Serviços verificados

Visualizar Perfil Completo →

Total de Visualizações da Página
  • 180.662 Visualizações
%d blogueiros gostam disto: