OCP Oracle Database 12c Advanced Administration Exam Guide (Exam 1Z0-063)

Name: OCP Oracle Database 12c Advanced Administration Exam Guide (Exam 1Z0-063)
Brand: McGraw-Hill Education
Price: 107.93 EUR
Availability: OnlineOnly

Bob Bryla(Autor*in)

McGraw-Hill Education (Verlag)

1. Auflage

Erschienen am 12. Juni 2015

695 Seiten

E-Book

ePUB mit Adobe-DRM

Systemvoraussetzungen

E-Book

PDF mit Adobe-DRM

Systemvoraussetzungen

978-0-07-183005-8 (ISBN)

107,93 €inkl. 7% MwSt.

Systemvoraussetzungen

für ePUB mit Adobe-DRM und PDF mit Adobe-DRM

(Hinweis: Die Auswahl des von Ihnen gewünschten Dateiformats und des Kopierschutzes erfolgt erst im System des E-Book Anbieters)

E-Book Einzellizenz

Als Download verfügbar

Beschreibung

Weitere Details

Weitere Ausgaben

Inhalt

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

Systemvoraussetzungen

Dateiformat: ePUB
Kopierschutz: Adobe-DRM (Digital Rights Management)

Systemvoraussetzungen:

Computer (Windows; MacOS X; Linux): Installieren Sie bereits vor dem Download die kostenlose Software Adobe Digital Editions (siehe E-Book Hilfe).
Tablet/Smartphone (Android; iOS): Installieren Sie bereits vor dem Download die kostenlose App Adobe Digital Editions oder die App PocketBook (siehe E-Book Hilfe).
E-Book-Reader: Bookeen, Kobo, Pocketbook, Sony, Tolino u.v.a.m. (nicht Kindle)

Das Dateiformat ePUB ist sehr gut für Romane und Sachbücher geeignet – also für „fließenden” Text ohne komplexes Layout. Bei E-Readern oder Smartphones passt sich der Zeilen- und Seitenumbruch automatisch den kleinen Displays an.
Mit Adobe-DRM wird hier ein „harter” Kopierschutz verwendet. Wenn die notwendigen Voraussetzungen nicht vorliegen, können Sie das E-Book leider nicht öffnen. Daher müssen Sie bereits vor dem Download Ihre Lese-Hardware vorbereiten.

Bitte beachten Sie: Wir empfehlen Ihnen unbedingt nach Installation der Lese-Software diese mit Ihrer persönlichen Adobe-ID zu autorisieren!

Weitere Informationen finden Sie in unserer E-Book Hilfe.

Dateiformat: PDF
Kopierschutz: Adobe-DRM (Digital Rights Management)

Systemvoraussetzungen:

Computer (Windows; MacOS X; Linux): Installieren Sie bereits vor dem Download die kostenlose Software Adobe Digital Editions (siehe E-Book Hilfe).
Tablet/Smartphone (Android; iOS): Installieren Sie bereits vor dem Download die kostenlose App Adobe Digital Editions oder die App PocketBook (siehe E-Book Hilfe).
E-Book-Reader: Bookeen, Kobo, Pocketbook, Sony, Tolino u.v.a.m. (nicht Kindle)

Das Dateiformat PDF zeigt auf jeder Hardware eine Buchseite stets identisch an. Daher ist eine PDF auch für ein komplexes Layout geeignet, wie es bei Lehr- und Fachbüchern verwendet wird (Bilder, Tabellen, Spalten, Fußnoten). Bei kleinen Displays von E-Readern oder Smartphones sind PDF leider eher nervig, weil zu viel Scrollen notwendig ist.
Mit Adobe-DRM wird hier ein „harter” Kopierschutz verwendet. Wenn die notwendigen Voraussetzungen nicht vorliegen, können Sie das E-Book leider nicht öffnen. Daher müssen Sie bereits vor dem Download Ihre Lese-Hardware vorbereiten.

Bitte beachten Sie: Wir empfehlen Ihnen unbedingt nach Installation der Lese-Software diese mit Ihrer persönlichen Adobe-ID zu autorisieren!

Weitere Informationen finden Sie in unserer E-Book Hilfe.

Als PDF speichern Als Link merken