- Cover Page
- OCP Oracle Database 11g: Administration II Exam Guide (Exam 1Z0-053)
- Copyright Page
- Contents
- Acknowledgments
- Introduction
- 1 Database Architecture and ASM
- Understanding Database Architecture and ASM
- Describe ASM
- Set Up Initialization Parameter Files for ASM and Database Instances
- Start Up and Shut Down ASM Instances
- Administer ASM Disk Groups
- Disk Group Architecture
- Disk Group Mirroring and Failure Groups
- Disk Group Dynamic Rebalancing
- Disk Group Fast Mirror Resync
- Altering Disk Groups
- Enterprise Manager Database Control and ASM Disk Groups
- Using the asmcmd Command
- Exercise 1-4 Use the asmcmd Utility to Create a Backup of the SPFILE
- Two-Minute Drill
- Self Test
- Lab Question
- Self Test Answers
- Lab Answer
- 2 Configuring Database Recoverability
- 3 Creating and Maintaining an RMAN Catalog
- Identify Situations that Require RMAN Recovery Catalog
- Create and Configure a Recovery Catalog
- Synchronize the Recovery Catalog
- Create and Use RMAN Stored Scripts
- Back Up the Recovery Catalog
- Create and Use a Virtual Private Catalog
- Configure Backup Settings
- Allocate Channels to Use in Backing Up
- Configure Backup Optimization
- 4 Creating RMAN Backups
- 5 Recovering Using RMAN Backups
- Perform Complete Recovery from a Critical or Noncritical Data File Loss Using RMAN
- Perform Incomplete Recovery Using RMAN
- Recover Using Incrementally Updated Backups
- Switch to Image Copies for Fast Recovery
- Restore a Database onto a New Host
- Recover Using a Backup Control File
- Perform Disaster Recovery
- 6 User-Managed Backup and Recovery
- Recover from a Lost Tempfile
- Recover from a Lost Redo Log Group
- Recover from the Loss of the Password File
- Perform User-Managed Complete Database Recovery
- Perform User-Managed Incomplete Database Recovery
- Perform User-Managed and Server-Managed Backups
- Identify the Need for Backup Mode
- Back up and Recover a Control File
- 7 Miscellaneous RMAN Features
- 8 Monitoring and Tuning RMAN
- 9 Configuring and Using Flashback
- Restore Dropped Tables from the Recycle Bin
- Understanding the Recycle Bin
- Querying the Recycle Bin
- Exercise 9-1 Move Objects to the Recycle Bin
- Restoring Tables from the Recycle Bin
- Exercise 9-2 Restore a Table from the Recycle Bin, Keeping the Original Dependent Object Names
- Recycle Bin Space Reclamation
- Bypassing the Recycle Bin
- Accessing Tables in the Recycle Bin
- Perform Flashback Query
- Use Flashback Transaction
- Perform Flashback Table Operations
- Set Up and Use a Flashback Data Archive
- Configure, Monitor Flashback Database and Perform Flashback Database Operations
- Restore Dropped Tables from the Recycle Bin
- 10 Memory Management Techniques
- 11 Using Database Tuning Advisors
- 12 Disk Space and Resource Management
- Manage Resumable Space Allocation
- Describe the Concepts of Transportable Tablespaces and Databases
- Reclaim Wasted Space from Tables and Indexes by Using the Segment Shrink Functionality
- Understand the Database Resource Manager
- Create and Use Database Resource Manager Components
- Understanding DEFAULT_PLAN
- Creating a New Resource Plan
- Creating and Assigning Consumer Groups
- Understanding Resource Allocation Methods
- Activating Resource Plans
- Exercise 12-4 Create and Use a New Resource Manager Plan
- Understanding Resource Manager Views
- Monitoring Resource Manager
- Two-Minute Drill
- Self Test
- Self Test Answers
- 13 Configuring Database Diagnostics
- 14 Using the Scheduler for Task Automation
- 15 Database Globalization
- A About the Download
- Glossary
- Index
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.