OCP 2019 – 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

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
  • 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

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

Diagnosing Failures – Oracle Database: Backup and Recovery Workshop

  • Detect and repair database and database block corruption
  • 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

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
  • Use Flashback Database

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)

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

Performing Recovery – Oracle Database: Backup and Recovery Workshop

  • Restore and Recovering Databases with RMAN
  • Perform Non RMAN database recovery

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

  • Interpret the RMAN message output
  • Diagnose RMAN performance issues

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
  • Upgrade an Oracle Database
  • Perform Post-Upgrade tasks

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 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
  • Managing Optimizer Statistics
  • Using The SQL Access Advisor
  • Understanding The SQL Tuning Process
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
  • 161.530 Visualizações
%d blogueiros gostam disto: