You are previewing Pro Oracle Database 11g Administration.
O'Reilly logo
Pro Oracle Database 11g Administration

Book Description

Pro Oracle Database 11g Administration is a book focused on results. Author Darl Kuhn draws from a well of experience over a decade deep to lay out real-world techniques that lead to success as an Oracle DBA. He gives clear explanations on how to perform critical tasks. He weaves in theory where necessary without bogging you down in unneeded detail. He is not afraid to take a stand on how things should be done. He won't leave you adrift in a sea of choices, showing you three ways to do something and then walking away.

Database administration isn't about passing a certified exam, or about pointing-and-clicking your way through a crisis. Database administration is about applying the right solution at the right time, about avoiding risk, about making robust choices that get you home each night in time for dinner with your family. If you have "buck stops here" responsibility for an Oracle database, then Pro Oracle Database 11g Administration is the book you need to help elevate yourself to the level of Professional Oracle Database Administrator.

  • Condenses and organizes the core job of a database administrator into one volume.

  • Takes a results-oriented approach to getting things done.

  • Lays a foundation upon which to build a senior level of expertise

Table of Contents

  1. Cover
  2. Title Page
  3. Copyright
  4. Dedication
  5. Contents at a Glance
  6. Contents
  7. About the Author
  8. About the Technical Reviewer
  9. Acknowledgments
  10. Introduction
  11. CHAPTER 1: Installing the Oracle Binaries
    1. Understanding the Optimal Flexible Architecture
    2. Installing Oracle
    3. Installing with a Copy of an Existing Installation
    4. Upgrading Oracle Software
    5. Reinstalling After Failed Installation
    6. Applying Interim Patches
    7. Installing Remotely with the Graphical Installer
    8. Summary
  12. CHAPTER 2: Implementing a Database
    1. Setting Operating System Variables
    2. Creating a Database
    3. Configuring and Implementing the Listener
    4. Creating a Password File
    5. Starting and Stopping the Database
    6. Using a Response File to Create a Database
    7. Dropping a Database
    8. How Many Databases on One Server?
    9. Summary
  13. CHAPTER 3: Configuring an Efficient Environment
    1. Customizing Your Operating System Command Prompt
    2. Customizing Your SQL Prompt
    3. Creating Shortcuts for Frequently Used Commands
    4. Rerunning Commands Quickly
    5. Setting the Command Editor
    6. Developing Standard Scripts
    7. Organizing Scripts
    8. Summary
  14. CHAPTER 4: Tablespaces and Datafiles
    1. Understanding the First Five
    2. Understanding the Need for More
    3. Creating Tablespaces
    4. Renaming a Tablespace
    5. Controlling the Generation of Redo
    6. Changing a Tablespace's Write Mode
    7. Dropping a Tablespace
    8. Using Oracle Managed Files
    9. Creating a Bigfile Tablespace
    10. Displaying Tablespace Size
    11. Altering Tablespace Size
    12. Toggling Datafiles Offline and Online
    13. Renaming or Relocating a Datafile
    14. Summary
  15. CHAPTER 5: Managing Control Files and Online Redo Logs
    1. Managing Control Files
    2. Managing Online Redo Logs
    3. Summary
  16. CHAPTER 6: Users and Basic Security
    1. Understanding Schemas vs. Users
    2. Managing Default Users
    3. Creating Users
    4. Modifying Passwords
    5. Enforcing Password Security
    6. Logging On as a Different User
    7. Modifying Users
    8. Dropping Users
    9. Enforcing Password Security and Resource Limits
    10. Managing Privileges
    11. Grouping and Assigning Privileges
    12. Summary
  17. CHAPTER 7: Tables and Constraints
    1. Understanding Table Types
    2. Creating a Table
    3. Modifying a Table
    4. Displaying Table DDL
    5. Dropping a Table
    6. Undropping a Table
    7. Removing Data from a Table
    8. Viewing and Adjusting the High-Water Mark
    9. Creating a Temporary Table
    10. Creating an Index-Organized Table
    11. Managing Constraints
    12. Summary
  18. CHAPTER 8: Indexes
    1. Deciding When to Create an Index
    2. What to Think About
    3. Index-Management Guidelines
    4. Creating Indexes
    5. Specifying Index Tablespaces
    6. Maintaining Indexes
    7. Summary
  19. CHAPTER 9: Views, Synonyms, and Sequences
    1. Implementing Views
    2. Managing Synonyms
    3. Managing Sequences
    4. Summary
  20. CHAPTER 10: Data Dictionary Basics
    1. Data-Dictionary Architecture
    2. Logical and Physical Database Structures
    3. Displaying User Information
    4. Viewing Table Information
    5. Displaying Index Information
    6. Displaying Constraint Information
    7. Viewing Basic Security Information
    8. Displaying Object Dependencies
    9. Displaying Differences in Schemas
    10. Summary
  21. CHAPTER 11: Large Objects
    1. Describing Current LOB Types
    2. Illustrating LOB Locators, Indexes, and Chunks
    3. Distinguishing Between BasicFiles and SecureFiles
    4. Creating a Table with a LOB Column
    5. Maintaining LOB Columns
    6. Using SecureFile Features
    7. Viewing LOB Metadata
    8. Loading LOBs
    9. Measuring LOB Space Consumed
    10. Summary
  22. CHAPTER 12: Partitioning: Divide and Conquer
    1. What Tables Should Be Partitioned?
    2. Creating Partitioned Tables
    3. Maintaining Partitions
    4. Partitioning Indexes
    5. Partition Pruning
    6. Summary
  23. CHAPTER 13: Data Pump
    1. Data Pump Architecture
    2. Exporting Data
    3. Importing Data
    4. Interactive Command Mode
    5. Tips for Getting Started
    6. Transferring Data
    7. Exporting and Importing Tablespaces and Datafiles
    8. Filtering Data and Objects
    9. Common Data Pump Tasks
    10. Monitoring Data Pump Jobs
    11. Data Pump Legacy Mode
    12. Summary
  24. CHAPTER 14: External Tables
    1. SQL*Loader vs. External Tables
    2. Loading CSV Files into the Database
    3. Performing Advanced Transformations
    4. Viewing Text Files from SQL
    5. Unloading and Loading Data Using an External Table
    6. Preprocessing an External Table
    7. Summary
  25. CHAPTER 15: Materialized Views
    1. Understanding Materialized Views
    2. Creating Basic Materialized Views
    3. Going Beyond the Basics
    4. Modifying Materialized Views
    5. Managing Materialized View Logs
    6. Refreshing Materialized Views
    7. Monitoring Materialized View Refreshes
    8. Creating Remote Materialized View Refreshes
    9. Managing Materialized Views in Groups
    10. Summary
  26. CHAPTER 16: User-Managed Backup and Recovery
    1. Implementing a Cold-Backup Strategy for a Noarchivelog-Mode Database
    2. Implementing Archivelog Mode
    3. Implementing a Hot-Backup Strategy
    4. Performing a Complete Recovery of an Archivelog-Mode Database
    5. Performing an Incomplete Recovery of an Archivelog-Mode Database
    6. Flashing Back a Table
    7. Flashing Back a Database
    8. Summary
  27. CHAPTER 17: Configuring RMAN
    1. Understanding RMAN
    2. Starting RMAN
    3. RMAN Architectural Decisions
    4. Segueing from Decisions to Action
    5. Using a Recovery Catalog
    6. Summary
  28. CHAPTER 18: RMAN Backups and Reporting
    1. Preparing to Run RMAN Backup Commands
    2. Running Backups
    3. Creating Incremental Backups
    4. Checking for Corruption in Datafiles and Backups
    5. Logging RMAN Output
    6. RMAN Reporting
    7. Summary
  29. CHAPTER 19: RMAN Restore and Recovery
    1. Determining Media Recovery Required
    2. Determining What to Restore
    3. Using RMAN to Stop/Start Oracle
    4. Complete Recovery
    5. Restoring a Control File
    6. Incomplete Recovery
    7. Restoring and Recovering to Different Server
    8. Summary
  30. CHAPTER 20: Oracle Secure Backup
    1. OSB Editions and Features
    2. OSB Terminology
    3. Download and Installation
    4. Command-line Access to OSB
    5. OSB Configuration
    6. Database Backup
    7. Database Restore
    8. File System Backup
    9. File System Restore
    10. OSB Job Monitoring
    11. Virtual Test Devices
    12. OSB Software Upgrades
    13. Summary
  31. CHAPTER 21: Automating Jobs
    1. Automating Jobs with Oracle Scheduler
    2. Oracle Scheduler versus cron
    3. Automating Jobs via cron
    4. Examples of Automated DBA Jobs
    5. Summary
  32. CHAPTER 22: Database Troubleshooting
    1. Quickly Triaging
    2. Identifying Bottlenecks via Operating System Utilities
    3. Finding Resource Intensive SQL Statements
    4. Detecting and Resolving Locking Issues
    5. Resolving Open Cursor Issues
    6. Troubleshooting Undo Tablespace Issues
    7. Handling Temporary Tablespace Issues
    8. Auditing
    9. Summary
  33. Index