Código: 1Z0-063

Prova Oracle Database 12c: Advanced Administration
Preço US$ 245.00
Duração 120 minutos
Número de questões ainda não definido
Nota de aprovação ainda não definido
Treinamento oficial recomendado

Tópicos do exame


Oracle Database 12c: Backup and Recovery 

Describing Oracle Data Protection Solutions
  • Explain Oracle backup and recovery solutions
Performing Basic Back up and Recovery 
  • Back up and recover a NOARCHIVELOG database
Configuring for Recoverability
  • Configure and manage RMAN settings
  • Configure the Fast Recovery Area
  • Configure control files and redo log files for recoverability
Using the RMAN Recovery Catalog
  • Create and use an RMAN Recovery Catalog
  • Protect the RMAN Recovery Catalog
Implementing Backup Strategies
  • Use various RMAN backup types and strategies
Performing Backups
  • Perform full and incremental backups
  • Manage backups
Configuring RMAN Backup Options and Creating Backup of Non-Database Files
  • Use techniques to improve backups
  • Perform backup of non-database files
Using RMAN-Encrypted Backups
  • Create RMAN-encrypted backups
Diagnosing Failures
  • Describe the Automatic Diagnostic Workflow
  • Handle block corruption
Performing Restore and Recovery Operations
  • Describe and tune instance recovery
  • Perform complete and incomplete recovery
Performing Recovery of Database and Non-Database files
  • Perform recovery for spfile, password file, control file, redo log files
  • Perform table recovery from backups
  • Perform recovery of  index and read only tablespaces, temp file
  • Restore a database to a new host
Using Oracle Secure Backup
  • Configure and use Oracle Secure Backup
Using Flashback Technologies
  • Describe the Flashback technologies
  • Use Flashback to query data
  • Perform Flashback Table operations
  • Describe and use Flashback Data Archive
Using Flashback Database
  • Perform Flashback Database
Transporting Data
  • Describe and use transportable tablespaces and databases
Duplicating a Database
  • Choose a technique for duplicating a database
  • Create a backup-up based duplicate database
  • Duplicate a database based on a running instance
Monitoring and Tuning of RMAN Operations
  • Tune RMAN performance

Oracle Database 12c: Managing Multitenant Architecture

Multitenant Container and Pluggable Database Architecture
  • Describe the multitenant architecture
  • Explain pluggable database provisioning
Creating Multitenant Container Databases  and Pluggable Databases
  • Configure and create a CDB
  • Create a PDB using different methods
  • Unplug and drop a PDB
  • Migrate a non-CDB to a PDB database
Managing a CDB and PDBs
  • Establish connections to CDB/PDB
  • Start up and shut down a CDB and open and close PDBs
  • Evaluate the impact of parameter value changes
Managing Storage in a CDB and PDBs
  • Manage permanent and  temporary tablespaces in CDB and PDBs
Managing Security in a 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
Managing Availability
  • Perform backups of a CDB and PDBs
  • Recover PDB from PDB datafiles loss
  • Use Data Recovery Advisor
  • Duplicate PDBs using RMAN
Managing Performance
  • Monitor operations and performance in a CDB and PDBs
  • Manage allocation of resources between PDBs and within a PDB
  • Perform Database Replay
Moving Data, Performing Security Operations and Interacting  with Other Oracle Products
  • Use Data Pump
  • Use SQL*Loader
  • Audit operations
  • Use Other Products with CDB and PDBs – Database Vault, Data Guard, LogMiner