OCP Oracle database 12c : advanced administration exam guide (exam 1Z0-063) /
A Complete Study System for OCP Exam 1Z0-063 Prepare for the Oracle Certified Professional Oracle Database 12 c 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...
Clasificación: | Libro Electrónico |
---|---|
Autor principal: | |
Formato: | Electrónico eBook |
Idioma: | Inglés |
Publicado: |
New York :
McGraw-Hill Education,
[2015]
|
Edición: | Third edition. |
Temas: | |
Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- Cover
- Title Page
- Copyright Page
- Contents at a Glance
- Contents
- Acknowledgments
- Introduction
- 1 Database Backup Solutions and Automatic Storage Management
- Explain Oracle Backup and Recovery Solutions
- Oracle Logical Storage Structures
- Oracle Physical Storage Structures
- Oracle Memory Structures
- ASM Overview
- ASM Architecture
- Exercise 1-1: Find New ASM-Related Processes in ASM and RDBMS Instances
- Database Failures and Backup Solutions
- Two-Minute Drill
- Q & A Self Test
- Self Test Answers
- 2 Configuring for Recoverability
- Configure and Manage RMAN Settings
- Logical Backups
- Physical Backups
- RMAN Command Overview
- Exercise 2-1: Query and Change the Retention Policy
- Configure the Fast Recovery Area
- Defining the Size and Location of the Fast Recovery Area
- Monitoring and Managing the Fast Recovery Area
- Exercise 2-2: Query the Location, Contents, and Size of the Fast Recovery Area
- Configure Control Files and Redo Log Files for Recoverability
- Configuring ARCHIVELOG Mode
- Leveraging Multiple Archive Destinations
- Exercise 2-3: Identify the Archive Log File Destinations
- Back Up and Recover a NOARCHIVELOG Database
- Two-Minute Drill
- Q & A Self Test
- Self Test Answers
- 3 Using the RMAN Recovery Catalog
- Create and Use an RMAN Recovery Catalog
- Using the Control File for RMAN Metadata
- Using a Recovery Catalog for RMAN Metadata
- Configure the Recovery Catalog Database
- Create the Recovery Catalog Owner
- Create the Recovery Catalog
- Synchronize the Recovery Catalog
- Exercise 3-1: Cataloging Additional Backup Files
- Create and Use RMAN Stored Scripts
- Exercise 3-2: Creating a Parameterized Stored Script
- Protect the RMAN Recovery Catalog
- Backing Up the Recovery Catalog
- Recovering from a Lost Recovery Catalog
- Exporting and Importing the Recovery Catalog
- Dropping a Recovery Catalog
- Upgrading the Recovery Catalog
- Create and Use a Virtual Private Catalog
- Understanding Virtual Private Catalogs
- Creating and Managing a Virtual Private Catalog
- Two-Minute Drill
- Q & A Self Test
- Self Test Answers
- 4 Creating Advanced RMAN Backups
- Use Various RMAN Backup Types and Strategies
- Types of RMAN Backups
- RMAN Backup Destinations
- Persisting RMAN Settings
- Control File Autobackups
- Allocating Channels to Use in Backing Up
- Perform Full and Incremental Backups
- Creating Backupsets
- Exercise 4-1: Create a Compressed Backupset
- Creating Image Copies
- Whole-Database Backups
- Full Backups
- Exercise 4-2: Perform a Full Backup of Two Tablespaces
- Incremental Backups
- Use Techniques to Improve Backups
- Understanding Block Change Tracking
- Enabling Fast Incremental Backup
- Monitoring Block Change Tracking
- Creating Duplexed Backupsets
- Creating Backups of Backupsets
- Backing Up Read-Only Tablespaces
- Understanding Archival Backups