Oracle Database 2 Day DBA, 10g Release 2 (10.2) B14196-02

Contents......Page 3
Documentation Accessibility......Page 11
Structure......Page 12
Related Documentation......Page 13
Conventions......Page 14
How to Use this Book with Related Material......Page 15
Tools for Administering the Database......Page 16
Checking Prerequisites......Page 19
Basic Installation......Page 20
Advanced Installation......Page 21
Installing Oracle Software and Database......Page 22
Using DBCA to Create and Configure a Database......Page 24
Creating a Database with DBCA......Page 25
Storage Options......Page 26
Database Content......Page 27
Initialization Parameters......Page 28
Database Creation Options......Page 29
Types of Templates......Page 30
Creating Templates Using DBCA......Page 31
Overview of the Database Upgrade Assistant......Page 32
Support for Silent Mode......Page 33
Starting the Database Upgrade Assistant......Page 34
Upgrading the Database Using the Database Upgrade Assistant......Page 35
Installation: Oracle by Example Series......Page 39
Database Management Features......Page 41
Starting and Stopping the Oracle Enterprise Manager Console......Page 42
Accessing the Oracle Enterprise Manager Database Control......Page 43
Granting Database Control Administrative Privileges......Page 44
Defining Blackout Periods......Page 45
SQL Statements and Other Management Tools: SQL*Plus and iSQL*Plus......Page 46
Managing Your Database: A Roadmap......Page 47
Getting Started: Oracle by Example Series......Page 48
Oracle Net Listener Configuration......Page 49
Naming Methods......Page 50
Oracle Net Configuration Assistant......Page 51
Viewing Listener Configuration......Page 52
Configuring Oracle Networking on Client Machines......Page 53
Networking: Oracle by Example Series......Page 54
Overview of an Instance and Instance Management......Page 55
The System Global Area (SGA)......Page 56
Oracle Background Processes......Page 57
About Database Administration Privileges......Page 58
Network Connections......Page 59
Starting and Shutting Down the Database Instance on Windows......Page 60
Viewing and Modifying Initialization Parameters......Page 61
Instances: Oracle by Example Series......Page 63
Exploring the Storage Structure of Your Database......Page 65
Online Redo Log Files......Page 66
Multiplexing the Redo Log......Page 67
Datafiles......Page 68
Tablespace Type......Page 69
Some Tablespaces in the Database......Page 70
Initialization Parameter File......Page 71
Creating a Tablespace......Page 72
Modifying a Tablespace......Page 73
Reclaiming Wasted Space......Page 74
Viewing Segment Advisor Recommendations......Page 75
About Undo Data......Page 78
Automatic Undo Management......Page 79
Managing Undo with Enterprise Manager......Page 80
Using the Undo Advisor......Page 81
Gaining Advice from Undo Advisor......Page 82
Extending the Undo Tablespace......Page 83
Storage: Oracle by Example Series......Page 84
Overview of Users and Security......Page 85
Sample Schemas......Page 86
About Privileges and Roles......Page 87
SYS......Page 88
Viewing Roles......Page 89
Modifying Roles......Page 90
Administering Profiles......Page 91
Creating Users......Page 92
Changing the Tablespace Quota for a User......Page 94
Granting Roles......Page 95
Users: Oracle by Example Series......Page 96
Exploring Database Schema Objects......Page 97
Managing Tables......Page 98
Column Attributes......Page 99
Storage Attributes......Page 101
Viewing Tables......Page 102
Viewing Table Data......Page 103
Creating Tables......Page 104
Creating a Table: Example......Page 105
Creating a New Table Constraint......Page 107
Modifying an Existing Constraint......Page 108
Loading Data Into Tables......Page 109
Managing Indexes......Page 111
Index Types......Page 112
Viewing Indexes......Page 113
Dropping Indexes......Page 114
About Views......Page 115
Creating a View: Example......Page 116
Managing Database-Resident Program Units......Page 117
Viewing Packages......Page 118
Editing Packages......Page 119
Viewing Package Bodies......Page 120
Managing Triggers......Page 121
Schemas: Oracle by Example Series......Page 122
Overview of Database Backup and Recovery......Page 123
Consistent and Inconsistent Backups......Page 124
The Flash Recovery Area......Page 125
Retention Policy and the Flash Recovery Area......Page 126
Sizing the Flash Recovery Area......Page 127
Configuring the Flash Recovery Area......Page 128
Configuring ARCHIVELOG Mode For the Database......Page 129
Understanding Backup Device Settings for Disk......Page 130
Configuring Backup Policy Settings......Page 131
Incremental Backups of Datafiles......Page 132
Performing a Whole Database Backup with Oracle Enterprise Manager......Page 133
Using the Oracle-Suggested Backup Strategy......Page 137
Validating Backups and Testing Your Backup Strategy......Page 138
Performing Restore and Recovery Operations......Page 139
Recovering a Whole Database from Backup......Page 140
Validating the Restore of Datafiles from RMAN Backup......Page 142
Enabling Row Movement on a Table......Page 143
Performing Flashback Table......Page 144
Recovering Dropped Tables: Flashback Drop......Page 145
Backup Management: Concepts......Page 146
Using the Manage Current Backups Page......Page 147
Managing Current Backups: Image Copies......Page 149
Crosschecking Backups......Page 150
Deleting Expired Backups......Page 151
Displaying Backup Reports......Page 152
Backup and Recovery: Oracle by Example Series......Page 154
Alerts......Page 155
Monitoring General Database State and Workload......Page 156
Viewing Metrics and Thresholds......Page 158
Setting Metric Thresholds......Page 160
Responding to Alerts......Page 161
Setting up Direct Alert Notification......Page 162
Responding to Performance Findings......Page 163
Running ADDM Manually......Page 164
About Performance Advisors......Page 165
Using the SQL Tuning Advisor......Page 167
Using the SQL Access Advisor......Page 168
Setting New SGA or PGA Targets......Page 169
Determining Performance Impact for Altering your SGA or PGA......Page 170
Monitoring and Tuning: Oracle by Example Series......Page 171
Determining your Oracle Software Environment......Page 173
Determining the Location of your Oracle Home......Page 174
Setting Your Oracle MetaLink Credentials......Page 175
Staging the Patch Release......Page 176
Installing the Patch Release......Page 178
Managing Oracle Software: Oracle by Example Series......Page 179
What is Automatic Storage Management?......Page 181
Overview of Disks, Disk Groups, and Failure Groups......Page 182
Accessing the Automatic Storage Management Home Page......Page 183
Accessing the ASM Home Page on a Single Instance System......Page 184
Monitoring Disk Group Space Usage......Page 185
Creating a Disk Group......Page 186
Dropping a Disk Group......Page 188
Adding Disks to a Disk Group......Page 189
Dropping Disks from a Disk Group......Page 191
Automatic Storage Management: Oracle by Example Series......Page 192
Real Application Clusters Database Configuration Scenario......Page 193
Overview of the Cluster Database Home Page......Page 194
Navigating to Oracle Enterprise Manager Cluster-Related Pages......Page 196
Viewing and Modifying Real Application Clusters Initialization Parameters......Page 197
Starting and Stopping Individual Instances in Real Application Clusters Databases......Page 198
Redo Log Groups and Redo Threads in Real Application Cluster Databases......Page 199
Overview of Restore and Recovery Operations for a Real Application Clusters Database......Page 200
Real Application Clusters: Oracle by Example Series......Page 201
C......Page 203
E......Page 204
O......Page 205
S......Page 206
V......Page 207