Home Page Icon
Home Page
Table of Contents for
Dedication
Close
Dedication
by Darl Kuhn
Pro Oracle Database 11g Administration
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
Understanding the Optimal Flexible Architecture
Installing Oracle
Installing with a Copy of an Existing Installation
Upgrading Oracle Software
Reinstalling After Failed Installation
Applying Interim Patches
Installing Remotely with the Graphical Installer
Summary
CHAPTER 2: Implementing a Database
Setting Operating System Variables
Creating a Database
Configuring and Implementing the Listener
Creating a Password File
Starting and Stopping the Database
Using a Response File to Create a Database
Dropping a Database
How Many Databases on One Server?
Summary
CHAPTER 3: Configuring an Efficient Environment
Customizing Your Operating System Command Prompt
Customizing Your SQL Prompt
Creating Shortcuts for Frequently Used Commands
Rerunning Commands Quickly
Setting the Command Editor
Developing Standard Scripts
Organizing Scripts
Summary
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
Managing Control Files
Managing Online Redo Logs
Summary
CHAPTER 6: Users and Basic Security
Understanding Schemas vs. Users
Managing Default Users
Creating Users
Modifying Passwords
Enforcing Password Security
Logging On as a Different User
Modifying Users
Dropping Users
Enforcing Password Security and Resource Limits
Managing Privileges
Grouping and Assigning Privileges
Summary
CHAPTER 7: Tables and Constraints
Understanding Table Types
Creating a Table
Modifying a Table
Displaying Table DDL
Dropping a Table
Undropping a Table
Removing Data from a Table
Viewing and Adjusting the High-Water Mark
Creating a Temporary Table
Creating an Index-Organized Table
Managing Constraints
Summary
CHAPTER 8: Indexes
Deciding When to Create an Index
What to Think About
Index-Management Guidelines
Creating Indexes
Specifying Index Tablespaces
Maintaining Indexes
Summary
CHAPTER 9: Views, Synonyms, and Sequences
Implementing Views
Managing Synonyms
Managing Sequences
Summary
CHAPTER 10: Data Dictionary Basics
Data-Dictionary Architecture
Logical and Physical Database Structures
Displaying User Information
Viewing Table Information
Displaying Index Information
Displaying Constraint Information
Viewing Basic Security Information
Displaying Object Dependencies
Displaying Differences in Schemas
Summary
CHAPTER 11: Large Objects
Describing Current LOB Types
Illustrating LOB Locators, Indexes, and Chunks
Distinguishing Between BasicFiles and SecureFiles
Creating a Table with a LOB Column
Maintaining LOB Columns
Using SecureFile Features
Viewing LOB Metadata
Loading LOBs
Measuring LOB Space Consumed
Summary
CHAPTER 12: Partitioning: Divide and Conquer
What Tables Should Be Partitioned?
Creating Partitioned Tables
Maintaining Partitions
Partitioning Indexes
Partition Pruning
Summary
CHAPTER 13: Data Pump
Data Pump Architecture
Exporting Data
Importing Data
Interactive Command Mode
Tips for Getting Started
Transferring Data
Exporting and Importing Tablespaces and Datafiles
Filtering Data and Objects
Common Data Pump Tasks
Monitoring Data Pump Jobs
Data Pump Legacy Mode
Summary
CHAPTER 14: External Tables
SQL*Loader vs. External Tables
Loading CSV Files into the Database
Performing Advanced Transformations
Viewing Text Files from SQL
Unloading and Loading Data Using an External Table
Preprocessing an External Table
Summary
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
Understanding RMAN
Starting RMAN
RMAN Architectural Decisions
Segueing from Decisions to Action
Using a Recovery Catalog
Summary
CHAPTER 18: RMAN Backups and Reporting
Preparing to Run RMAN Backup Commands
Running Backups
Creating Incremental Backups
Checking for Corruption in Datafiles and Backups
Logging RMAN Output
RMAN Reporting
Summary
CHAPTER 19: RMAN Restore and Recovery
Determining Media Recovery Required
Determining What to Restore
Using RMAN to Stop/Start Oracle
Complete Recovery
Restoring a Control File
Incomplete Recovery
Restoring and Recovering to Different Server
Summary
CHAPTER 20: Oracle Secure Backup
OSB Editions and Features
OSB Terminology
Download and Installation
Command-line Access to OSB
OSB Configuration
Database Backup
Database Restore
File System Backup
File System Restore
OSB Job Monitoring
Virtual Test Devices
OSB Software Upgrades
Summary
CHAPTER 21: Automating Jobs
Automating Jobs with Oracle Scheduler
Oracle Scheduler versus cron
Automating Jobs via cron
Examples of Automated DBA Jobs
Summary
CHAPTER 22: Database Troubleshooting
Quickly Triaging
Identifying Bottlenecks via Operating System Utilities
Finding Resource Intensive SQL Statements
Detecting and Resolving Locking Issues
Resolving Open Cursor Issues
Troubleshooting Undo Tablespace Issues
Handling Temporary Tablespace Issues
Auditing
Summary
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Copyright
Next
Next Chapter
Contents at a Glance
To Heidi, Brandi, and Lisa.
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset