Verkauf durch Sack Fachmedien

Freeman / Pack

Ocp: Oracle Database 12c Administrator Certified Professional Study Guide: Exam 1z0-063

Medium: Buch
ISBN: 978-1-118-64407-2
Verlag: SYBEX INC
Erscheinungstermin: 21.10.2014
Lieferfrist: bis zu 10 Tage

An updated guide for an updated certification exam!

As the most popular database software in the world, Oracle Database 12c has been updated for the first time in nearly six years and the changes are significant. This study guide reviews how Oracle 12c allows multiple instances to be used simultaneously via the cloud. You'll sharpen your skills to prepare for the three levels of certification: Oracle Certified Associate, Oracle Certified Professional, and Oracle Certified Master. Workbook exercise appendix, test engine, chapter review questions, electronic flashcards, searchable PDF glossary, and two bonus practice exams all help to enhance your preparation to take the Oracle 12c exam.
* Addresses such topics as: database architecture, configuring and recoverability, configuring backup specifications, and performing user-managed backup and recovery
* Reviews how to use RMAN to create backups, perform recovery, and duplicate a database
* Looks at performing tablespace point-in-time recovery and using flashback technology
* Covers diagnosing the database, managing memory, managing resources, and automating tasks

Focusing 100 percent on the exam objectives, OCP: Oracle Database 12c Administrator Certified Professional Study Guide is designed for those who feel they are ready to attempt this challenging exam.


Produkteigenschaften


  • Artikelnummer: 9781118644072
  • Medium: Buch
  • ISBN: 978-1-118-64407-2
  • Verlag: SYBEX INC
  • Erscheinungstermin: 21.10.2014
  • Sprache(n): Englisch
  • Auflage: 1. Auflage 2014
  • Produktform: Kartoniert
  • Gewicht: 1022 g
  • Seiten: 768
  • Format (B x H x T): 187 x 236 x 40 mm
  • Ausgabetyp: Kein, Unbekannt
Autoren/Hrsg.

Autoren

