Oracle 1Z0-063 Certification Exam Syllabus

Oracle 1Z0-063 Certification Details:

Exam Name Oracle Database 12c - Advanced Administration
Exam Code 1Z0-063
Exam Product Version
Oracle Database 12c
Exam Price USD $245 (Pricing may vary by country or by localized currency)
Duration 120 minutes
Number of Questions 80
Passing Score 60%
Validated Against
This exam has been validated against Oracle Database
Format Multiple Choice
Recommended Training
Schedule Exam Pearson VUE - Oracle
Recommended Practice Email for Free Practice Exams

Oracle 1Z0-063 Certification Topics:

Backup and Recovery
Oracle Data Protection Solutions - Explain Oracle backup and recovery solutions
 - Describe types of database failures
 - Describe the tools available for backup and recovery tasks
 - Describe RMAN and maximum availability architecture
 - Use the SYSBACK privilege
 - Use RMAN stand-alone and job commands
Performing Basic Backup and Recovery - Back up and recover a NOARCHIVELOG database
 - Perform backup and recovery in NOARCHIVELOG mode
 - Use SQL in RMAN
Configuring for Recoverability - Configure and manage RMAN settings
 - Configure persistent settings for RMAN
- View persistent settings
 - Specify a retention policy
- Configure the Fast Recovery Area
 - Explain the Fast Recovery Area
 - Configure the Fast Recovery Area
- Configure control files and redo log files for recoverability
 - Multiplex control files
 - Multiplex redo log files
Using the RMAN Recovery Catalog - Create and use an RMAN recovery catalog
 - Configure a recovery catalog
 - Register target databases in a recovery catalog
 - Catalog additional backup files
 - Resynchronize a recovery catalog
 - Use and maintain RMAN stored scripts
 - Upgrade and drop a recovery catalog
- Protect the RMAN recovery catalog
 - Back up the recovery catalog
 - Re-create an unrecoverable recovery catalog
 - Export and import the recovery catalog
Implementing Backup Strategies - Use various RMAN backup types and strategies
 - Enable ARCHIVELOG mode
 - Create tape and disk based backups
 - Create whole database backups
 - Create consistent and inconsistent backups
 - Create backup sets and image copies
 - Create backups of read-only tablespaces
 - Employ best practices for data warehouse backups
Performing Backups - Perform full and incremental backups
 - Create full and incremental backups
 - Use the Oracle-suggested backup strategy
- Manage backups
 - Configure and monitor block change tracking
 - Report on backups using LIST, REPORT commands
 - Manage backups using CROSSCHECK, DELETE commands
Configuring RMAN Backup Options and Creating Backup of Non-Database Files - Use techniques to improve backups
 - Create compressed backups
 - Create multi-section backups of very large files
 - Create proxy copies
 - Create duplexed backup sets
 - Create backups of backup sets
 - Create archival backups
- Perform backup of non-database files
 - Back up a control file to trace
 - Back up archived redo log files
 - Back up ASM diskgroup metadata
Using RMAN-Encrypted Backups - Create RMAN-encrypted backups
 - Use transparent-mode encryption
 - Use password-mode encryption
 - Use dual-mode encryption
 - Restore encrypted backups
Diagnosing Failures - Describe the Automatic Diagnostic Workflow
 - Use the Automatic Diagnostic Repository
 - Use ADRCI
 - Find and interpret message output and error stacks
 - Use the Data Recovery Advisor
- Handle block corruption
 - Detect block corruption using RMAN
 - Perform block recovery using RMAN
Performing Restore and Recovery Operations - Describe and tune instance recovery
- Perform complete and incomplete recovery
 - Use RMAN RESTORE and RECOVER commands
 - Restore ASM disk groups
 - Recover from media failures
 - Perform complete and incomplete or “point-in-time” recoveries using RMAN
Recovering Files Using RMAN - Perform recovery for spfile, 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
 - Configure a database to use Flashback technologies
 - Guarantee undo retention
- Use Flashback to query data
 - Use Flashback Query
 - Use Flashback Version Query
 - Use Flashback Transaction Query
- Flash back a transaction
- Perform Flashback Table operations
 - Perform Flashback Table
 - Restore tables from the recycle bin
- Describe and use Flashback Data Archive
- Use Flashback Data Archive
Using Flashback Database - Perform Flashback Database
 - Configure Flashback Database
 - Perform Flashback Database
Transporting Data - Describe and use transportable tablespaces and databases
 - Transport tablespaces between databases using image copies or backup sets
 - Transport databases using data files or backup sets
 - Transport data across platforms
Duplicating a Database - Choose a technique for duplicating a database
 - From an active database, connected to the target and auxiliary instances
 - From backup, connected to the target and auxiliary instances
 - From backup, connected to the auxiliary instance, not connected to the target, but with recovery catalog connection
 - From backup, connected to the auxiliary instance, not connected to the target and the recovery catalog
 - Duplicate a database with RMAN
- Create a backup-up based duplicate database
- Duplicate a database based on a running instance
Monitoring and Tuning of RMAN Operations - Tune RMAN performance
 - Interpret RMAN error stacks
 - Diagnose performance bottlenecks
 - Tune RMAN backup performance
Managing Pluggable and Container Databases
Multitenant Container and Pluggable Database Architecture - Describe the multitenant container database architecture
- Explain pluggable database provisioning
Creating Multitenant Container and Pluggable Databases - Configure and create a CDB
- Create a PDB using different methods
- Unplug and drop a PDB
- Migrate a non-CDB database to PDB
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

The Oracle 1Z0-063 Certification Program certifies candidates on skills and knowledge related to Oracle Database products and technologies. The Oracle Database 12c Administrator Certified Professional is granted based on a combination of passing exams, training and performance-based assignments, depending on the level of certification. Oracle 1Z0-063 certification is tangible benchmark of experience and expertise that help you stand out in a crowd among employers. To ensure success, Oracle recommends combining education courses, practice exam and hands-on experience to prepare for your Oracle Database 12c - Advanced Administration certification exam as questions will test your ability to apply the knowledge you have gained in hands-on practice or professional experience.