Oracle 11g Database Administration
Part 1: Oracle 11g Administration Workshop I
A. Exploring the Oracle Database Architecture
1. Oracle Database Architecture Overview 2. Interacting with an Oracle Database 3. Process Architecture
4. Database Storage Architecture
5. Logical and Physical Database Structures 6. Tablespaces and Data Files
7. SYSTEM and SYSAUX Tablespaces 8. Segments, Extents, and Blocks B. Preparing the Database Environment
9. Tasks of an Oracle Database Administrator 10. Tools Used to Administer an Oracle Database 11. Installation: System Requirements
12. Optimal Flexible Architecture (OFA) 13. Setting Environment Variables 14. Oracle Universal Installer (OUI) 15. Database Configuration Options 16. Advanced Installation Options C. Creating an Oracle Database
17. Planning the Database 18. Configuring the Listener
19. Using the DBCA to Create a Database 20. Password Management
21. Creating a Database Design Template 22. Using the DBCA to Delete a Database 23. Using DBCA For Additional Tasks D. Managing the Oracle Instance
24. Management Framework 25. Oracle Enterprise Manager 26. Initialization Parameter
27. Database Startup and Shutdown 28. Shutdown Modes
29. Viewing the Alert History 30. Using Trace Files
31. Data Dictionary: Overview
E. Configuring the Oracle Network Environment
32. Oracle Net Services & Listener 33. Establishing Net Connections
34. Tools for Configuring and Managing the Oracle Network 35. Net Services Administration Pages
36. Naming Methods 37. Directory Naming 38. SGA and PGA
39. When Not to Use a Shared Server F. Managing Database Storage Structures
40. Storage Structures 41. How Table Data Is Stored 42. Anatomy of a Database Block 43. Space Management in Tablespaces
44. Tablespaces in the Pre-configured Database 45. Actions with Tablespaces
46. Oracle Managed Files (OMF) 47. ASM: Concepts
G. Administering User Security 48. Database User Accounts
49. Predefined Accounts: SYS and SYSTEM
50. Administrator Authentication 51. Benefits of Roles
52. Predefined Roles
53. Implementing Password Security Features 54. Assigning Quota to Users
H. Managing Schema Objects
55. What Is a Schema?
56. Accessing Schema Objects 57. Specifying Data Types in Tables 58. Creating and Modifying Tables 59. Understanding Data Integrity 60. Indexes & Views
61. Sequences 62. Temporary Tables
I. Managing Data and Concurrency
63. Manipulating Data Through SQL 64. PL/SQL
65. Administering PL/SQL Objects
66. Functions, Procedures, Packages & Triggers 67. Data Concurrency
68. Enqueue Mechanism
69. Resolving Lock Conflicts Using SQL 70. Deadlocks
J. Managing Undo Data
71. Data Manipulation
72. Transactions and Undo Data 73. Undo Data Versus Redo Data 74. Configuring Undo Retention 75. Guaranteeing Undo Retention 76. Using the Undo Advisor
77. Viewing System Activity
K. Implementing Oracle Database Security
78. Industry Security Requirements 79. Principle of Least Privilege 80. Monitoring for Compliance 81. Value-Based Auditing 82. Fine-Grained Auditing 83. DBA Auditing
84. Security Updates
85. Applying Security Patches L. Database Maintenance
86. Introducing Terminology 87. Optimizer Statistics
88. Automatic Workload Repository (AWR)
89. Automatic Database Diagnostic Monitor (ADDM) 90. Advisory Framework
91. Automated Maintenance Tasks 92. Server-Generated Alerts
93. Reacting to Alerts M. Performance Management
94. Performance Monitoring
95. Managing Memory Components
96. Enabling Automatic Memory Management (AMM) 97. Automatic Shared Memory Advisor
98. Using Memory Advisors
99. Dynamic Performance Statistics 100. Troubleshooting and Tuning Views 101. Invalid and Unusable Objects N. Backup and Recovery Concepts
102. Part of Your Job 103. Statement Failure 104. User Error
105. Understanding Instance Recovery 106. Phases of Instance Recovery 107. Using the MTTR Advisor
108. Media Failure 109. Archive Log Files O. Performing Database Backups
110. Backup Solutions: Overview 111. Oracle Secure Backup 112. User-Managed Backup 113. Terminology
114. Recovery Manager (RMAN) 115. Configuring Backup Settings
116. Backing Up the Control File to a Trace File 117. Monitoring the Flash Recovery Area P. Performing Database Recovery
118. Opening a Database 119. Data Recovery Advisor 120. Loss of a Control File 121. Loss of a Redo Log File 122. Data Recovery Advisor 123. Data Failures
124. Listing Data Failures
125. Data Recovery Advisor Views Q. Moving Data
126. Moving Data: General Architecture 127. Directory Object: Overview
128. SQL*Loader: Overview 129. Data Pump: Overview
130. Performance Initialization Parameters
131. Using Enterprise Manager to Monitor Data Pump Jobs 132. Data Dictionary
R. Enhancing Database Capabilities 133. Using EM Support Workbench 134. Create a Service Request
135. Package and upload diagnostic data to Oracle Support 136. Track the SR and Implement Repairs
137. Incident Packaging Configuration 138. Working with Oracle Support 139. MetaLink Integration
140. Managing Patches
Part 2: Oracle 11g Administration Workshop II
A. Database Architecture and ASM
1. Oracle Database Architecture Overview 2. ASM General Architecture
3. Creating an ASM Instance
4. Using Enterprise Manager to Manage ASM Users 5. ASM Storage Concepts
6. The ASMCMD Utility
7. ASM Scalability and Performance B. Configuring for Recoverability
8. Purpose of Backup and Recovery Functionality 9. Typical Backup and Recovery Tasks
10. Oracle Backup and Recovery Solutions 11. Using Recovery Manager (RMAN) 12. Using a Flash Recovery Area
13. Flash Recovery Area Space Management C. Using the RMAN Recovery Catalog
14. RMAN Repository Data Storage: Comparison of Options 15. Storing Information in the Recovery Catalog
16. Registering a Database in the Recovery Catalog 17. Recovery Catalog Resynchronization: Concepts 18. Using RMAN Stored Scripts
19. Backing Up and Recovering the Recovery Catalog 20. Using a Virtual Private Catalog
D. Configuring Backup Specifications
21. Using RMAN to Create Backups
22. Configuring Persistent Settings for RMAN
23. Using Enterprise Manager to Configure RMAN Settings 24. Control File Auto-backups
25. Managing Persistent Settings 26. Configuring Devices for Backup
27. Configuring and Allocating Channels for Use in Backups 28. Configuring Backup Optimization
E. Creating Backups
29. Creating an Oracle-Suggested Backup 30. Creating Backup Sets & Image Copies 31. Creating a Whole Database Backup 32. RMAN Backup Types
33. Monitoring Block Change Tracking 34. Creating Duplex Backup Sets 35. Archival Backups: Concepts 36. Encrypting Backups
F. Performing User-Managed Backup and Recovery
37. Restoring and Recovering 38. Causes of File Loss
39. Critical Versus Non-critical 40. Recovering from a TEMPFILE Loss 41. Re-creating Indexes
42. Recovering from a Lost Index Tablespace
43. Authentication Methods for Database Administrators 44. Recovering a Read-Only Tablespace
G. Using RMAN to Perform Recovery
45. Using RMAN RESTORE and RECOVER Commands 46. Performing Recovery Using Enterprise Manager 47. Recovery Using Incrementally Updated Backups 48. Perform a Fast Switch to Image Copies
49. Restoring and Recovering the Database on a New Host 50. Performing Disaster Recovery
H. Using RMAN to Duplicate a Database
51. Using RMAN to Create a Duplicate Database 52. Creating a Duplicate Database
53. Creating an Initialization Parameter File for the Auxiliary Instance 54. Allocating Auxiliary Channels
55. Understanding the RMAN Duplication Operation 56. Using EM to Clone a Database
57. Cloning a Running Database
I. Performing Tablespace Point-in-time Recovery
58. Tablespace Point-in-Time Recovery (TSPITR) Concepts 59. Tablespace Point-in-Time Recovery: Architecture 60. Understanding When to Use TSPITR
61. Determining the Tablespaces for the Recovery Set 62. Using Enterprise Manager to Perform TSPITR
63. Understanding TSPITR Processing 64. Troubleshooting RMAN TSPITR J. Monitoring and Tuning RMAN
65. Parallelization of Backup Sets 66. Monitoring RMAN Sessions
67. Interpreting RMAN Message Output 68. Using the DEBUG Option
69. Tuning RMAN 70. RMAN Multiplexing
71. Comparing Synchronous and Asynchronous I/O 72. Tape Subsystem Performance Rules
K. Using Flashback Technology
73. Flashback Technology 74. Transactions and Undo
75. Guaranteeing Undo Retention
76. Preparing Your Database for Flashback 77. Flashback Drop and the Recycle Bin 78. Using Flashback Technology to Query Data
79. Possible Workflow
80. Flashback Transaction Wizard L. Using Flashback Database
81. Flashback Table
82. Enabling Row Movement on a Table 83. Enabling Row Movement on a Table 84. Flashback Database Architecture 85. Configuring Flashback Database
86. Performing Flashback Database Using EM 87. Flashback Database Considerations 88. Flashback Data Archive
M. Diagnosing the Database
89. Automatic Diagnostic Workflow & Repository 90. Location for Diagnostic Traces
91. Viewing the Alert Log Using Enterprise Manager
92. The Support Workbench and Oracle Configuration Manager 93. Create a Service Request
94. Package and upload diagnostic data to Oracle Support 95. Incident Packaging Configuration
96. Health Monitor Overview & Data Recovery Advisor N. Managing Memory
97. Oracle Memory Structures
98. Automatic Memory Management Overview 99. Oracle Database Memory Parameters 100. Auto Memory Parameter Dependency
101. Automatic Shared Memory Management: Overview 102. Automatic PGA Memory Management
103. Using the Memory Advisor to Size the SGA 104. Memory Tuning Guidelines for the Library Cache O. Managing Database Performance
105. Tuning Activities
106. Performance Planning & Performance Tuning Methodology 107. Instance Tuning
108. Troubleshooting and Tuning Views 109. Automatic Workload Repository 110. SQL Tuning & SQL Advisors 111. Using the SQL Tuning Advisor 112. SQL Access Advisor: Overview P. Using the Segment Advisor
113. Space Management: Overview 114. Proactive Tablespace Monitoring
115. Thresholds and Resolving Space Problems 116. Monitoring Tablespace Space Usage 117. Shrinking Segments
118. Space Reclamation with ASSM 119. Automatic Segment Advisor 120. Minimum Compatibility Level Q. Managing Resources
121. Database Resource Manager: Overview 122. Database Resource Manager Concepts 123. Accessing Resource Plans
124. Default Maintenance Resource Manager Plan 125. Creating Consumer Groups
126. Resource Allocation Methods for Resource Plans 127. Resource Allocation Methods for Resource Plans 128. Monitoring the Resource Manager
R. Automating Tasks with the Scheduler
129. Simplifying Management Tasks 130. Key Components and Steps
131. Creating an Event-Based Schedule 132. Creating Complex Schedules 133. Creating Job Chains
134. Creating Job Chains
S. Administering the Scheduler
135. Advanced Scheduler Concepts 136. Job Classes
137. Windows
138. Prioritizing Jobs Within a Window 139. Remote Jobs
140. Installing the Scheduler Agent
141. Dictionary Views Supporting Remote Jobs T. Globalization
142. Globalization Support Features 143. What Every DBA Needs to Know 144. Understanding Unicode
145. Database Character Sets and National Character Sets 146. Language- and Territory-Dependent Parameters 147. Linguistic Searching and Sorting
148. Case- and Accent-Insensitive Search and Sort 149. NLS Data Conversion with Oracle Utilities