You are previewing OCP Oracle Database 12c Advanced Administration Exam Guide (Exam 1Z0-063), 3rd Edition.
O'Reilly logo
OCP Oracle Database 12c Advanced Administration Exam Guide (Exam 1Z0-063), 3rd Edition

Book Description

A Complete Study System for OCP Exam 1Z0-063 Prepare for the Oracle Certified Professional Oracle Database 12c Advanced Administration exam with this exclusive Oracle Press guide. Each chapter features challenging exercises, a certification summary, a two-minute drill, and a self test to reinforce the topics presented. This authoritative resource helps you pass the exam and also serves as an essential on-the-job reference. Get complete coverage of all OCP objectives for exam 1Z0-063, including: Configuring and managing Oracle Recovery Manager (RMAN) settings Using the Oracle RMAN recovery catalog Performing backup and recovery Diagnosing database failures and using the automatic diagnostic repository Encrypting, securing, monitoring, and tuning Oracle RMAN backups Configuring and using flashback features Transporting and copying tablespaces and databases Creating and managing multitenant container databases and pluggable databases Using the Oracle Data Pump, SQL*Loader, and auditing features Electronic content includes: 150+ practice exam questions Test engine that provides practice exams or quizzes that can be customized by chapter or exam objective PDF copy of the book

