OCA Oracle Database 11g Administration I Certification Guide电子书

OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide

Table of Contents

OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide

Credits

Foreword

About the Author

About the Reviewer

www.packtpub.com

Support files, eBooks, discount offers and more

Why Subscribe?

Free Access for Packt account holders

Instant Updates on New Packt Books

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Downloading the example code

Errata

Piracy

Questions

1. Introducing the Oracle Relational Database System

Understanding the RDBMS

The importance of databases

Flat file databases

Limitations of the flat file paradigm

A new paradigm

Introducing the Oracle product family

Exploring the history of Oracle

Understanding the Oracle Database product

Understanding the different editions of Oracle Database

Understanding Oracle Database options

Examining the Oracle product family

Understanding Oracle's hardware solutions

Examining Oracle virtualization solutions

Exploring Oracle operating systems

Examining Oracle Application Servers

Interpreting Oracle Database versioning

Understanding the role of the DBA

Examining the tools of the Oracle DBA

SQL*Plus

Oracle Enterprise Manager

TOAD

DBArtisan

Oracle SQL Developer

Introducing the Companylink database

Summary

Test your knowledge

2. Installing the Oracle Database Software

Planning an Oracle installation

Understanding Oracle installation concepts

Acquiring the Oracle software

Reviewing the installation prerequisites

Reviewing hardware prerequisites for an installation

Meeting the minimum hardware requirements for an installation

Reviewing software prerequisites for an installation

Using the Oracle Universal Installer

Understanding how OUI works

Completing final preparations to install the Oracle software

Creating Oracle user accounts and groups

Establishing Oracle directory structures

Understanding the Optimal Flexible Architecture

Using environment variables in Oracle

Installing the Oracle Database software

Running the Oracle Universal Installer

Examining the installation

Understanding the de-installation process – advanced topic

Summary

Test your knowledge

3. Creating the Oracle Database

Planning for a database creation

Understanding the memory requirements of a database

Understanding the disk requirements of a database

Running the Network Configuration Assistant

Creating an Oracle database using DBCA

Introducing the Database Configuration Assistant

Examining a manual database creation

Examining Windows Services in Oracle

Certification objectives covered

Summary

Test your knowledge

4. Examining the Oracle Architecture

Understanding the Oracle RDBMS

Distinguishing between an instance and a database

Examining the Oracle instance

Recognizing the primary Oracle processes

PMON – the Process Monitor

SMON – the System Monitor

DBWn – the Database Writer process

CKPT – the Checkpoint process

LGWR – the Log Writer process

ARCn – the Archiver process

Recognizing the secondary Oracle processes

MMON – the Manageability Monitor

MMAN – Memory Manager

RECO – the Recoverer process

Recognizing other database processes

Identifying Oracle's memory caches

Understanding the SGA

Examining the database buffer cache

Examining the shared pool

Utilizing the log buffer

Understanding the large pool

Examining the streams pool

Understanding the Java pool

Understanding the PGA

Examining the Oracle database components

Understanding the control file

Exploring the redo logfiles

Understanding the archived redo logs

Examining Oracle's core infrastructure datafiles

Understanding the SYSTEM tablespace

Understanding the SYSAUX tablespace

Exploring the temporary tablespace

Understanding the Undo tablespace

Understanding non-specialized datafiles

Exploring Oracle Real Application Clusters

Certification objectives covered

Summary

Test your knowledge

5. Managing Oracle Storage Structures

Examining Oracle's physical space paradigm

Understanding the database block

Sizing the database block

Examining the anatomy of a database block

Understanding the database extent

Understanding the database segment

Understanding the database datafile

Managing tablespaces

Starting SQL Developer

Creating tablespaces

Modifying tablespaces

Resizing datafiles

Adding datafiles

Automatically extending datafiles

Managing tablespace availability

Dropping a tablespace

Using advanced tablespace management techniques

Using non-standard block size tablespaces

Understanding locally managed tablespaces

Using Oracle Managed Files

Certification objectives covered

Summary

Test your knowledge

6. Managing the Oracle Instance

Understanding database startup and shutdown

Understanding the startup process

Controlling the startup and shutdown process

Establishing a connection with SYSDBA privileges

Controlling the database startup process

Controlling the database shutdown process

Controlling startup and shutdown on Windows platforms

Setting database initialization parameters

Understanding the PFILE and SPFILE

Working with the PFILE and SPFILE

Understanding the data dictionary

Exploring the Oracle base tables

Exploring the static data dictionary views

Exploring the dynamic data dictionary views

Querying the data dictionary views

Listing common data dictionary views

Object-related views

Administration-related views

Security-related views

Storage-related views

Understanding database diagnostic information

Understanding the alert log

Understanding the trace files

Understanding the Automatic Diagnostic Repository

Understanding the Oracle Support model

Using My Oracle Support

Patching Oracle

Certification objectives covered

Summary

Test your knowledge

7. Managing Security

Understanding the fundamentals of database security

Exploring the principles behind security

Creating and managing user accounts

Creating users

Understanding privileges

Granting system privileges

Granting object privileges

Removing privileges with REVOKE

Understanding role-based security

Using system roles

Managing user roles

