OCP: Oracle® Database 11g Administrator Certified Professional Study Guide (1Z0-053) -- About the Authors -- Contents at a Glance -- Contents -- Table of Exercises -- Introduction -- Assessment Test -- Answers to Assessment Test -- Chapter 1: Using Oracle ASM -- What Is ASM? -- Working with the ASM Instance -- Overview of ASM Data Dictionary Views -- Using ASM Storage -- Using RMAN with ASM -- Summary -- Exam Essentials -- Review Questions -- Answers to Review Questions -- Chapter 2: Performing Oracle User-Managed Backups -- Understanding the Oracle Database as It Relates to Backup and Recovery -- Configuring the Database for Backup and Recovery -- Performing Oracle Offline Backups -- Performing Oracle Online Backups -- Backing Up the Control File -- Summary -- Exam Essentials -- Review Questions -- Answers to Review Questions -- Chapter 3: Performing Oracle User-Managed Database Recoveries -- Performing a Recovery in NOARCHIVELOG Mode -- Performing a Full Database Recovery in ARCHIVELOG Mode -- Performing Incomplete Recoveries -- Performing Other Types of Recoveries -- Summary -- Exam Essentials -- Review Questions -- Answers to Review Questions -- Chapter 4: Configuring and Backing Up Using RMAN -- Why Use RMAN? -- Exploring the RMAN Architecture -- Connecting to RMAN -- Configuring RMAN for Use -- Backing Up Your Database with RMAN -- Summary -- Exam Essentials -- Review Questions -- Answers to Review Questions -- Chapter 5: Using the RMAN Recovery Catalog -- Introducing the Recovery Catalog -- Creating the Recovery Catalog User and Schema Objects -- Using a Recovery Catalog -- Using Scripts in the RMAN Recovery Catalog -- Maintaining the Recovery Catalog -- Using the RMAN Virtual Private Catalog -- Summary -- Exam Essentials -- Review Questions -- Answers to Review Questions -- Chapter 6: Recovering Databases with RMAN.

RMAN Database-Recovery Basics -- Recovering a Database in NOARCHIVELOG Mode -- Recovering a Database in ARCHIVELOG Mode -- Recovering a Database Using Incomplete Recovery -- Using Image Copies to Recover Your Database -- Other Basic Recovery Topics -- Summary -- Exam Essentials -- Review Questions -- Answers to Review Questions -- Chapter 7: Reporting, Monitoring, and Tuning with RMAN -- Overview of the RMAN Report and List Commands -- Monitoring, Administering, and Tuning RMAN -- Summary -- Exam Essentials -- Review Questions -- Answers to Review Questions -- Chapter 8: Performing Oracle Advanced Recovery -- Switching Between RMAN Incarnations -- Overview of RMAN Database Duplication -- Performing an RMAN Tablespace Point-in-Time Recovery -- Performing a Database Disaster Recovery -- Summary -- Exam Essentials -- Review Questions -- Answers to Review Questions -- Chapter 9: Understanding Flashback Technology -- Overview of Flashback Technology -- Using Automatic Undo Management -- Using Flashback Technologies -- Using Additional Flashback Operations -- Summary -- Exam Essentials -- Review Questions -- Answers to Review Questions -- Chapter 10: Diagnosing the Database and Managing Performance -- Diagnosing the Database -- Managing Database Performance -- Summary -- Exam Essentials -- Review Questions -- Answers to Review Questions -- Chapter 11: Managing Database Resources -- Managing Memory -- Managing Space -- Managing Resources -- Summary -- Exam Essentials -- Review Questions -- Answers to Review Questions -- Chapter 12: Using the Scheduler to Automate Tasks -- Automating Tasks with the Scheduler -- Exploring the Scheduler Architecture -- Exploring Common Administration Tools -- Using Scheduler Jobs -- Using Scheduler Programs -- Using Schedules -- Creating Lightweight Jobs -- Using Job Chains -- Using Scheduler Windows.

Creating and Using Job Classes -- Using Advanced Scheduler Concepts to Prioritize Jobs -- Using Scheduler Views -- Summary -- Exam Essentials -- Review Questions -- Answers to Review Questions -- Chapter 13: Implementing Globalization Support -- An Overview of Globalization Support -- Using NLS Parameters -- Using Datetime Datatypes -- Using Linguistic Sorts and Searches -- Summary -- Exam Essentials -- Review Questions -- Answers to Review Questions -- Appendix A: Lab Exercises -- Lab 1.1: Creating an ASM Instance -- Lab 1.2: Creating ASM Disk Groups -- Lab 1.3: Using ASM Disk Groups from a Database -- Lab 2.1: Executing a Manual Offline (Cold) Backup -- Lab 2.2: Putting the Database in ARCHIVELOG Mode -- Lab 2.3: Executing a Manual Online (Hot) Backup -- Lab 3.1: Executing a Time-Based Point-in-Time Recovery -- Lab 3.2: Recovering from Control-File Loss with a Backup Control File -- Lab 3.3: Recovering from Loss of the Current Online Redo Log -- Lab 4.1: Creating an RMAN Offline Backup -- Lab 4.2: Creating an RMAN Incremental Backup -- Lab 4.3: Creating an Image-Copy Backup -- Lab 5.1: Implementing RVPC -- Lab 6.1: Restoring a Datafile Online -- Lab 6.2: Performing a Change-Based Recovery with RMAN -- Lab 6.3: Restoring a Control File from an Autobackup -- Lab 7.1: Monitoring RMAN Backups -- Lab 7.2: One of My Backups Is Missing! -- Lab 8.1: Duplicating a Database Using Active Database Duplication -- Lab 8.2: Duplicating a Database Using Backup-Based Duplication to a Different Point in Time -- Lab 9.1: Using the Recycle Bin -- Lab 9.2: Performing a More Complex Flashback Query Analysis -- Lab 9.3: Using Flashback Data Archive -- Lab 10.1: Using Support Workbench to Report a Problem to Oracle Support -- Lab 10.2: Performing Block Media Recovery -- Lab 11.1: Exporting a Transportable Tablespace -- Lab 11.2: Testing Resumable Space Allocation.

Lab 11.3: Manually Configuring the SGA -- Lab 12.1: Creating a Local External Job -- Lab 12.2: Creating a Job Window -- Lab 13.1: Using the Locale Builder to Create a New Linguistic Sort -- Lab 13.2: Setting NLS Parameters -- Lab 13.3: Performing Linguistic Sorts -- Appendix B: About the Companion CD -- What You'll Find on the CD -- System Requirements -- Using the CD -- Troubleshooting -- Glossary -- Index.