1Z0-063: Oracle Database 12c: Advanced Administration

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 pre-12.1 non-CDB database to CDB

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

Dit examen is onderdeel van de Oracle Certified Professional certificering.