Préparation à la Certification : Oracle Database 12c: Advanced Administration

QUESTIONS ?

Préparation à la Certification : Oracle Database 12c: Advanced Administration

Prix: 220 €Durée: 1 jourCode de Réference: D96690 Catalogue ,
Oracle Database 12c
Print Friendly, PDF & Email



Ce séminaire de préparation et de révision vous aide à préparer l'examen de certification Oracle Database 12c: Administration Avancée (1Z0-063).

Objectifs de la formation

A l’issue de cette formation Oracle, vous serez capable de :

  • Learn from one of Oracle University's top instructors.
  • Review key technologies and certification concepts related to Oracle Database 12c: Advanced Administration.
  • Understand the depth and breadth of the Oracle Database Administraton.
  • Get information that will help you complete your preparation and study.
  • Receive tips and information that will help you on the test.

Public

Cette formation s'adresse aux concepteurs de base de données, développeurs de base de données et administrateurs de base de données.

Prérequis

Avoir suivi les cours D78850 Oracle Database: Backup and Recovery Workshop ou disposer de connaissances et compétences équivalentes.

Compréhension de l’anglais et du vocabulaire anglais spécifique IT.

Vous souhaitez faire vérifier vos prérequis ? Contactez-nous pour l’organisation d’un entretien téléphonique avec un de nos consultants formateurs.

Programme

  • Backup and Recovery Concepts (Part 1)
  • Identify the importance of checkpoints, redo log files, and archive log files Configure ARCHIVELOG mode

  • Backup and Recovery Concepts (Part 2)
  • Back up and recover a NOARCHIVELOG database Configure control files and redo log files for recoverability

  • Configuring Recovery Manager
  • Create and maintain the Fast Recovery Area Configure database parameters that affect RMAN operations Change RMAN default settings with CONFIGURE Manage RMAN's persistent settings Start the RMAN utility and allocate channels

  • Configuring Recovery Manager: Using the RMAN Recovery Catalog
  • Identify situations that require RMAN recovery catalog Create and configure a recovery catalog Synchronize the recovery catalog Create and use RMAN stored scripts Back up the recovery catalog Create and use a virtual private catalog

  • Basics of Using RMAN to Create Backups
  • Create backupsets and image copies Create a whole database backup Perform full and incremental backups Enable fast incremental backup Report on and maintain backups

  • Additional RMAN Backup Types
  • Create duplex backup and back up backup sets Create an archival backup for long-term retention Create a multisection, compressed, and encrypted backup Perform backup of non-database files Configure and use Oracle Secure Backup

  • Performing Recovery
  • Determine the need for performing recovery Perform complete recovery from a critical or noncritical data file loss using RMAN Recover the control file Recover a redo log group member

  • Additional Recovery Tasks
  • Recover temporary tablespaces, index tablespaces and read-only tablespaces Recreate the password file Perform incomplete recovery using RMAN, database recovery following a RESETLOGS operations, and table recovery from backups Recover using incrementally updated backups Switch to image copies for fast recovery Use RMAN to migrate your database to ASM Restore a database onto a new host Perform disaster recovery

  • Performing Tablespace Point-in-Time Recovery
  • Identify situations that require TSPITR Perform automated TSPITR

  • Using RMAN to Duplicate a Database
  • Choose a technique for duplicating a database Duplicate a database based on a running instance Create a backup based duplicate database

  • Using Flashback Technologies
  • Use Flashback technology to query data Recover from user errors using Flashback versions query Perform a Flashback table operation Perform transaction-level recovery using Flashback Transaction query Set up and use a Flashback Data Archive Configure and use Flashback Database Monitor the Flashback Database

  • Dealing with Database Corruption
  • Define block corruption and list its causes and symptoms Implement the DB_BLOCK_CHECKING parameter to detect corruptions Repair corruptions using RMAN Perform Block Media Recovery

  • Using Data Recovery Advisor
  • Describe Data Recovery Advisor Repair data failures using Data Recovery Advisor Perform a proactive health check of the database

  • Diagnosing the Database
  • Describe the Automatic Diagnostic Workflow Set up Automatic Diagnostic Repository Use Support Workbench

  • Monitoring and Tuning RMAN and RMAN Enhancements in Oracle Database 12c
  • Monitor RMAN sessions and jobs Tune RMAN Configure RMAN for Asynchronous I/O Use RMAN enhancements

  • Transporting Data
  • Describe and use transportable tablespaces and databases

  • Multitenant Container and Pluggable Database Architecture
  • Describe multitenant architecture Explain pluggable database provisioning

  • Configuring and Creating CDBs and PDBs and Managing CDBs and PDBs
  • Create and configure a CDB Create a PDB using different methods Unplug and drop a PDB Migrate a non-CDB to a PDB database Establish connection to a CDB/PDB Start up and shut down a CDB and open and close PDBs Change instance parameters for a CDB/PDB

  • Managing Tablespaces, Common and Local Users, Privileges, and Roles (in CDB/PDBs)
  • Manage permanent and temporary tablespaces in CDB and PDBs Manage common and local users Manage common and local privileges Manage common and local roles Enable common users to access data in specific PDBs

  • Performing Back up, Recovery, and Flashback for a CDB/PDB
  • Perform backup of a CDB and PDB Perform recovery of a CDB and PDB Perform Flashback for a CDB Use Data Recovery Advisor

  • Managing Performance in a Multitenant Architecture
  • Monitor operations and performance in a CDB and PDBs Manage allocation of resources between PDBs and within a PDB

  • Moving Data, Performing Security Operations, and Interacting with Other Oracle Products (for CDB/PDBs)
  • Use Data Pump Use SQL*Loader Perform audit operations Use other products with a CDB and PDBs: Database Vault, Data Guard, LogMiner

    Méthodes pédagogiques

    Alternance d'apports théoriques et d'exercices avec un vaste choix d'exercices pratiques et de scénarios d'atelier permettent de mettre en œuvre les connaissances acquises.

    La dernière version du support, en anglais, est disponible en ligne.
    Print Friendly, PDF & Email
    retour vers le catalogue des formations