Table of Contents

  1. Cover
  2. Title Page
  3. Copyright Page
  4. Contents at a Glance
  5. Contents
  6. Acknowledgments
  7. Introduction
  8. 1 Database Backup Solutions and Automatic Storage Management
    1. Explain Oracle Backup and Recovery Solutions
      1. Oracle Logical Storage Structures
      2. Oracle Physical Storage Structures
      3. Oracle Memory Structures
      4. ASM Overview
      5. ASM Architecture
      6. Exercise 1-1: Find New ASM-Related Processes in ASM and RDBMS Instances
      7. Database Failures and Backup Solutions
      8. Two-Minute Drill
    2. Q&A Self Test
      1. Self Test Answers
  9. 2 Configuring for Recoverability
    1. Configure and Manage RMAN Settings
      1. Logical Backups
      2. Physical Backups
      3. RMAN Command Overview
      4. Exercise 2-1: Query and Change the Retention Policy
    2. Configure the Fast Recovery Area
      1. Defining the Size and Location of the Fast Recovery Area
      2. Monitoring and Managing the Fast Recovery Area
      3. Exercise 2-2: Query the Location, Contents, and Size of the Fast Recovery Area
    3. Configure Control Files and Redo Log Files for Recoverability
      1. Configuring ARCHIVELOG Mode
      2. Leveraging Multiple Archive Destinations
      3. Exercise 2-3: Identify the Archive Log File Destinations
    4. Back Up and Recover a NOARCHIVELOG Database
      1. Two-Minute Drill
    5. Q&A Self Test
      1. Self Test Answers
  10. 3 Using the RMAN Recovery Catalog
    1. Create and Use an RMAN Recovery Catalog
      1. Using the Control File for RMAN Metadata
      2. Using a Recovery Catalog for RMAN Metadata
      3. Configure the Recovery Catalog Database
      4. Create the Recovery Catalog Owner
      5. Create the Recovery Catalog
      6. Synchronize the Recovery Catalog
      7. Exercise 3-1: Cataloging Additional Backup Files
      8. Create and Use RMAN Stored Scripts
      9. Exercise 3-2: Creating a Parameterized Stored Script
    2. Protect the RMAN Recovery Catalog
      1. Backing Up the Recovery Catalog
      2. Recovering from a Lost Recovery Catalog
      3. Exporting and Importing the Recovery Catalog
      4. Dropping a Recovery Catalog
      5. Upgrading the Recovery Catalog
    3. Create and Use a Virtual Private Catalog
      1. Understanding Virtual Private Catalogs
      2. Creating and Managing a Virtual Private Catalog
      3. Two-Minute Drill
    4. Q&A Self Test
      1. Self Test Answers
  11. 4 Creating Advanced RMAN Backups
    1. Use Various RMAN Backup Types and Strategies
      1. Types of RMAN Backups
      2. RMAN Backup Destinations
      3. Persisting RMAN Settings
      4. Control File Autobackups
      5. Allocating Channels to Use in Backing Up
    2. Perform Full and Incremental Backups
      1. Creating Backupsets
      2. Exercise 4-1: Create a Compressed Backupset
      3. Creating Image Copies
      4. Whole-Database Backups
      5. Full Backups
      6. Exercise 4-2: Perform a Full Backup of Two Tablespaces
      7. Incremental Backups
    3. Use Techniques to Improve Backups
      1. Understanding Block Change Tracking
      2. Enabling Fast Incremental Backup
      3. Monitoring Block Change Tracking
      4. Creating Duplexed Backupsets
      5. Creating Backups of Backupsets
      6. Backing Up Read-Only Tablespaces
      7. Understanding Archival Backups
      8. Creating a Multisection Backup
      9. Compressing Backups
      10. Encrypting Backups
    4. Manage Backups
      1. Using the LIST Command
      2. Using the REPORT Command
      3. Using the DELETE Command
      4. Using the CROSSCHECK Command
    5. Perform Backup of Nondatabase Files
      1. Backing Up the Control File
      2. Backing Up ASM Metadata
      3. Cataloging Additional Backup Files
      4. Two-Minute Drill
    6. Q&A Self Test
      1. Self Test Answers
  12. 5 Recovering Using RMAN Backups
    1. Describe and Tune Instance Recovery
    2. Perform Complete and Incomplete Recovery
      1. Using the RMAN RESTORE and RECOVER Commands
      2. Performing Complete Recovery of a Noncritical Datafile
      3. Exercise 5-1: Restore and Recover the USERS Tablespace
      4. Performing Complete Recovery of a Critical Datafile
      5. Performing Incomplete Recovery Using RMAN
      6. Exercise 5-2: Perform Incomplete Recovery to Restore the USERS Tablespace
      7. Recovering Using Incrementally Updated Backups
      8. Switching to Image Copies for Fast Recovery
      9. Exercise 5-3: Use the SWITCH Command to Recover a Datafile Quickly
      10. Exercise 5-4: Use the SWITCH Command after Creating the USERS Tablespace’s Datafile in the Original Location
    3. Perform Recovery for SPFILEs, Password Files, Control Files, and Redo Log Files
      1. Restoring the SPFILE from the Autobackup
      2. Restoring the Control File from the Autobackup
      3. Exercise 5-5: Restore the Control File from an Autobackup
      4. Recovering from a Lost Redo Log Group
      5. Understanding Log Group Status
      6. Recovering from Log Group Member Failures
      7. Recovering from Loss of an Entire Log Group
      8. Recover from the Loss of the Password File
      9. Exercise 5-6: Re-create the Password File after Accidental Deletion
      10. Recovering the Control File
      11. Exercise 5-7: Recover from the Loss of All Control Files
    4. Perform Recovery of Index and Read-Only Tablespaces and Tempfiles
      1. Recovering from a Lost Tempfile
      2. Exercise 5-8: Create a Replacement Tempfile for the TEMP Tablespace
    5. Restore a Database to a New Host
      1. Understanding Restoration to a New Host
      2. Preparing the New Host
      3. Restoring and Recovering on the New Host
      4. Two-Minute Drill
    6. Q&A Self Test
      1. Self Test Answers
  13. 6 Diagnosing Database Failures and the ADR
    1. Describe the Automatic Diagnostic Workflow
      1. Understanding the ADR
      2. Using the ADRCI Tool
      3. Understanding Alerts, Problems, and Incidents
      4. Using the Health Monitor
    2. Handle Block Corruption
      1. Understanding Block Corruption
      2. Using the DB_BLOCK_CHECKING Parameter
      3. Using Block Media Recovery
      4. Using the Data Recovery Advisor
      5. Two-Minute Drill
    3. Q&A Self Test
      1. Self Test Answers
  14. 7 Encrypting, Securing, Monitoring, and Tuning RMAN Backups
    1. Create RMAN-Encrypted Backups
      1. Configuring and Using Transparent Encryption
      2. Using Password Encryption
      3. Using Dual Mode Encryption
    2. Configure and Use Oracle Secure Backup
      1. Overview of Oracle Secure Backup
      2. Installing and Configuring Oracle Secure Backup
      3. Using RMAN with Oracle Secure Backup
      4. Miscellaneous obtool Commands
    3. Tune RMAN Performance
      1. Monitoring RMAN Sessions and Jobs
      2. Exercise 7-1: Monitor RMAN Channels
      3. Exercise 7-2: Monitor Multiple RMAN Jobs
      4. Exercise 7-3: Debug Part of an RMAN Session
    4. Tune RMAN Performance
      1. Identifying Backup and Restore Steps
      2. Parallelizing Backupsets
      3. Understanding RMAN Multiplexing
      4. Tuning RMAN Channels
      5. Tuning the BACKUP Command
      6. Configuring LARGE_POOL_SIZE
      7. Two-Minute Drill
    5. Q&A Self Test
      1. Self Test Answers
  15. 8 Configuring and Using Flashback Features
    1. Describe the Flashback Technologies
      1. Flashback Types and Dependencies
      2. Configuring Flashback Parameters
    2. Use Flashback to Query Data
      1. Using Flashback Query
      2. Using Flashback Version Query
    3. Perform Flashback Table Operations
      1. Leveraging the Recycle Bin
      2. Exercise 8-1: Move Objects to the Recycle Bin
      3. Exercise 8-2: Restore a Table from the Recycle Bin, Keeping the Original Dependent Object Names
      4. Understanding Flashback Table
      5. Exercise 8-3: Use Flashback Table on a Table
      6. Understanding Flashback Transaction Query
    4. Perform Table Recovery from Backups
      1. Scenarios for Table Recovery from Backups
      2. Prerequisites and Limitations for Table Recovery from Backups
      3. Using Table Recovery from Backups
    5. Describe and Use Flashback Data Archive
      1. Understanding Flashback Data Archive
      2. Creating an Archive
      3. Using Flashback Data Archive Data Dictionary Views
      4. Assigning Flashback Data Archive Permissions
      5. Managing Flashback Data Archives
      6. Assigning a Table to a Flashback Data Archive
      7. Querying Flashback Data Archives
    6. Perform Flashback Database
      1. Understanding Flashback Database
      2. Configuring Flashback Database
      3. Using Flashback Database
      4. Two-Minute Drill
    7. Q&A Self Test
      1. Self Test Answers
  16. 9 Transporting and Copying Tablespaces and Databases
    1. Describe and Use Transportable Tablespaces and Databases
      1. Configuring Transportable Tablespaces
      2. Transporting Tablespaces
      3. Exercise 9-1: Transport a Tablespace Using SQL and PL/SQL
    2. Choose a Technique for Duplicating a Database
      1. Cross-Platform Data Transport
      2. Using Image Copies for Data Transport
      3. Using RMAN Backupsets for Database Transport
    3. Create a Backup-Based Duplicate Database
      1. Using RMAN to Create a Duplicate Database
      2. Using a Duplicate Database
    4. Duplicate a Database Based on a Running Instance
      1. Configure the Auxiliary Instance
      2. Create an Initialization Parameter File
      3. Start the Auxiliary Instance in NOMOUNT Mode and Create an SPFILE
      4. Start the Source Database in MOUNT or OPEN Mode
      5. Create Backups for the DUPLICATE Command
      6. Allocate Auxiliary Channels If Necessary
      7. Run the RMAN DUPLICATE Command
      8. Two-Minute Drill
    5. Q&A Self Test
      1. Self Test Answers
  17. 10 Architecture of Multitenant Databases
    1. Describe the Multitenant Architecture
      1. Leveraging Multitenant Databases
      2. Understanding Multitenant Configurations
    2. Explain Pluggable Database Provisioning
      1. Two-Minute Drill
    3. Q&A Self Test
      1. Self Test Answers
  18. 11 Creating Multitenant Container Databases and Pluggable Databases
    1. Configure and Create a CDB
      1. Creating a CDB Using Different Methods
      2. Exercise 11-1: Creating a New Container Database (CDB) Using SQL Commands
      3. Understanding New Data Dictionary Views: The Sequel
    2. Create a PDB Using Different Methods
      1. Using PDB$SEED to Create a New PDB
      2. Exercise 11-2: Create a New Pluggable Database Using PDB$SEED
      3. Cloning a PDB to Create a New PDB
      4. Plug a Non-CDB into a CDB
      5. Plug an Unplugged PDB into a CDB
    3. Unplug and Drop a PDB
      1. Unplug a PDB Using Different Methods
      2. Dropping a PDB
    4. Migrate Pre-12.1 Non-CDB Database to CDB
      1. Using the Upgrade Method to Migrate a Non-CDB
      2. Using the Data Pump Method to Migrate a Non-CDB
      3. Using the Database Link Method to Migrate a Non-CDB
      4. Two-Minute Drill
    5. Q&A Self Test
      1. Self Test Answers
  19. 12 Managing CDBs and PDBs
    1. Establish Connections to CDBs and PDBs
      1. Understanding CDB and PDB Service Names
      2. Connecting to a CDB or PDB Using SQL Developer
      3. Creating Services for CDBs or PDBs
    2. Switching Connections Within a CDB
      1. Start Up and Shut Down a CDB and Open and Close PDBs
      2. CDB Instance Startup
      3. Open and Close a PDB
      4. CDB Instance Shutdown
      5. Automating PDB Startup
      6. Changing PDB Status
    3. Evaluate the Impact of Parameter Value Changes
      1. Understanding the Scope of Parameter Changes
      2. Using ALTER SYSTEM in a Multitenant Environment
    4. Manage Permanent and Temporary Tablespaces in CDB and PDBs
    5. Manage Common and Local Users
    6. Manage Common and Local Privileges
    7. Manage Common and Local Roles
    8. Enable Common Users to Access Data in Specific PDBs
      1. Two-Minute Drill
    10. Q&A Self Test
      1. Self Test Answers
  20. 13 Backup and Recovery of CDBs and PDBs
    1. Perform Backups of a CDB and PDBs
      1. Backing Up CDBs
      2. Backing Up PDBs
    2. Recover PDB from PDB Datafiles Loss
      1. Tempfile Recovery
      2. Recovering from Control File Loss
      3. Recovering from Redo Log File Loss
      4. Recovering from Root Datafile Loss
      5. Recovering from PDB Datafiles
    3. Use Data Recovery Advisor
      1. Data Failures
      2. PITR Scenarios
      3. Using Flashback CDB
      4. Identifying Block Corruption
    4. Duplicate PDBs Using RMAN
      1. Two-Minute Drill
    5. Q&A Self Test
      1. Self Test Answers
  21. 14 Managing Performance
    1. Monitor Operations and Performance in a CDB and PDBs
      1. Tuning Methodology
      2. Sizing the CDB
      3. Using Memory Advisors
      4. Leveraging AWR Reports
    2. Manage Allocation of Resources Between PDBs and Within a PDB
      1. Using Shares to Manage Inter-PDB Resources
      2. Creating and Modifying Resource Manager Plans
      3. Exercise 14-1: Creating a CDB Resource Plan with PDB Directives
    3. Perform Database Replay
      1. Analyze the Source Database Workloads
      2. Capture Source Database Workloads
      3. Process Workloads on Target System
      4. Replay Workloads on Target CDB
      5. Verify Replay Results
      6. Two-Minute Drill
    4. Q&A Self Test
      1. Self Test Answers
  22. 15 Related Utilities: Data Pump, SQL*Loader, and Auditing
    1. Use Data Pump
      1. Export from Non-CDB and Import into PDB
      2. Export and Import Between PDBs
      3. Export from PDB and Import into Non-CDB
      4. Full Transportable Export and Import
      5. Transporting a Database Over the Network
    2. Use SQL*Loader
    3. Audit Operations
      1. Creating the Audit Policy
      2. Viewing Audit Policies
      3. Viewing Audited Events
      4. Two-Minute Drill
    4. Q&A Self Test
      1. Self Test Answers
  23. A About the Download
    1. System Requirements
    2. Downloading Total Tester Premium Practice Exam Software
    3. Total Tester Premium Practice Exam Software
    4. Installing and Running Total Tester
    5. Technical Support
      1. Total Seminars Technical Support
      2. McGraw-Hill Education Content Support
  24. Glossary
  25. Index