Sumário Itens Encontrados: 351Chapter 1 Using Oracle ASM 1Chapter 2 Performing Oracle User-Managed Backups 55Chapter 3 Performing Oracle User-Managed Database Recoveries 103Chapter 4 Configuring and Backing Up Using RMAN 153Chapter 5 Using the RMAN Recovery Catalog 209Chapter 6 Recovering Databases with RMAN 229Chapter 7 Reporting, Monitoring, and Tuning with RMAN 279Chapter 8 Performing Oracle Advanced Recovery 313Chapter 9 Understanding Flashback Technology 349Chapter 10 Diagnosing the Database and Managing Performance 399Chapter 11 Managing Database Resources 455Chapter 12 Using the Scheduler to Automate Tasks 561Chapter 13 Implementing Globalization Support 617Appendix A Lab Exercises 679Appendix B About the Companion CD 783What Is ASM? 2Working with the ASM Instance 3Creating the ASM Instance 4Managing the ASM Instance 9Overview of ASM Data Dictionary Views 29Using ASM Storage 31What Are ASM Files? 31Defining ASM as the Default Destination forDatabase Files 34Creating a Tablespace Using an ASM Disk Group asthe Destination 35Creating a Database Using ASM Disk Group Locations 37Using RMAN with ASM 43Copying Database Datafiles to an ASM Disk with RMAN 43Creating RMAN Backups on ASM 43Summary 44Exam Essentials 45Review Questions 46Answers to Review Questions 53Understanding the Oracle Database as It Relates to Backupand Recovery 56Oracle Processes Related to Backup and Recovery 57Oracle Memory Structures Related to Backupand Recovery 58The Oracle Data Dictionary 58Oracle Datafiles and Tablespaces 61Redo Logs 62Control Files 64Parameter Files 64NOARCHIVELOG and ARCHIVELOG Modes 66The Oracle Instance and the Oracle Database 67Configuring the Database for Backup and Recovery 72Configuring for ARCHIVELOG Mode 73Putting the Database in ARCHIVELOG Mode 75Using ARCHIVELOG Mode Data Dictionary Views 79Performing Oracle Offline Backups 81Performing Oracle Online Backups 85The Mechanics of Online Backups 85Backing Up the Control File 91Creating a Backup Control File 91Creating a Trace File with the Create Control FileCommand in It 92Summary 94Exam Essentials 94Review Questions 95Answers to Review Questions 100Chapter 3 Performing Oracle User-ManagedDatabase Recoveries 103Performing a Recovery in NOARCHIVELOG Mode 104Performing a Full Database Recovery inARCHIVELOG Mode 108Preparing for the Recovery 108Recovering the Database 110Performing Incomplete Recoveries 122Requirements for and Mechanics of anIncomplete Recovery 122Preparing for an Incomplete Recovery 123Performing an Incomplete Recovery 124Performing Other Types of Recoveries 130Recovering from the Loss of a Tempfile 131Recovering from the Loss of an Online Redo Log Group 131Recovering from the Loss of a Control File 135Recovering from the Loss of the Password File 139Recovering from the Loss of Everything 139Summary 140Exam Essentials 140Review Questions 142Answers to Review Questions 150Why Use RMAN? 154Exploring the RMAN Architecture 155Connecting to RMAN 157Configuring RMAN for Use 159The Flash Recovery Area 159RMAN Persistent Configuration Settings 163Unique RMAN Configuration Settings 164Preparing RMAN for Use 165Backing Up Your Database with RMAN 179Using the RMAN Command Line 180Types of RMAN Backups 184RMAN Offline Backups 186RMAN Online Backups 187RMAN Incremental Backups 193RMAN Incrementally Updated Backups 196RMAN Multisection Backups 196RMAN Backup of Archived Redo Logs 197RMAN Backup of the Spfile and Control Files 198Backing Up RMAN Backup Sets 199Summary 199Exam Essentials 200Review Questions 201Answers to Review Questions 206Introducing the Recovery Catalog 210Creating the Recovery Catalog User and Schema Objects 211Using a Recovery Catalog 214Connecting to the Recovery Catalog from RMAN 214Registering the Target Database with theRecovery Catalog 215Unregistering a Database 216Using Scripts in the RMAN Recovery Catalog 216Executing External Scripts 217Creating Stored Scripts 217Replacing Stored Scripts 218Removing Stored Scripts 218Executing Stored Scripts 218Printing Stored Scripts 218Using Script Substitution Variables 218Maintaining the Recovery Catalog 219Synchronizing the Recovery Catalog 219Backing Up the Recovery Catalog 219Using the RMAN Virtual Private Catalog 220Creating the RMAN Virtual Private Catalog 220Administering the RMAN Virtual Private Catalog 221Summary 222Exam Essentials 222Review Questions 223Answers to Review Questions 227RMAN Database-Recovery Basics 231Recovering a Database in NOARCHIVELOG Mode 232Recovering a Database in ARCHIVELOG Mode 234Complete Database Recovery in ARCHIVELOG Mode 235Datafile or Tablespace Recovery in ARCHIVELOG Mode 240Recovering a Database Using Incomplete Recovery 248Types of Point-in-Time Recovery 249Point-in-Time Recovery Mechanics 254Using Image Copies to Recover Your Database 256Other Basic Recovery Topics 257Block Media Recovery 257Recovering the Control File 258Recovering the Spfile 264Summary 268Exam Essentials 268Review Questions 270Answers to Review Questions 276Overview of the RMAN Report and List Commands 280Using the RMAN report Command 280Using the RMAN list Command 287Monitoring, Administering, and Tuning RMAN 296Monitoring RMAN Operations 297Administering RMAN Operations 300Tuning RMAN Operations 304Summary 304Exam Essentials 305Review Questions 306Answers to Review Questions 311Switching Between RMAN Incarnations 314Overview of RMAN Database Duplication 316RMAN Database Duplication Basics 316Performing an RMAN Database Duplication 317Performing an RMAN Tablespace Point-in-Time Recovery 327TSPITR Overview 328Checking the Transport Set 330Lost Objects 331Rules, Rules, and More Rules 332TSPITR Aftereffects 332Performing a Database Disaster Recovery 336Summary 337Exam Essentials 338Review Questions 339Answers to Review Questions 346Overview of Flashback Technology 351Using Automatic Undo Management 352Uncovering Undo 352Working with Automatic Undo Management 354Understanding Undo Retention 355Using Flashback Technologies 357Using Flashback Drop and the Recycle Bin 357Using Flashback Query 367Using Flashback Versions Query 372Using Flashback Transaction Query 376Using Additional Flashback Operations 378Using Flashback Table 378Configuring and Monitoring Flashback Databaseand Performing Flashback Database Operations 382Setting Up and Using a Flashback Data Archive 387Summary 390Exam Essentials 391Review Questions 392Answers to Review Questions 397Chapter 10 Diagnosing the Database andManaging Performance 399Diagnosing the Database 400Setting Up the Automatic Diagnostic Repository 400Using the Support Workbench 403Performing Block Media Recovery 410Managing Database Performance 413Using the SQL Tuning Advisor 413Using the SQL Access Advisor to Tune a Workload 422Understanding Database Replay 428Summary 445Exam Essentials 446Review Questions 447Answers to Review Questions 452Managing Memory 457Implementing Automatic Memory Management 457Manually Configuring SGA Parameters 467Configuring Automatic PGA Memory Management 470Managing Space 475Managing Resumable Space Allocation 475Managing Transportable Tablespaces 484Managing Transportable Databases 496Using Shrinking Segments 502Managing Resources 510Working with the Pending Area 512Resource Consumer Groups 515Resource Plans 525Resource-Plan Directives 533I/O Calibration with DRM 550Resource Manager Statistics in AWR 551Summary 551Exam Essentials 552Review Questions 553Answers to Review Questions 559Automating Tasks with the Scheduler 563Exploring the Scheduler Architecture 564The Job Table 564The Job Coordinator 565The Job-Slave Processes 565RAC Considerations 566Data Guard Considerations 566Exploring Common Administration Tools 567Using the ENABLE Procedure 567Using the DISABLE Procedure 568Setting Attributes 570Using Scheduler Jobs 572Creating Jobs 572Copying Jobs 576Running Jobs 577Stopping Jobs 578Dropping Jobs 578Using Scheduler Programs 580Program Attributes 580Creating Programs 581Dropping Programs 583Using Schedules 583Schedule Attributes 584Creating Schedules 584Setting Repeat Intervals 585Testing Repeat Intervals 587Creating Lightweight Jobs 589Using Job Chains 591Creating a Chain 592Defining Chain Steps 592Adding Rules to a Chain 593Enabling a Chain 595Creating Jobs for Chains 595Using Scheduler Windows 597Creating Windows 598Opening and Closing Windows 599Window Logging 600Purging Logs 601Creating and Using Job Classes 602Job Class Parameters 602Creating Job Classes 603Dropping Job Classes 604Using Advanced Scheduler Concepts to Prioritize Jobs 604Prioritizing Jobs within a Job Class 605Using Scheduler Views 605Summary 607Exam Essentials 609Review Questions 610Answers to Review Questions 615An Overview of Globalization Support 618Globalization Support Features 619Globalization Support Architecture 620Supporting Multilingual Applications 622Using Unicode in a Multilingual Database 625Using NLS Parameters 626Setting NLS Parameters 627Prioritizing NLS Parameters 640Using NLS Views 643Using Datetime Datatypes 646Using the DATE Datatype 647Using the TIMESTAMP Datatype 652Using the TIMESTAMP WITH TIME ZONE Datatype 653Using the TIMESTAMP WITH LOCAL TIMEZONE Datatype 654Using Linguistic Sorts and Searches 657An Overview of Text Sorting 657Using Linguistic Sort Parameters 660Linguistic Sort Types 666Searching Linguistic Strings 669Summary 671Exam Essentials 672Review Questions 673Answers to Review Questions 677Lab 1.1: Creating an ASM Instance 680Lab 1.2: Creating ASM Disk Groups 682Lab 1.3: Using ASM Disk Groups from a Database 685Lab 2.1: Executing a Manual Offline (Cold) Backup 688Lab 2.2: Putting the Database in ARCHIVELOG Mode 691Lab 2.3: Executing a Manual Online (Hot) Backup 693Lab 3.1: Executing a Time-Based Point-in-Time Recovery 697Lab 3.2: Recovering from Control-File Loss with aBackup Control File 700Lab 3.3: Recovering from Loss of the Current OnlineRedo Log 704Lab 4.1: Creating an RMAN Offline Backup 707Lab 4.2: Creating an RMAN Incremental Backup 709Lab 4.3: Creating an Image-Copy Backup 711Lab 5.1: Implementing RVPC 713Lab 6.1: Restoring a Datafile Online 714Lab 6.2: Performing a Change-Based Recovery with RMAN 718Lab 6.3: Restoring a Control File from an Autobackup 720Lab 7.1: Monitoring RMAN Backups 723Lab 7.2: One of My Backups Is Missing! 725Lab 8.1: Duplicating a Database Using Active DatabaseDuplication 727Lab 8.2: Duplicating a Database Using Backup-BasedDuplication to a Different Point in Time 731Lab 9.1: Using the Recycle Bin 737Lab 9.2: Performing a More Complex FlashbackQuery Analysis 738Lab 9.3: Using Flashback Data Archive 744Lab 10.1: Using Support Workbench to Report a Problemto Oracle Support 747Lab 10.2: Performing Block Media Recovery 748Lab 11.1: Exporting a Transportable Tablespace 757Lab 11.2: Testing Resumable Space Allocation 759Lab 11.3: Manually Configuring the SGA 761Lab 12.1: Creating a Local External Job 763Lab 12.2: Creating a Job Window 765Lab 13.1: Using the Locale Builder to Create aNew Linguistic Sort 767Lab 13.2: Setting NLS Parameters 769Lab 13.3: Performing Linguistic Sorts 776What Youâll Find on the CD 784Sybex Test Engine 784PDF of the Book 784Adobe Reader 784Electronic Flashcards 785System Requirements 785Using the CD 785Troubleshooting 786Customer Care 786Glossary 787Index 801