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


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 :

  • 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 12c: Backup and Recovery Workshop ou disposer de connaissances et compétences équivalentes.

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
Print Friendly, PDF & Email
retour vers le catalogue des formations