Enabling roles

Understanding profiles

Understanding password limits

Using profiles to manage passwords

Using profiles to manage system resources

Understanding key security parameters

Understanding auditing

Exploring the audit trail

Auditing database actions

Certification objectives covered

Summary

Test your knowledge

8. Managing Concurrency

Understanding the lifecycle of a transaction

Examining the rules of a transaction

Examining types of transactions

Managing undo data

Understanding undo-related parameters

Managing undo tablespaces

Managing serialization mechanisms

Understanding Oracle's locking scheme

Examining locking in action

Recognizing deadlocks

Understanding latches and mutexes

Certification objectives covered

Summary

Test your knowledge

9. Configuring an Oracle Network

Understanding Oracle networking concepts

Exploring Oracle Net

Understanding the dedicated and shared server architectures

Understanding the listener

Controlling the listener

Understanding the networking configuration files

Using Oracle name resolution

Understanding Easy Connect

Understanding local naming

Using directory naming and external naming

Understanding database registration

Using static registration

Using dynamic registration

Using database links

Certification objectives covered

Summary

Test your knowledge

10. Managing Database Performance

Understanding object-level tuning

Understanding the Oracle optimizer

Gathering object statistics

Gathering statistics manually

Gathering statistics automatically

Discovering invalid objects

Managing the Automatic Workload Repository

Understanding the AWR

Using statistics, metrics, and baselines

Generating an AWR report

Understanding Oracle's Advisory Framework

Understanding the Automatic Database Diagnostic Monitor

Generating an ADDM Report

Using Memory Advisors

Using the Buffer Pool Advisor

Using the Shared Pool Advisory

Using the PGA Advisor

Understanding the Alert Framework

Understanding Oracle Memory Management

Using Manual Memory Management

Using Automatic Shared Memory Management

Using Automatic Memory Management

Certification objectives covered

Summary

Test your knowledge

11. Understanding Backup and Recovery Concepts

Understanding the redo-based architecture

Adding redo log members

Adding a redo log group

Exploring ARCHIVELOG mode

Converting to an ARCHIVELOG mode

Understanding Flash Recovery Area

Configuring the Flash Recovery Area

Understanding instance recovery

Understanding the categories of database failure

Addressing statement failures

Addressing user errors

Addressing user process errors

Addressing media failure

Understanding RAID

RAID 0

RAID 1

RAID 10

RAID 5

Understanding file-level media failure

Introducing the Data Recovery Advisor

Certification objectives covered

Summary

Test your knowledge

12. Performing Database Backups

Creating user-managed backups

Creating user-managed cold backups

Creating user-managed hot backups

Understanding Oracle Recovery Manager

Introducing RMAN

Understanding the RMAN architecture

Performing RMAN offline backups

Performing a tablespace-level RMAN backup

Performing a full backup

Performing compressed backups

Backing up image copies

Performing RMAN hot backups

Performing full hot backups

Creating incremental backups

Understanding RMAN Parameters

Using the LIST command in RMAN

Using the REPORT command in RMAN

Checking files using CROSSCHECK

Monitoring the Flash Recovery Are with Enterprise Manager

Automating database backups

Automating Backups with scripting

Automating backups using Enterprise Manager

Certification objectives covered

Summary

Test your knowledge

13. Performing Database Recovery

Understanding the recovery process

Understanding the importance of database recovery

Understanding the different types of recovery

Performing RMAN complete recoveries

Performing datafile-level RMAN complete recovery

Performing complete recovery of the database

Performing incomplete recoveries

Understanding incomplete recovery

Performing a time-based incomplete recovery

Using the Data Recovery Advisor

Performing recovery using the DRA command-line interface

Performing recovery using the DRA with Enterprise Manager

Certification objectives covered

Summary

Test your knowledge

14. Migrating Data

Understanding external data access

Creating directory objects

Creating external tables

Loading data with SQL*Loader

Understanding the key command files used by SQL*Loader

Understanding SQL*Loader's load paths

Understanding the input data file

Constructing a parameter file

Constructing a control file

Running a SQL*Loader job

Migrating data with Oracle Data Pump

Understanding the architecture of Data Pump

Exporting data Using Data Pump

Importing data using Data Pump

Using Data Pump with NETWORK_LINK

Certification objectives covered

Summary

Test your knowledge

A. Preparing for the Certification Exam

About the exam

Helpful exam hints

A recommended strategy for preparation

B. Test Your Knowledge – Answers

Chapter 1, Introducing the Oracle Relational Database System

Chapter 2, Installing the Oracle Database Software

Chapter 3, Creating the Oracle Database

Chapter 4, Examining the Oracle Architecture

Chapter 5, Managing Oracle Storage Structures

Chapter 6, Managing the Oracle Instance

Chapter 7, Managing Security

Chapter 8, Managing Concurrency

Chapter 9, Configuring an Oracle Network

Chapter 10, Managing Database Performance

Chapter 11, Understanding Backup and Recovery Concepts

Chapter 12, Performing Database Backups

Chapter 13, Performing Database Recovery

Chapter 14, Migrating Data

Online chapter 1, Managing Oracle Tables

Online chapter 2, Managing Other Database Objects

Index