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

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

Credits

Foreword

About the Author

About the Reviewer

www.packtpub.com

Preface

Introducing the Oracle Relational Database System

Understanding the RDBMS

Introducing the Oracle product family

Interpreting Oracle Database versioning

Understanding the role of the DBA

Examining the tools of the Oracle DBA

SQL*Plus

Introducing the Companylink database

Summary

Test your knowledge

Installing the Oracle Database Software

Planning an Oracle installation

Reviewing the installation prerequisites

Using the Oracle Universal Installer

Installing the Oracle Database software

Summary

Test your knowledge

Creating the Oracle Database

Planning for a database creation

Creating an Oracle database using DBCA

Examining a manual database creation

Examining Windows Services in Oracle

Certification objectives covered

Summary

Test your knowledge

Examining the Oracle Architecture

Understanding the Oracle RDBMS

Examining the Oracle instance

Examining the Oracle database components

Exploring Oracle Real Application Clusters

Certification objectives covered

Summary

Test your knowledge

Managing Oracle Storage Structures

Examining Oracle's physical space paradigm

Managing tablespaces

Using advanced tablespace management techniques

Using Oracle Managed Files

Certification objectives covered

Summary

Test your knowledge

Managing the Oracle Instance

Understanding database startup and shutdown

Setting database initialization parameters

Understanding the data dictionary

Exploring the static data dictionary views

Understanding database diagnostic information

Understanding the Oracle Support model

Summary

Test your knowledge

Managing Security

Understanding the fundamentals of database security

Creating and managing user accounts

Understanding privileges

Understanding role-based security

Understanding profiles

Understanding key security parameters

Understanding auditing

Certification objectives covered

Summary

Test your knowledge

Managing Concurrency

Understanding the lifecycle of a transaction

Managing undo data

Managing serialization mechanisms

Certification objectives covered

Summary

Test your knowledge

Configuring an Oracle Network

Understanding Oracle networking concepts

Understanding the listener

Using Oracle name resolution

Understanding database registration

Using database links

Certification objectives covered

Summary

Test your knowledge

Managing Database Performance

Understanding object-level tuning

Managing the Automatic Workload Repository

Understanding Oracle's Advisory Framework

Understanding Oracle Memory Management

Certification objectives covered

Summary

Test your knowledge

Understanding Backup and Recovery Concepts

Understanding the redo-based architecture

Understanding Flash Recovery Area

Understanding instance recovery

Understanding the categories of database failure

Introducing the Data Recovery Advisor

Certification objectives covered

Summary

Test your knowledge

Performing Database Backups

Creating user-managed backups

Understanding Oracle Recovery Manager

Performing RMAN offline backups

Performing RMAN hot backups

Automating database backups

Certification objectives covered

Summary

Test your knowledge

Performing Database Recovery

Understanding the recovery process

Performing RMAN complete recoveries

Performing incomplete recoveries

Using the Data Recovery Advisor

Certification objectives covered

Summary

Test your knowledge

Migrating Data

Understanding external data access

Loading data with SQL*Loader

Migrating data with Oracle Data Pump

Summary

Test your knowledge

Preparing for the Certification Exam

Preparing for the Certification Exam

Preparing for the Certification Exam

Preparing for the Certification Exam

Test Your Knowledge – Answers

Test Your Knowledge – Answers

Test Your Knowledge – Answers

Test Your Knowledge – Answers

Test Your Knowledge – Answers

Test Your Knowledge – Answers

Test Your Knowledge – Answers

Test Your Knowledge – Answers

Test Your Knowledge – Answers

Test Your Knowledge – Answers

Test Your Knowledge – Answers

Test Your Knowledge – Answers

Test Your Knowledge – Answers

Test Your Knowledge – Answers

Test Your Knowledge – Answers

Test Your Knowledge – Answers

Test Your Knowledge – Answers

Index