Skip Headers
Oracle® Database 2 Day DBA
11
g
Release 2 (11.2)
Part Number E10897-07
Home
Book List
Index
Contact Us
Next
PDF
·
Mobi
·
ePub
Contents
List of Figures
List of Tables
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documentation
Conventions
1
Introduction
About This Guide
What This Guide Is Not
How to Use This Guide with Related Material
About Oracle Database
Common Oracle DBA Tasks
Tools for Administering the Database
2
Installing Oracle Database and Creating a Database
Overview of Installing Oracle Database Software and Creating a Database
Checking Prerequisites
Deciding on Installation Choices
Install Options
Installation Method
Installation Type
Software Installation Directories
Database File Location
Database Identifiers
About Advanced Installation
Installing Oracle Database Software
Creating and Managing a Database with DBCA
Starting DBCA
Creating a Database Using DBCA
Step 2 - Database Templates
Step 3 - Database Identification
Step 4 - Management Options
Step 5 - Database Credentials
Step 6 - Database File Locations
Step 7 - Recovery Configuration
Step 8 - Database Content
Step 9 - Initialization Parameters
Step 10 - Database Storage
Step 11 - Creation Options
Changing the Configuration of a Database Using DBCA
Deleting a Database Using DBCA
Managing Templates with DBCA
Advantages of Using Templates
Types of Templates
DBCA Templates Provided by Oracle
Creating Templates Using DBCA
Deleting Templates
Installation: Oracle By Example Series
3
Getting Started with Database Administration
Managing Your Database: A Roadmap
Introduction to Oracle Enterprise Manager Database Control
Configuring the Operating System Environment Variables
Starting and Stopping the Database Control Console Process
Accessing the Database Home Page
Granting Access to Database Control for Nonadministrative Users
Creating Database Control Administrative Users
Setting Database Control Preferences
About Database Control Preferences
Defining Blackout Periods
Setting Preferred Credentials
Administering the Database with SQL-Based Management Tools
About SQL
About SQL*Plus
Starting SQL*Plus and Connecting to the Database
About SQL Developer
Getting Started with Oracle Enterprise Manager: Oracle By Example Series
4
Configuring the Network Environment
Understanding Network Configuration
Oracle Net Listener Configuration
Client Connections
Tools for Network Configuration
Viewing Listener Configuration
Starting and Stopping the Listener
Connecting to an Oracle Database from a Client Computer
Networking: Oracle By Example Series
5
Managing the Oracle Instance
Overview of the Oracle Instance and Instance Management
About Initialization Parameters
About Background Processes
About Server and Client Processes
About Instance Memory Structure
System Global Area
Program Global Area
About Instance Startup and Shutdown
About Administration Privileges for Startup and Shutdown
About Instance Startup
About Instance Shutdown
Shutting Down and Starting Up the Oracle Instance
Shutting Down and Starting Up Using Oracle Enterprise Manager Database Control
Shutting Down and Starting Up Using the Windows Services Program
Viewing and Modifying Initialization Parameters
Managing Memory
About Memory Management
Enabling Automatic Memory Management
Modifying Memory Settings – Automatic Memory Management
Modifying Memory Settings – Automatic Shared Memory Management
Modifying Memory Settings – Automatic PGA Memory Management
Instances: Oracle By Example Series
6
Managing Database Storage Structures
About Database Storage Structures
About Control Files
About Online Redo Log Files
About Archived Redo Log Files
About Rollback Segments
About Data Files
About Tablespaces
Locally Managed Tablespaces
Tablespace Types
Tablespace Status
Autoextend Tablespace
Encrypted Tablespaces
About Other Storage Structures
Viewing Database Storage Structure Information
Viewing Control File Information
Viewing Online Redo Log File Information
Viewing Archived Redo Log File Information
Viewing Data File Information
Viewing Tablespace Information
Performing Common Database Storage Tasks
Creating a Tablespace
Modifying a Tablespace
Setting a Tablespace to Automatically Extend
Changing Space Usage Alert Thresholds for a Tablespace
Taking a Tablespace Offline
Dropping a Tablespace
Reclaiming Unused Space
About Reclaimable Unused Space
About the Segment Advisor
Viewing Segment Advisor Recommendations and Reclaiming Space
Running the Segment Advisor Manually
Managing the Online Redo Log
Multiplexing the Online Redo Log
Switching a Log File
Managing Undo Data
About Undo Data
About Managing Undo Data
Viewing Undo Information
Computing the Minimum Undo Tablespace Size Using the Undo Advisor
Changing the Undo Tablespace to a Fixed Size
Storage: Oracle By Example Series
7
Administering User Accounts and Security
About User Accounts
About User Privileges and Roles
About Administrative Accounts and Privileges
SYS and SYSTEM Users
SYSDBA and SYSOPER System Privileges
Administering Roles
Viewing Roles
Example: Creating a Role
Example: Modifying a Role
Deleting a Role
Administering Database User Accounts
Viewing User Accounts
Example: Creating a User Account
Creating a New User Account by Duplicating an Existing User Account
Example: Granting Privileges and Roles to a User Account
Example: Assigning a Tablespace Quota to a User Account
Example: Modifying a User Account
Locking and Unlocking User Accounts
Expiring a User Password
Example: Deleting a User Account
Setting the Database Password Policy
About Password Policies
Modifying the Default Password Policy
Users: Oracle By Example Series
8
Managing Schema Objects
About Schema Objects
About Schema Object Management Privileges
Managing Tables
About Tables
About Table Types
About Table Column Attributes
About Table-Level Constraints
Other Table Creation Considerations
Viewing Tables
Viewing Table Data
Example: Creating a Table
Modifying Table Attributes
Example: Adding Table Columns
Example: Deleting a Table Column
Example: Adding a New Table Constraint
Example: Modifying an Existing Table Constraint
Example: Deleting a Table Constraint
Example: Loading Data into a Table
Deleting a Table
Managing Indexes
About Indexes
Indexes and Performance
Index Attributes
Viewing Indexes
Example: Creating an Index
Example: Deleting an Index
Managing Views
About Views
Displaying Views
Example: Creating a View
Example: Deleting a View
Managing Program Code Stored in the Database
About Program Code Stored in the Database
Validating (Compiling) Invalid Schema Objects
Working with Other Schema Objects
Schemas: Oracle By Example Series
9
Performing Backup and Recovery
Overview of Database Backup and Recovery
Database Backup and Recovery Concepts
Consistent and Inconsistent Backups
Media Recovery
Fast Recovery Area
RMAN Repository
Configuring Your Database for Basic Backup and Recovery
Specifying Credentials for Backup and Recovery Using Database Control
Planning Space Usage and Location for the Fast Recovery Area
About the Backup Retention Policy and the Fast Recovery Area
About the Fast Recovery Area Size
Configuring Recovery Settings
Monitoring Fast Recovery Area Usage
Configuring Backup Settings
About RMAN Backups
Configuring Backup Device Settings
Configuring Backup Policy Settings
Backing Up Your Database
RMAN Backup Concepts
Full Backups of Data Files
Incremental Backups of Data Files
Incrementally Updated Backups: Rolling Forward Image Copies of Data Files
Backup Tags
Performing and Scheduling Backups Using Database Control
Performing a Whole Database Backup
Using the Oracle Suggested Backup Strategy
Scheduling Miscellaneous Backup Tasks
Validating Backups and Testing Your Backup Strategy
Validating Selected Backups
Validating Backups for Restore Operations
Displaying Backup Reports
Managing Backups
About Backup Management
Cross-Checking Backups
Deleting Expired Backups
Marking Backups as Available or Unavailable
Deleting Obsolete Backups
Performing Oracle Advised Recovery
About Data Recovery Advisor
Using Data Recovery Advisor
Performing User-Directed Recovery
Rewinding a Table Using Oracle Flashback Table
Enabling Row Movement on a Table
Performing a Flashback Table Operation
Recovering a Dropped Table Using Oracle Flashback Drop
Dropping a Table
Retrieving a Dropped Table
Rewinding a Database Using Oracle Flashback Database
Restoring and Recovering the Database
Backup and Recovery: Oracle By Example Series
10
Monitoring and Tuning the Database
Proactive Database Monitoring
About Alerts
Performance Self-Diagnostics: Automatic Database Diagnostic Monitor
Monitoring General Database State and Workload
Managing Alerts
Viewing Metrics and Thresholds
Setting Metric Thresholds
About Responding to Alerts
Clearing Alerts
Setting Up Direct Alert Notification
Diagnosing Performance Problems Using ADDM
Viewing a Summary of ADDM Performance Findings
Responding to ADDM Performance Findings
Running ADDM Manually
Modifying AWR Snapshot Frequency and Retention
Using Advisors to Optimize Database Performance
About Advisors
About the SQL Advisors
About the Automatic SQL Tuning Advisor
Configuring the Automatic SQL Tuning Advisor
Viewing Automatic SQL Tuning Results
Running the SQL Tuning Advisor
Running the SQL Access Advisor
Optimizing Memory Usage with the Memory Advisors
About the Memory Advisors
Example: Obtaining Memory Sizing Advice for ASMM
Monitoring and Tuning: Oracle By Example Series
11
Investigating, Reporting, and Resolving Problems
About Database Problems and Incidents
Investigating, Reporting, and Resolving a Problem
Roadmap: Investigating, Reporting, and Resolving a Problem
Task 1 – View Critical Error Alerts in Enterprise Manager
Task 2 – View Problem Details
Task 3 – (Optional) Create a Service Request
Task 4 – Package and Upload Diagnostic Data to Oracle Support Services
Task 5 – Track the Service Request and Implement Any Repairs
Task 6 – Close Incidents
Viewing Problems Using the Enterprise Manager Support Workbench
12
Managing Oracle Database Software
About Software Management and Patch Releases
Upgrading a Database
Overview of Database Upgrade Assistant
Database Versions Supported by DBUA
Starting DBUA
Upgrading a Database Using DBUA
Removing Oracle Database Software
Managing Oracle Software: Oracle By Example Series
A
Administering Oracle Automatic Storage Management
About Oracle Automatic Storage Management
Overview of Disks, Disk Groups, and Failure Groups
Installing Oracle Automatic Storage Management
Accessing the Oracle Automatic Storage Management Home Page
Accessing the Oracle ASM Home Page on a Single-Instance System
Accessing the Oracle ASM Home Page on an Oracle RAC System
Monitoring Disk Group Space Usage
Creating a Disk Group
Dropping a Disk Group
Adding Disks to a Disk Group
Dropping Disks from a Disk Group
Backing Up Oracle ASM-Managed Files
Oracle Automatic Storage Management: Oracle By Example Series
Index
Scripting on this page enhances content navigation, but does not change the content in any way.