Sumário Itens Encontrados: 371Chapter 1 Performing Oracle User-Managed Backups 1Chapter 2 Performing Oracle User-Managed Database Recoveries 57Chapter 3 Configuring and Backing Up Oracle DatabasesUsing RMAN 105Chapter 4 Using the RMAN Recovery Catalog 167Chapter 5 Recovering Databases with RMAN 189Chapter 6 Tuning and Monitoring RMAN and the AutomaticDiagnostic Workflow 239Chapter 7 Performing Oracle Advanced Recovery 283Chapter 8 Understanding Flashback Technology 349Chapter 9 Diagnosing the Database and Managing Performance 399Chapter 10 Managing Database Resources 455Chapter 11 Creating Oracle Multitenant Databases 503Chapter 12 Managing Oracle Multitenant Databases 551Chapter 13 Oracle Utilities 585Chapter 14 Oracle Security in CDBs and PDBs 623Appendix A Answers to Review Questions 661Appendix B About the Additional Study Tools 687Index 691Oracle 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 andRecovery 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 CONTROLFILECommand in It 47Summary 49Exam Essentials 50Review Questions 51Chapter 2 Performing Oracle User-ManagedDatabase 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 OracleDatabases 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 161Introducing 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 185RMAN 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 inARCHIVELOG 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 theAutomatic 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âManagingProblems and Incidents 270Components Related to the FaultDiagnosability Framework 271Enterprise Manager Support Workbench 272The ADRCI Command-Line Utility 273Summary 275Exam Essentials 275Review Questions 277Switching 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 andOracle 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 andRecover Database Tables and Partitions 316Restrictions When Restoring and RecoveringDatabase Tables and Partitions 317Options to Consider When Performing Table orTable Partition Restores 317An Example of Using RMAN to Restore andRecover 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 341Describe 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 Dropand 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 andManaging 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 450Managing 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 inCDB and PDBs 495Summary 497Exam Essentials 497Review Questions 498Multitenant Container and Pluggable Database Architecture 504Describing the Multitenant Architecture 504Explaining Pluggable Database Provisioning 507Creating Multitenant Container Databases andPluggable 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 545Establishing 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 580Moving Data,Performing Security Operations,andInteracting 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 618Managing 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 655Chapter 1: Performing Oracle User-Managed Backups 662Chapter 2: Performing Oracle User-ManagedDatabase Recoveries 664Chapter 3: Configuring and Backing Up OracleDatabases Using RMAN 666Chapter 4: Using the RMAN Recovery Catalog 668Chapter 5: Recovering Databases with RMAN 669Chapter 6: Tuning and Monitoring RMAN and theAutomatic Diagnostic Workflow 671Chapter 7: Performing Oracle Advanced Recovery 672Chapter 8: Understanding Flashback Technology 674Chapter 9: Diagnosing the Database andManaging 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 684Additional Study Tools 688Sybex Test Engine 688Electronic Flashcards 688Bonus Lab Exercises 688Glossary 688Adobe Reader 689System Requirements 689Using the Study Tools 689Troubleshooting 689Customer Care 690Table of ExercisesExercise 1.1 Putting a Database in ARCHIVELOG Mode . 31Exercise 1.2 Putting the V$ Views to Work . 34Exercise 1.3 Executing an Offline Backup 36Exercise 1.4 Executing an Online Backup . 42Exercise 2.1 Restoring a Database Using a Cold Backup 59Exercise 2.2 Recovering the Database from the Loss of All Data Files . 67Exercise 2.3 Performing a Point-in-Time Recovery . 81Exercise 3.1 Configuring RMAN 134Exercise 3.2 Executing an Online Backup . 148Exercise 4.1 Creating a Recovery Catalog Schema . 171Exercise 5.1 Restoring Your ARCHIVELOG-Mode Database with RMAN . 197Exercise 5.2 Perform a Point-in-Time Recovery with RMAN 211Exercise 6.1 Using the REPORT Command 245Exercise 6.2 Using the LIST Command . 253Exercise 7.1 Duplicating a Database Using Backup-Based Duplication . 294Exercise 7.2 Performing a Tablespace Point-in-Time Recovery . 305Exercise 8.1 Purging a Table from the Recycle Bin 364Exercise 8.2 Using Flashback Query . 371Exercise 8.3 Using Flashback Table . 382Exercise 9.1 Setting the Diagnostic Destination 402Exercise 9.2 Using the ADRCI . 411Exercise 9.3 Using the SQL Access Advisor . 430Exercise 9.4 Performing Database Replay 448Exercise 10.1 Exporting a Transportable Tablespace Set . 475Exercise 10.2 Shrinking a Segment . 494Exercise 11.1 Creating a New CDB Using SQL*Plus 513Exercise 11.2 Creating a PDB Using SQL*Plus . 524Exercise 11.3 Using Data Pump to Migrate a Non-CDB into a PDB . 543Exercise 12.1 Connecting to a CDB Using SQL*Plus . 555Exercise 12.2 Connecting to a PDB Using SQL*Plus 559Exercise 13.1 Using Data Pump to Migrate a Non-CDB into a PDB . 590Exercise 13.2 Plugging a Database VaultâEnabled PDB into a CDB 607Exercise 13.3 Steps for Using LogMiner . 614Exercise 14.1 Creating Common and Local Users . 634