You are previewing OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide.
O'Reilly logo
OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide

Book Description

Learn how to become an Oracle certified database administrator

  • Prepare for Oracle Database Administration I certification

  • Learn real world skills in database administration

  • Written in an example driven format with step-by-step real world examples

  • In Detail

    Oracle Database Server is the most widely used relational database in the world today. This book gives you the essential skills to master the fundamentals of Oracle database administration and prepares you for Oracle DBA certification.

    "OCA Oracle Database 12i Administration I: A Real-World Certification Guide" prepares you to master the fundamentals of Oracle database administration using an example driven method that is easy to understand. The real world examples will prepare you to face the daily challenges of being a database administrator.

    Starting with the essentials of why databases are important in today's information technology world and how they work, you are then guided through a full, customized installation of the Oracle software and creating your own personal database.

    We then examine fundamental concepts of Oracle, including architecture, storage structures, security, performance tuning, networking, and instance management. Finally, we take an in-depth look at some of the most important concepts in the daily life of an Oracle DBA - backup, recovery, and data migration.

    "OCA Oracle Database 12i Administration I: A Real-World Certification Guide" provides you with the skills you need in order to become a successful Oracle DBA, both for certification and real life tasks.

    Table of Contents

    1. OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide
      1. Table of Contents
      2. OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide
      3. Credits
      4. Foreword
      5. About the Author
      6. About the Reviewer
        1. Support files, eBooks, discount offers and more
          1. Why Subscribe?
          2. Free Access for Packt account holders
          3. Instant Updates on New Packt Books
      8. Preface
        1. What this book covers
        2. What you need for this book
        3. Who this book is for
        4. Conventions
        5. Reader feedback
        6. Customer support
          1. Downloading the example code
          2. Errata
          3. Piracy
          4. Questions
      9. 1. Introducing the Oracle Relational Database System
        1. Understanding the RDBMS
          1. The importance of databases
          2. Flat file databases
            1. Limitations of the flat file paradigm
          3. A new paradigm
        2. Introducing the Oracle product family
          1. Exploring the history of Oracle
          2. Understanding the Oracle Database product
            1. Understanding the different editions of Oracle Database
            2. Understanding Oracle Database options
          3. Examining the Oracle product family
            1. Understanding Oracle's hardware solutions
            2. Examining Oracle virtualization solutions
            3. Exploring Oracle operating systems
            4. Examining Oracle Application Servers
        3. Interpreting Oracle Database versioning
        4. Understanding the role of the DBA
        5. Examining the tools of the Oracle DBA
        6. SQL*Plus
          1. Oracle Enterprise Manager
          2. TOAD
          3. DBArtisan
          4. Oracle SQL Developer
        7. Introducing the Companylink database
        8. Summary
        9. Test your knowledge
      10. 2. Installing the Oracle Database Software
        1. Planning an Oracle installation
          1. Understanding Oracle installation concepts
            1. Acquiring the Oracle software
        2. Reviewing the installation prerequisites
          1. Reviewing hardware prerequisites for an installation
            1. Meeting the minimum hardware requirements for an installation
          2. Reviewing software prerequisites for an installation
        3. Using the Oracle Universal Installer
          1. Understanding how OUI works
          2. Completing final preparations to install the Oracle software
            1. Creating Oracle user accounts and groups
            2. Establishing Oracle directory structures
            3. Understanding the Optimal Flexible Architecture
            4. Using environment variables in Oracle
        4. Installing the Oracle Database software
          1. Running the Oracle Universal Installer
          2. Examining the installation
            1. Understanding the de-installation process – advanced topic
        5. Summary
        6. Test your knowledge
      11. 3. Creating the Oracle Database
        1. Planning for a database creation
          1. Understanding the memory requirements of a database
          2. Understanding the disk requirements of a database
          3. Running the Network Configuration Assistant
        2. Creating an Oracle database using DBCA
          1. Introducing the Database Configuration Assistant
        3. Examining a manual database creation
        4. Examining Windows Services in Oracle
        5. Certification objectives covered
        6. Summary
        7. Test your knowledge
      12. 4. Examining the Oracle Architecture
        1. Understanding the Oracle RDBMS
          1. Distinguishing between an instance and a database
        2. Examining the Oracle instance
          1. Recognizing the primary Oracle processes
            1. PMON – the Process Monitor
            2. SMON – the System Monitor
            3. DBWn – the Database Writer process
            4. CKPT – the Checkpoint process
            5. LGWR – the Log Writer process
            6. ARCn – the Archiver process
          2. Recognizing the secondary Oracle processes
            1. MMON – the Manageability Monitor
            2. MMAN – Memory Manager
            3. RECO – the Recoverer process
          3. Recognizing other database processes
          4. Identifying Oracle's memory caches
            1. Understanding the SGA
              1. Examining the database buffer cache
              2. Examining the shared pool
              3. Utilizing the log buffer
              4. Understanding the large pool
              5. Examining the streams pool
              6. Understanding the Java pool
            2. Understanding the PGA
        3. Examining the Oracle database components
          1. Understanding the control file
          2. Exploring the redo logfiles
          3. Understanding the archived redo logs
          4. Examining Oracle's core infrastructure datafiles
            1. Understanding the SYSTEM tablespace
            2. Understanding the SYSAUX tablespace
            3. Exploring the temporary tablespace
            4. Understanding the Undo tablespace
          5. Understanding non-specialized datafiles
        4. Exploring Oracle Real Application Clusters
        5. Certification objectives covered
        6. Summary
        7. Test your knowledge
      13. 5. Managing Oracle Storage Structures
        1. Examining Oracle's physical space paradigm
          1. Understanding the database block
            1. Sizing the database block
            2. Examining the anatomy of a database block
          2. Understanding the database extent
          3. Understanding the database segment
          4. Understanding the database datafile
        2. Managing tablespaces
          1. Starting SQL Developer
          2. Creating tablespaces
          3. Modifying tablespaces
            1. Resizing datafiles
            2. Adding datafiles
            3. Automatically extending datafiles
            4. Managing tablespace availability
            5. Dropping a tablespace
        3. Using advanced tablespace management techniques
          1. Using non-standard block size tablespaces
          2. Understanding locally managed tablespaces
        4. Using Oracle Managed Files
        5. Certification objectives covered
        6. Summary
        7. Test your knowledge
      14. 6. Managing the Oracle Instance
        1. Understanding database startup and shutdown
          1. Understanding the startup process
          2. Controlling the startup and shutdown process
            1. Establishing a connection with SYSDBA privileges
            2. Controlling the database startup process
            3. Controlling the database shutdown process
            4. Controlling startup and shutdown on Windows platforms
        2. Setting database initialization parameters
          1. Understanding the PFILE and SPFILE
          2. Working with the PFILE and SPFILE
        3. Understanding the data dictionary
          1. Exploring the Oracle base tables
        4. Exploring the static data dictionary views
          1. Exploring the dynamic data dictionary views
          2. Querying the data dictionary views
          3. Listing common data dictionary views
            1. Object-related views
            2. Administration-related views
            3. Security-related views
            4. Storage-related views
        5. Understanding database diagnostic information
          1. Understanding the alert log
          2. Understanding the trace files
          3. Understanding the Automatic Diagnostic Repository
        6. Understanding the Oracle Support model
          1. Using My Oracle Support
          2. Patching Oracle
          3. Certification objectives covered
        7. Summary
        8. Test your knowledge
      15. 7. Managing Security
        1. Understanding the fundamentals of database security
          1. Exploring the principles behind security
        2. Creating and managing user accounts
          1. Creating users
        3. Understanding privileges
          1. Granting system privileges
          2. Granting object privileges
          3. Removing privileges with REVOKE
        4. Understanding role-based security
          1. Using system roles
          2. Managing user roles
          3. Enabling roles
        5. Understanding profiles
          1. Understanding password limits
          2. Using profiles to manage passwords
          3. Using profiles to manage system resources
        6. Understanding key security parameters
        7. Understanding auditing
          1. Exploring the audit trail
          2. Auditing database actions
        8. Certification objectives covered
        9. Summary
        10. Test your knowledge
      16. 8. Managing Concurrency
        1. Understanding the lifecycle of a transaction
          1. Examining the rules of a transaction
          2. Examining types of transactions
        2. Managing undo data
          1. Understanding undo-related parameters
          2. Managing undo tablespaces
        3. Managing serialization mechanisms
          1. Understanding Oracle's locking scheme
          2. Examining locking in action
          3. Recognizing deadlocks
          4. Understanding latches and mutexes
        4. Certification objectives covered
        5. Summary
        6. Test your knowledge
      17. 9. Configuring an Oracle Network
        1. Understanding Oracle networking concepts
          1. Exploring Oracle Net
          2. Understanding the dedicated and shared server architectures
        2. Understanding the listener
          1. Controlling the listener
          2. Understanding the networking configuration files
        3. Using Oracle name resolution
          1. Understanding Easy Connect
          2. Understanding local naming
          3. Using directory naming and external naming
        4. Understanding database registration
          1. Using static registration
          2. Using dynamic registration
        5. Using database links
        6. Certification objectives covered
        7. Summary
        8. Test your knowledge
      18. 10. Managing Database Performance
        1. Understanding object-level tuning
          1. Understanding the Oracle optimizer
          2. Gathering object statistics
            1. Gathering statistics manually
            2. Gathering statistics automatically
          3. Discovering invalid objects
        2. Managing the Automatic Workload Repository
          1. Understanding the AWR
          2. Using statistics, metrics, and baselines
          3. Generating an AWR report
        3. Understanding Oracle's Advisory Framework
          1. Understanding the Automatic Database Diagnostic Monitor
          2. Generating an ADDM Report
          3. Using Memory Advisors
            1. Using the Buffer Pool Advisor
            2. Using the Shared Pool Advisory
            3. Using the PGA Advisor
          4. Understanding the Alert Framework
        4. Understanding Oracle Memory Management
          1. Using Manual Memory Management
          2. Using Automatic Shared Memory Management
          3. Using Automatic Memory Management
        5. Certification objectives covered
        6. Summary
        7. Test your knowledge
      19. 11. Understanding Backup and Recovery Concepts
        1. Understanding the redo-based architecture
          1. Adding redo log members
          2. Adding a redo log group
          3. Exploring ARCHIVELOG mode
          4. Converting to an ARCHIVELOG mode
        2. Understanding Flash Recovery Area
          1. Configuring the Flash Recovery Area
        3. Understanding instance recovery
        4. Understanding the categories of database failure
          1. Addressing statement failures
          2. Addressing user errors
          3. Addressing user process errors
          4. Addressing media failure
          5. Understanding RAID
            1. RAID 0
            2. RAID 1
            3. RAID 10
            4. RAID 5
          6. Understanding file-level media failure
        5. Introducing the Data Recovery Advisor
        6. Certification objectives covered
        7. Summary
        8. Test your knowledge
      20. 12. Performing Database Backups
        1. Creating user-managed backups
          1. Creating user-managed cold backups
          2. Creating user-managed hot backups
        2. Understanding Oracle Recovery Manager
          1. Introducing RMAN
          2. Understanding the RMAN architecture
        3. Performing RMAN offline backups
          1. Performing a tablespace-level RMAN backup
          2. Performing a full backup
          3. Performing compressed backups
          4. Backing up image copies
        4. Performing RMAN hot backups
          1. Performing full hot backups
          2. Creating incremental backups
          3. Understanding RMAN Parameters
          4. Using the LIST command in RMAN
          5. Using the REPORT command in RMAN
          6. Checking files using CROSSCHECK
          7. Monitoring the Flash Recovery Are with Enterprise Manager
        5. Automating database backups
          1. Automating Backups with scripting
          2. Automating backups using Enterprise Manager
        6. Certification objectives covered
        7. Summary
        8. Test your knowledge
      21. 13. Performing Database Recovery
        1. Understanding the recovery process
          1. Understanding the importance of database recovery
          2. Understanding the different types of recovery
        2. Performing RMAN complete recoveries
          1. Performing datafile-level RMAN complete recovery
          2. Performing complete recovery of the database
        3. Performing incomplete recoveries
          1. Understanding incomplete recovery
          2. Performing a time-based incomplete recovery
        4. Using the Data Recovery Advisor
          1. Performing recovery using the DRA command-line interface
          2. Performing recovery using the DRA with Enterprise Manager
        5. Certification objectives covered
        6. Summary
        7. Test your knowledge
      22. 14. Migrating Data
        1. Understanding external data access
          1. Creating directory objects
          2. Creating external tables
        2. Loading data with SQL*Loader
          1. Understanding the key command files used by SQL*Loader
            1. Understanding SQL*Loader's load paths
            2. Understanding the input data file
            3. Constructing a parameter file
            4. Constructing a control file
          2. Running a SQL*Loader job
        3. Migrating data with Oracle Data Pump
          1. Understanding the architecture of Data Pump
          2. Exporting data Using Data Pump
          3. Importing data using Data Pump
          4. Using Data Pump with NETWORK_LINK
          5. Certification objectives covered
        4. Summary
        5. Test your knowledge
      23. A. Preparing for the Certification Exam
        1. About the exam
        2. Helpful exam hints
        3. A recommended strategy for preparation
      24. B. Test Your Knowledge – Answers
        1. Chapter 1, Introducing the Oracle Relational Database System
        2. Chapter 2, Installing the Oracle Database Software
        3. Chapter 3, Creating the Oracle Database
        4. Chapter 4, Examining the Oracle Architecture
        5. Chapter 5, Managing Oracle Storage Structures
        6. Chapter 6, Managing the Oracle Instance
        7. Chapter 7, Managing Security
        8. Chapter 8, Managing Concurrency
        9. Chapter 9, Configuring an Oracle Network
        10. Chapter 10, Managing Database Performance
        11. Chapter 11, Understanding Backup and Recovery Concepts
        12. Chapter 12, Performing Database Backups
        13. Chapter 13, Performing Database Recovery
        14. Chapter 14, Migrating Data
        15. Online chapter 1, Managing Oracle Tables
        16. Online chapter 2, Managing Other Database Objects
      25. Index