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
- Cover
- Title Page
- Copyright
- Dedication
- Contents at a Glance
- Contents
- About the Author
- About the Technical Reviewer
- Acknowledgments
- Introduction
- CHAPTER 1: Installing the Oracle Binaries
- CHAPTER 2: Implementing a Database
- CHAPTER 3: Configuring an Efficient Environment
-
CHAPTER 4: Tablespaces and Datafiles
- Understanding the First Five
- Understanding the Need for More
- Creating Tablespaces
- Renaming a Tablespace
- Controlling the Generation of Redo
- Changing a Tablespace's Write Mode
- Dropping a Tablespace
- Using Oracle Managed Files
- Creating a Bigfile Tablespace
- Displaying Tablespace Size
- Altering Tablespace Size
- Toggling Datafiles Offline and Online
- Renaming or Relocating a Datafile
- Summary
- CHAPTER 5: Managing Control Files and Online Redo Logs
- CHAPTER 6: Users and Basic Security
- CHAPTER 7: Tables and Constraints
- CHAPTER 8: Indexes
- CHAPTER 9: Views, Synonyms, and Sequences
- CHAPTER 10: Data Dictionary Basics
- CHAPTER 11: Large Objects
- CHAPTER 12: Partitioning: Divide and Conquer
- CHAPTER 13: Data Pump
- CHAPTER 14: External Tables
-
CHAPTER 15: Materialized Views
- Understanding Materialized Views
- Creating Basic Materialized Views
- Going Beyond the Basics
- Modifying Materialized Views
- Managing Materialized View Logs
- Refreshing Materialized Views
- Monitoring Materialized View Refreshes
- Creating Remote Materialized View Refreshes
- Managing Materialized Views in Groups
- Summary
-
CHAPTER 16: User-Managed Backup and Recovery
- Implementing a Cold-Backup Strategy for a Noarchivelog-Mode Database
- Implementing Archivelog Mode
- Implementing a Hot-Backup Strategy
- Performing a Complete Recovery of an Archivelog-Mode Database
- Performing an Incomplete Recovery of an Archivelog-Mode Database
- Flashing Back a Table
- Flashing Back a Database
- Summary
- CHAPTER 17: Configuring RMAN
- CHAPTER 18: RMAN Backups and Reporting
- CHAPTER 19: RMAN Restore and Recovery
- CHAPTER 20: Oracle Secure Backup
- CHAPTER 21: Automating Jobs
- CHAPTER 22: Database Troubleshooting
- Index
Product information
- Title: Pro Oracle Database 11g Administration
- Author(s):
- Release date: December 2010
- Publisher(s): Apress
- ISBN: 9781430229704
You might also like
book
Oracle Database 11g New Features
FOREWORD by Tom Kyte Your Must-Have Guide to Everything New in Oracle Database 11 g Realize …
book
Pro Oracle Database 11g RAC on Linux
Pro Oracle Database 11g RAC on Linux provides full-life-cycle guidance on implementing Oracle Real Application Clusters …
book
Oracle Database 11g DBA Handbook
The Essential Resource for Oracle DBAs--Fully Updated and Expanded Manage a flexible, highly available Oracle database …
book
Oracle 11g R1/R2 Real Application Clusters Essentials
In this book you’ll find a practical tutorial on configuring, installing, and designing Oracle 11g Real …