Introduction xxiAssessment Test xxxiiiChapter 1 Performing Oracle User-Managed Backups 1Oracle Database Data Protection Options 2What Kind of Failures Can Happen to a Database 2Physical and Logical Backups 3Tools for Backup and Recovery 3Oracle MAA Recommendations 4Understanding the Oracle Database as It Relates to Backup and Recovery 5Oracle Processes Related to Backup and Recovery 6Oracle Memory Structures Related to Backup and Recovery 8The Oracle Data Dictionary 8Oracle Data Files and Tablespaces 11Redo Logs 12Control File 14Parameter Files 15NOARCHIVELOG and ARCHIVELOG Modes 17The Oracle Instance and the Oracle Database 18Configuring the Database for Backup and Recovery 26Configuring for ARCHIVELOG Mode 26Putting the Database in ARCHIVELOG Mode 29Using ARCHIVELOG Mode Data Dictionary Views 33Performing Oracle Offline Backups 36Performing Oracle Online Backups 40The Mechanics of Online Backups 40Backing Up the Control File 46Creating a Backup Control File 46Creating a Trace File with the Create CONTROLFILE Command in It 47Summary 49Exam Essentials 50Review Questions 51Chapter 2 Performing Oracle User-Managed Database Recoveries 57Performing a Recovery in NOARCHIVELOG Mode 58Performing a Full Database Recovery in ARCHIVELOG Mode 62Preparing for the Recovery 62Recovering the Database 64Performing User-Based Incomplete Recoveries 77Requirements for and Mechanics of an Incomplete Recovery 77Preparing for an Incomplete Recovery 77Performing an Incomplete Recovery 79Performing Other Types of Recoveries 85Recovering from the Loss of a Tempfile 85Recovering from the Loss of an Online Redo Log Group 85Recovering from the Loss of a Control File 89Recovering from the Loss of the Password File 93Recovering from the Loss of Everything 93Summary 94Exam Essentials 95Review Questions 96Chapter 3 Configuring and Backing Up Oracle Databases Using RMAN 105Why Use RMAN? 107Exploring the RMAN Architecture 108Getting Started with RMAN 110Starting the RMAN Interface 110The SYSBACKUP Privilege 111The RMAN Command Line 113The RMAN Command Prompt 114Calling SQL from the RMAN Command Prompt 114Configuring RMAN 115The Fast Recovery Area 116RMAN Persistent Configuration Settings 119Unique RMAN Configuration Settings 120Preparing RMAN for Use 121Backing Up Your Database with RMAN 136Using the RMAN Command Line 136Types of RMAN Backups 141RMAN Offline Backups 145RMAN Online Backups 145RMAN Incremental Backups 151RMAN Incrementally Updated Backups 154RMAN Multisection Backups 155RMAN Backup of Archived Redo Logs 156RMAN Backup of the Spfile and Control Files 157Backing Up RMAN Backup Sets 158Backing Up the RMAN FRA 158Creating Archival Backups 159Summary 159Exam Essentials 160Review Questions 161Chapter 4 Using the RMAN Recovery Catalog 167Introducing the Recovery Catalog 168Creating the Recovery Catalog User and Schema Objects 170Using a Recovery Catalog 172Connecting to the Recovery Catalog from RMAN 173Registering the Target Database with the Recovery Catalog 174Unregistering a Database 174Using Scripts in the RMAN Recovery Catalog 175Executing External Scripts 175Creating Stored Scripts 176Using Script Substitution Variables 177Maintaining the Recovery Catalog 177Dropping the Recovery Catalog 178Upgrading the Recovery Catalog 178Synchronizing the Recovery Catalog 178Export and Import the Recovery Catalog 178Backing Up the Recovery Catalog 179Recreating an Unrecoverable Recovery Catalog 179Using the RMAN Virtual Private Catalog 181Creating the RMAN Virtual Private Catalog 181Administering the RMAN Virtual Private Catalog 182Summary 183Exam Essentials 183Review Questions 185Chapter 5 Recovering Databases with RMAN 189RMAN Database-Recovery Basics 191Recovering a Database in NOARCHIVELOG Mode 192Recovering a Database in ARCHIVELOG Mode 194Complete Database Recovery in ARCHIVELOG Mode 195Data File or Tablespace Recovery in ARCHIVELOG Mode 200Recovering a Database Using Incomplete Recovery 209Types of Point-in-Time Recovery 209Point-in-Time Recovery Mechanics 214Using Image Copies to Recover Your Database 217Other Basic Recovery Topics 218Block Media Recovery 218Recovering the Control File 219Recovering the Spfile 224Recovering the Database Password File 229Clearing Redo Logs 229Summary 230Exam Essentials 230Review Questions 232Chapter 6 Tuning and Monitoring RMAN and the Automatic Diagnostic Workflow 239Overview of the RMAN Report and List Commands 240Using the RMAN REPORT Command 240Using the RMAN LIST Command 247Monitoring, Administering, and Tuning RMAN 256Monitoring RMAN Operations 257Administering RMAN Operations 260Tuning RMAN Operations 263The Oracle Database Fault Diagnostic Framework 264Overview of the Oracle Database FaultDiagnostic Framework 265The Oracle ADR 267Problems and Incidents 269The Automatic Diagnostic Workflow--Managing Problems and Incidents 270Components Related to the Fault Diagnosability Framework 271Enterprise Manager Support Workbench 272The ADRCI Command-Line Utility 273Summary 275Exam Essentials 275Review Questions 277Chapter 7 Performing Oracle Advanced Recovery 283Switching between RMAN Incarnations 285Overview of RMAN Database Duplication 287RMAN Database Duplication Basics 287Performing an RMAN Database Duplication 289Performing an RMAN Tablespace Point-in-Time Recovery 299TSPITR Overview 300Checking the Transport Set 302Lost Objects 303Rules, Rules, and More Rules 304TSPITR Aftereffects 304Restoring a Database to a New Host 308Using RMAN to Move a Database 308Oracle Data Pump, Oracle GoldenGate and Oracle Data Guard 310Complete Disaster 310Backup Best Practices for Data Warehouses 311The First Execution of the Command 312The Second Execution of the Command 313The Third Execution of the Command 313Restoring from Incrementally Updated Backups 315Performing Table and Partition Recovery from Backups 315Things to Check Before Trying to Restore and Recover Database Tables and Partitions 316Restrictions When Restoring and Recovering Database Tables and Partitions 317Options to Consider When Performing Table or Table Partition Restores 317An Example of Using RMAN to Restore and Recover a Database Table 318ASM-Related Backups 320Quick ASM Overview 321ASM Diskgroup Metadata Backups 321Restoring ASM Disk Groups 323Configuring and Using Oracle Secure Backup 323What Is OSB? 324How Does OSB Interface with RMAN? 325The OSB Architecture 325Installing and Configuring OSB 327Oracle Database 12c Multitenant Architecture and RMAN 329Architecture Overview 329Backing Up CDBs with RMAN 330Backing Up PDBs with RMAN 331Recovering CDBs and PDBs with RMAN 332Duplicating a PDB with RMAN 333Oracle Data Pump and Oracle Multitenant 334The Data Recovery Advisor 335Summary 339Exam Essentials 340Review Questions 341Chapter 8 Understanding Flashback Technology 349Describe the Flashback Technologies 351Managing Undo Automatically 352Uncovering Undo 352Working with Automatic Undo Management 354Preserving Data with Undo Retention 355Employing Flashback Technologies 357Recovering Tables and Objects with Flashback Drop and the Recycle Bin 357Use Flashback to Query Data 368Recovering Data with Flashback Version Query 373Detecting Changes with Flashback Transaction Query 376Perform Flashback Table Operations 379Describe and Use Flashback Data Archive 383Perform Flashback Database Operations 385Summary 390Exam Essentials 391Review Questions 392Chapter 9 Diagnosing the Database and Managing Performance 399Diagnosing Failures 400Setting Up the Automatic Diagnostic Repository 400Using the Support Workbench 404Performing Block Media Recovery 414Managing Database Performance 416Using the SQL Tuning Advisor 417Using the SQL Access Advisor to Tune a Workload 424Perform Database Replay 430Summary 448Exam Essentials 449Review Questions 450Chapter 10 Managing Database Resources 455Managing Storage 456Managing Resumable Space Allocation 456Managing Transportable Tablespaces 466Managing Transportable Databases 479Shrinking Segments 486Managing Storage in a CDB and PDBs 494Manage Permanent and Temporary Tablespaces in CDB and PDBs 495Summary 497Exam Essentials 497Review Questions 498Chapter 11 Creating Oracle Multitenant Databases 503Multitenant Container and Pluggable Database Architecture 504Describing the Multitenant Architecture 504Explaining Pluggable Database Provisioning 507Creating Multitenant Container Databases and Pluggable Databases 508Creating and Configuring a CDB 508Creating a PDB Using Different Methods 517Unplugging and Dropping a PDB 534Migrating a Pre-12.1 Non-CDB Database to a CDB 542Summary 544Exam Essentials 544Review Questions 545Chapter 12 Managing Oracle Multitenant Databases 551Establishing Connections to CDB/PDB 552User Accounts in a CDB 553Establishing Connections to a CDB 554Establishing Connections to a PDB 558Start Up and Shut Down a CDB and Open and Close PDBs 564Starting Up the CDB Using SQL*Plus 564Shutting Down the CDB 567Opening a PDB 570Shutting Down or Closing a PDB 572Evaluate the Impact of Parameter Value Changes 574AUDIT_FILE_DEST 574AUDIT_SYS_OPERATIONS 575AUDIT_SYSLOG_LEVEL 575AUDIT_TRAIL 575ENABLE_PLUGGABLE_DATABASE 576LDAP_DIRECTORY_ACCESS 576MAX_STRING_SIZE 576NONCDB_COMPATIBLE 576PDB_FILE_NAME_CONVERT 577RESOURCE_MANAGER_PLAN 577SESSIONS 577Summary 578Exam Essentials 578Review Questions 580Chapter 13 Oracle Utilities 585Moving Data, Performing Security Operations, and Interacting with Other Oracle Products 586Using Data Pump 587Understanding and Using SQL*Loader 595Audit Operations 603Using Other Products with CDBs and PDBs--Database Vault, Data Guard, LogMiner 606Summary 616Exam Essentials 616Review Questions 618Chapter 14 Oracle Security in CDBs and PDBs 623Managing Security in a CDB and PDBs 624Managing Common and Local Users 625Managing Common and Local Privileges 636Managing Common and Local Roles 642Enabling Common Users to Access Data in Specific PDBs 648Summary 653Exam Essentials 654Review Questions 655Appendix A Answers to Review Questions 661Chapter 1: Performing Oracle User-Managed Backups 662Chapter 2: Performing Oracle User-Managed Database Recoveries 664Chapter 3: Configuring and Backing Up Oracle Databases Using RMAN 666Chapter 4: Using the RMAN Recovery Catalog 668Chapter 5: Recovering Databases with RMAN 669Chapter 6: Tuning and Monitoring RMAN and the Automatic Diagnostic Workflow 671Chapter 7: Performing Oracle Advanced Recovery 672Chapter 8: Understanding Flashback Technology 674Chapter 9: Diagnosing the Database and Managing Performance 676Chapter 10: Managing Database Resources 678Chapter 11: Creating Oracle Multitenant Databases 680Chapter 12: Managing Oracle Multitenant Databases 681Chapter 13: Oracle Utilities 682Chapter 14: Oracle Security in CDBs and PDBs 684Appendix B About the Additional Study Tools 687Additional Study Tools 688Sybex Test Engine 688Electronic Flashcards 688Bonus Lab Exercises 688Glossary 688Adobe Reader 689System Requirements 689Using the Study Tools 689Troubleshooting 689Customer Care 690Index 691