OCP Oracle Database 11g: Administration II Exam Guide (Exam 1Z0-053)
by Bob Bryla
OCP Oracle Database 11g: Administration II Exam Guide (Exam 1Z0-053)
- 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
ABOUT THE AUTHOR
Bob Bryla is an Oracle 9i, 10g, and 11g Certified Professional with more than 20 years of experience in database design, database application development, training, and Oracle database administration. He is the primary Internet database designer and an Oracle DBA at Lands’ End in Dodgeville, Wisconsin.
In his spare time, he is a technical editor for a number of Oracle Press and Apress books, in addition to authoring several certification study guides for Oracle 10g and 11g. He has also been known to watch science fiction movies and dabble in videography in his spare time.
About the Technical Editor
Gavin Powell has a BSc. in Computer Science with 20 years of experience in the IT industry. He does Oracle DBA and Internet marketing consulting work, is an accomplished computer technical writer (more than 20 works in print), and is also a semi-professional songwriter, performer, and recording artist. Gavin can be reached at [email protected], [email protected], or http://oracledba.ezpowell.com.
-
No Comment