| |
| |
| Preface | |
| |
| |
| |
| Recovery Manager | |
| |
| |
| The Current Challenge at Keller Medical Center | |
| |
| |
| Set Up Your Computer for the Chapter | |
| |
| |
| Important Terms | |
| |
| |
| Backup Methods | |
| |
| |
| User-managed Backups | |
| |
| |
| Backups Using Recovery Manager | |
| |
| |
| Recovery Manager | |
| |
| |
| RMAN Architecture | |
| |
| |
| Connecting to RMAN | |
| |
| |
| The RMAN Repository | |
| |
| |
| Configuring Channel Allocation | |
| |
| |
| Persistent Parameters of RMAN | |
| |
| |
| Chapter Summary | |
| |
| |
| Syntax Guide | |
| |
| |
| Review Questions | |
| |
| |
| Hands-On Assignments | |
| |
| |
| Case Study | |
| |
| |
| |
| Backups Using RMAN | |
| |
| |
| The Current Challenge at Keller Medical Center | |
| |
| |
| Backing Up the Database Using RMAN | |
| |
| |
| The Flash Recovery Area | |
| |
| |
| Backup Using RMAN | |
| |
| |
| Types of Backup | |
| |
| |
| Parallelizing Backups | |
| |
| |
| Performing Backups | |
| |
| |
| The BACKUP Command | |
| |
| |
| Backup Command Options | |
| |
| |
| Examples of Backing Up the Database | |
| |
| |
| The RUN Command | |
| |
| |
| Creating a Script | |
| |
| |
| Setting Duration and Throttling | |
| |
| |
| Block Change Tracking | |
| |
| |
| Backups Using Enterprise Manager | |
| |
| |
| Monitoring RMAN Backups | |
| |
| |
| RMAN Commands | |
| |
| |
| The LIST command | |
| |
| |
| The REPORT Command | |
| |
| |
| Chapter Summary | |
| |
| |
| Syntax Guide | |
| |
| |
| Review Questions | |
| |
| |
| Hands-On Assignments | |
| |
| |
| Case Study | |
| |
| |
| |
| Recovery in Oracle 10g | |
| |
| |
| The Current Challenge at Keller Medical Center | |
| |
| |
| Setup for this Chapter | |
| |
| |
| Recovery Options | |
| |
| |
| Recovering the database in Noarchivelog Mode | |
| |
| |
| Recovering the database in Archivelog Mode | |
| |
| |
| Recovery in the Database | |
| |
| |
| Performing Complete Recovery Manually | |
| |
| |
| RMAN Commands for Complete Recovery | |
| |
| |
| Incomplete Recovery | |
| |
| |
| Guidelines When Performing Incomplete Recovery | |
| |
| |
| Basic Steps for Performing an Incomplete Recovery | |
| |
| |
| Incomplete Recovery Methods | |
| |
| |
| Recovery of Non-critical Files | |
| |
| |
| Re-creating the password file | |
| |
| |
| Recovery of the temporary tablespace | |
| |
| |
| Recreating a redo log file | |
| |
| |
| Recovering an index tablespace | |
| |
| |
| Recovering a read-only tablespace | |
| |
| |
| Chapter Summary | |
| |
| |
| Syntax Guide | |
| |
| |
| Review Questions | |
| |
| |
| Hands-On Assignments | |
| |
| |
| Case Study | |
| |
| |
| |
| Flashback Database | |
| |
| |
| The Current Challenge at Keller Medical Center | |
| |
| |
| Overview of Flashback Database | |
| |
| |
| Components for Flashback Database | |
| |
| |
| Guidelines of Flashback Database | |
| |
| |
| Restrictions of Flashback Database | |
| |
| |
| Configuring Flashback Database | |
| |
| |
| Performing the Flashback Database | |
| |
| |
| The FLASHBACK DATABASE Command in SQL | |
| |
| |
| The FLASHBACK DATABASE Command in RMAN | |
| |
| |
| Failures that May Occur During a Flashback Operation | |
| |
| |
| Options Available After a Flashback Database | |
| |
| |
| Excluding a Tablespace from Flashback | |
| |
| |
| Managing Flashback Database | |
| |
| |
| Monitoring Flashback Logs | |
| |
| |
| Flashback and Datafile Operations | |
| |
| |
| Disabling Flashback Database | |
| |
| |
| Chapter Summary | |
| |
| |
| Syntax Guide | |
| |
| |
| Review Questions | |
| |
| |
| Hands-On Assignments | |
| |
| |
| Case Study | |
| |
| |
| |
| Recovering from User Errors | |
| |
| |
| The Current Challenge at Keller Medical Center | |
| |
| |
| Setup for the Chapter | |
| |
| |
| Flashback Drop | |
| |
| |
| The RECYCLE BIN | |
| |
| |
| Performing a Flashback Drop | |
| |
| |
| Purging a Table | |
| |
| |
| The Flashback Query Feature | |
| |
| |
| Understanding Undo Retention | |
| |
| |
| Performing a Flashback Query | |
| |
| |
| Flashback Versions Query feature | |
| |
| |
| Performing the Flashback Versions Query | |
| |
| |
| Flashback Transaction Query Feature | |
| |
| |
| Performing the Flashback Transaction Query | |
| |
| |
| Flashback Table | |
| |
| |
| Performing the Flashback Table | |
| |
| |
| Chapter Summary | |
| |
| |
| Syntax Guide | |
| |
| |
| Review Questions | |
| |
| |
| Hands-On Assignments | |
| |
| |
| Case Study | |
| |
| |
| |
| Handling Block Corruption | |
| |
| |
| The Current Challenge at Keller Medical Center | |
| |
| |
| Setup for the Chapter | |
| |
| |
| Blocks and Block Corruption | |
| |
| |
| Identifying Block Corruption | |
| |
| |
| Error Messages | |
| |
| |
| The Alert Log File and Trace Files | |
| |
| |
| The ANALYZE command | |
| |
| |
| The DBVERIFY utility | |
| |
| |
| The DB_BLOCK_CHECKSUM and DB_BLOCK_CHECKING Initialization Parameters | |
| |
| |
| The V$ Views | |
| |
| |
| Recovering from Block Corruption | |
| |
| |
| Restoring and Recovering Corrupt Blocks Using a Backup | |
| |
| |
| The DBMS_REPAIR Package | |
| |
| |
| RMAN and Block Corruption | |
| |
| |
| Dropping and Re-creating the Object | |
| |
| |
| Chapter Summary | |
| |
| |
| Syntax Guide | |
| |
| |
| Review Questions | |
| |
| |
| Hands-On Assignments | |
| |
| |
| Case Study | |
| |
| |
| |
| Automatic Database Management | |
| |
| |
| The Current Challenge at Keller Medical Center | |
| |
| |
| Setup for the Chapter | |
| |
| |
| An Overview of Performance Tuning | |
| |
| |
| Common Manageability Infrastructure | |
| |
| |
| Automatic Workload Repository (AWR) | |
| |
| |
| The Advisory Framework | |
| |
| |
| Automatic Undo Retention Tuning | |
| |
| |
| Chapter Summary | |
| |
| |
| Syntax Guide | |
| |
| |
| Review Questions | |
| |
| |
| Hands-On Assignments | |
| |
| |
| Case Study | |
| |
| |
| |
| Database Resource Manager | |
| |
| |
| The Current Challenge at Keller Medical Center | |
| |
| |
| Setup for the Chapter | |
| |
| |
| Terminology | |
| |
| |
| Overview of Database Resource Manager | |
| |
| |
| Configuring DRM | |
| |
| |
| Consumer Groups | |
| |
| |
| Resource Plans | |
| |
| |
| Resource Plan Directives | |
| |
| |
| Putting the Pieces Together | |
| |
| |
| Automatic Mapping of Sessions to Consumer Groups | |
| |
| |
| Relevant Data Dictionary Views | |
| |
| |
| DRM using Enterprise Manager | |
| |
| |
| Chapter Summary | |
| |
| |
| Syntax Guide | |
| |
| |
| Review Questions | |
| |
| |
| Hands-On Assignments | |
| |
| |
| Case Study | |
| |
| |
| |
| The Scheduler | |
| |
| |
| The Current Challenge at Keller Medical Center | |
| |
| |
| Setup for the Chapter | |
| |
| |
| The Oracle Scheduler | |
| |
| |
| The Scheduler Architecture | |
| |
| |
| Working with the Scheduler | |
| |
| |
| Other important procedures | |
| |
| |
| Advanced Scheduler Components | |
| |
| |
| Statistics Gathering in the Oracle Database | |
| |
| |
| Object Statistics | |
| |
| |
| Viewing Information from Enterprise Manager | |
| |
| |
| Relevant Data Dictionary Views | |
| |
| |
| Chapter Summary | |
| |
| |
| Syntax Guide | |
| |
| |
| Review Questions | |
| |
| |
| Hands-On Assignments | |
| |
| |
| Case Study | |
| |
| |
| |
| Space Management | |
| |
| |
| The Current Challenge at Keller Medical Center | |
| |
| |
| Setup for the Chapter | |
| |
| |
| Tablespaces and Proactive Monitoring | |
| |
| |
| Server-Generated Alerts | |
| |
| |
| Server-Generated Alerts and Tablespace Usage | |
| |
| |
| Segments in the Oracle Database | |
| |
| |
| Indexed Organized Tables (IOTs) | |
| |
| |
| Clusters | |
| |
| |
| Segment Shrink Functionality | |
| |
| |
| The Segment Advisor | |
| |
| |
| Other Space Management Tools | |
| |
| |
| The Undo Advisor | |
| |
| |
| Redo Log File Size Advisor | |
| |
| |
| Managing Resumable Space Allocation | |
| |
| |
| The DBMS_RESUMABLE Package | |
| |
| |
| Chapter Summary | |
| |
| |
| Syntax Guide | |
| |
| |
| Review Questions | |
| |
| |
| Hands-On Assignments | |
| |
| |
| Case Study | |
| |
| |
| |
| Automatic Memory Management | |
| |
| |
| The Current Challenge at Keller Medical Center | |
| |
| |
| Memory Structures of the Database | |
| |
| |
| The SYSTEM GLOBAL AREA (SGA) | |
| |
| |
| Automatic Shared Memory Management (ASMM) | |
| |
| |
| The Program Global Area (PGA) | |
| |
| |
| Chapter Summary | |
| |
| |
| Syntax Guide | |
| |
| |
| Review Questions | |
| |
| |
| Hands-On Assignments | |
| |
| |
| Case Study | |
| |
| |
| |
| Automatic Storage Management | |
| |
| |
| The Current Challenge at Keller Medical Center | |
| |
| |
| Setup for the Chapter | |
| |
| |
| An Overview of ASM | |
| |
| |
| ASM Architecture | |
| |
| |
| Basic Terminology | |
| |
| |
| ASM Components | |
| |
| |
| Administering ASM | |
| |
| |
| Starting and Shutting Down the ASM Instance | |
| |
| |
| ASM Filenames | |
| |
| |
| Managing ASM Diskgroups | |
| |
| |
| Creating a Diskgroup | |
| |
| |
| Dropping a Diskgroup | |
| |
| |
| Adding Disks to a Diskgroup | |
| |
| |
| Dropping Disks from a Diskgroup | |
| |
| |
| Undropping Disks from a Diskgroup | |
| |
| |
| Manually Rebalancing a Diskgroup | |
| |
| |
| Mounting Diskgroups | |
| |
| |
| Dismounting a Diskgroup | |
| |
| |
| Obtaining Data Dictionary Information | |
| |
| |
| Migrating a Database to ASM Using RMAN | |
| |
| |
| Chapter Summary | |
| |
| |
| Syntax Guide | |
| |
| |
| Review Questions | |
| |
| |
| Hands-On Assignments | |
| |
| |
| Case Study | |
| |
| |
| |
| Globalization Support | |
| |
| |
| The Current Challenge at Keller Medical Center | |
| |
| |
| Setup for the Chapter | |
| |
| |
| Why Globalization? | |
| |
| |
| Character Encoding and Character Sets | |
| |
| |
| Character Sets | |
| |
| |
| Length Semantics | |
| |
| |
| The Unicode Character Set | |
| |
| |
| Character Sets and the Oracle Database | |
| |
| |
| National Language Support | |
| |
| |
| The NLS_LANG Parameter | |
| |
| |
| The NLS_LANGUAGE Parameter | |
| |
| |
| The NLS_TERRITORY Parameter | |
| |
| |
| Other Initialization parameters | |
| |
| |
| NLS Views | |
| |
| |
| Date-time Datatypes | |
| |
| |
| The Date Datatype | |
| |
| |
| The Timestamp Datatype | |
| |
| |
| Timestamp with Time Zone Datatype | |
| |
| |
| Timestamp with Local Time Zone Datatype | |
| |
| |
| Sorting Capabilities and Linguistic Sorting | |
| |
| |
| Binary Sort | |
| |
| |
| Linguistic Sorting | |
| |
| |
| The Oracle Locale Builder | |
| |
| |
| Chapter Summary | |
| |
| |
| Syntax Guide | |
| |
| |
| Review Questions | |
| |
| |
| Hands-On Assignments | |
| |
| |
| Case Study | |
| |
| |
| |
| Diagnostic Tools and the Oracle Listener | |
| |
| |
| Setup for the Chapter | |
| |
| |
| The Current Challenge at Keller Medical Center | |
| |
| |
| Diagnostic Tools | |
| |
| |
| The Alert Log File | |
| |
| |
| Trace Files | |
| |
| |
| User Trace Files | |
| |
| |
| The Listener Process | |
| |
| |
| The Listener Control Utility (LSNRCTL.EXE) | |
| |
| |
| Managing the Listener using Enterprise Manager | |
| |
| |
| Vulnerabilities of the Listener | |
| |
| |
| Securing the Listener | |
| |
| |
| Chapter Summary | |
| |
| |
| Syntax Guide | |
| |
| |
| Review Questions | |
| |
| |
| Hands-On Assignments | |
| |
| |
| Case Study | |
| |
| |
| |
| Oracle Architecture | |
| |
| |
| Oracle Instance | |
| |
| |
| Oracle Database | |
| |
| |
| The Physical Structure of the Database | |
| |
| |
| The Logical Structure of the Database | |
| |
| |
| Archiving in the Oracle Database | |
| |
| |
| Automatic Undo Management | |
| |
| |
| The Oracle Data Dictionary | |
| |
| |
| Accessing the Database | |
| |
| |
| |
| Enterprise Manager | |
| |
| |
| Overview of Enterprise Manager | |
| |
| |
| Launching Enterprise Manager | |
| |
| |
| The Database Control Home Page | |
| |
| |
| Glossary | |
| |
| |
| Index | |