1Z0-067: Upgrade Oracle 9i/10g/11g OCA to Oracle Database 12c OCP

Exam Number: 1Z0-067

Exam Title: Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP

Associated Certification Paths

Oracle 1Z0-067 Certification Details:

Exam Name Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP
Exam Code 1Z0-067
Exam Product Version Oracle Database 12c
Exam Price USD $245
Duration 150 minutes
Number of Questions 102
Passing Score 60%
Validated Against Exam has been validated against Oracle Database
Format Multiple Choice
Recommended Practice 1Z0-067 Online Practice Exam
Recommended Training Oracle Database 12c: New Features for Administrators
Oracle Database 12c: Backup and Recovery Workshop

Oracle 1Z0-067 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 database parameters that affect RMAN operations
    • 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
    • Create and use Virtual Private Catalogs
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
    • Detect database corruptions using the ANALYZE and DBVERIFY utility
    • Detect database corruptions using the DBMS_REPAIR package 
    • Implement the DB_BLOCK_CHECKING parameter to detect corruptions 
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
    • Perform automated TSPITR
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
  • Recover using incrementally updated backups  
  • Switch to image copies for fast recovery 
  • Perform disaster recovery
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
Using Automatic Storage Management 
  • Use Automatic Storage Management
    • Explain Automatic Storage Management (ASM)  
    • Set up initialization parameter files for ASM and database instances
    • Administer ASM diskgroups
    • Execute SQL commands with ASM file names 
    • Perform startup and shutdown for ASM instances 
    • Use the ASMCMD command-line interface 
    • Set up ASM fast mirror resynch
    • Use RMAN to migrate your database to ASM
Performing User-Managed Backup and Recovery
  • Perform user-managed backup and recovery
    • Describe the backup mode  
    • Back up and recover a control file 
    • Recover from a lost temp file
    • Recover from a lost redo log group  
    • Recover from the loss of a password file  
    • Perform user-managed complete database recovery 
    • Perform user-managed incomplete database recovery 
Multitenant Environment
Multitenant Container and Pluggable Database Architecture
  • Describe multitenant architecture
  • Explain pluggable database provisioning

Creating Multitenant Container Databases  and Pluggable Databases
  • Create and configure a CDB
  • Create a PDB using different methods
  • Unplug and drop a PDB
  • Migrate a non-CDB to a PDB database

Managing CDBs and PDBs
  • Establish connections to a 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
  • Perform Flashback for a CDB

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 a CDB and PDBs: Database Vault, Data Guard, LogMiner
Database Administration

Installing and Upgrading to Oracle Database 12c
  • Install Oracle Grid Infrastructure for a stand-alone server
  • Install Oracle Database software
  • Use Oracle Restart
  • Upgrade to Oracle Database 12c

Using Enterprise Manager and Other Tools
  • Use EM Express
  • Use DBCA to create and manage databases
  • Use Oracle Database Migration Assistant for Unicode

Monitoring and Managing Memory
  • Implement Automatic Shared Memory Management
  • Manually configure SGA parameters for various memory components in the SGA 
  • Use Automatic PGA Memory Management
  • Implement Automatic Memory Management

Storage Management
  • Create and maintain bigfile tablespaces
  • Rename tablespaces 
  • Create a default permanent tablespace 

Space Management
  • Manage resumable space allocation
  • Reclaim wasted space from tables and indexes by using the segment shrink functionality
  • Rebuild indexes online
  • Reduce space-related error conditions by proactively managing tablespace usage 
  • Use different storage options to improve the performance of queries 
  • Use automatic undo retention tuning and temporary undo
  • Implement  partitioning methods 

  • Configure the password file to use case-sensitive passwords
  • Encrypt a tablespace 
  • Use Secure File LOBS to store documents with compression, encryption, de-duplication
  • Configure fined-grained access to network services
  • Use and manage Oracle Data Redaction policies

  • Enable and configure standard and Unified Audit Data Trail
  • Create and enable audit policies

  • Use administrative privileges
  • Create, enable, and use privilege analysis

Using Globalization Support
  • Customize language-dependent behavior for the database and individual sessions  
  • Specify different linguistic sorts for queries 
  • Use datetime datatypes 
  • Query data using non-case-sensitive and accent-insensitive searches
  • Obtain globalization support configuration information
Automating Tasks with the Scheduler
  • Create a job, program, and schedule
  • Use a time-based or event-based schedule for executing Scheduler jobs 
  • Create lightweight jobs 
  • Use job chains to perform a series of related tasks 
  • Create Windows and Job Classes
  • Use advanced Scheduler concepts to prioritize jobs

Loading and Unloading Data
  • Explain Data Pump architecture 
  • Monitor a Data Pump job 
  • Use Data Pump export and import 
  • Create external tables for data population

Managing Resources 
  • Configure the Resource Manager
  • Assign users to Resource Manager groups 
  • Create resource plans within groups 
  • Specify directives for allocating resources to consumer groups

Managing Database Performance
  • Use the SQL Tuning Advisor
  • Use the SQL Access Advisor to tune a workload  
  • Use Database Replay
  • Implement real-time database operation monitoring
  • Use Adaptive Execution Plans
  • Use enhanced features of statistics gathering
  • Use Adaptive SQL Plan Management
  • Perform emergency monitoring and real-time ADDM
  • Generate ADDM Compare Period (Use AWR and ADDM)
  • Diagnose performance issues using ASH enhancements
  • Explain Multiprocess and Multithreaded Oracle architecture
  • Use Flash Cache 

Information Lifecycle Management and Storage Enhancements
  • Use ILM features
  • Perform tracking and automated data placement
  • Move a data file online

In-Database Archiving and Valid-Time Temporal
  • Differentiate between ILM and Valid-Time Temporal
  • Set and use Valid-Time Temporal
  • Use in-database archiving

Oracle 1Z0-067 - Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP Exam Preparation: