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 12.1.0.1.0.
|
| Format | Multiple Choice |
| Recommended Training | |
| Schedule Exam | Pearson VUE - Oracle |
| Recommended Practice | Email Macro.net 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 - Use DBMS_FLASHBACK_ARCHIVE package |
| 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 | |
| Introduction | |
| 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.