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

Description

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