E-book details

OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide. Learn how to become an Oracle-certified Database Administrator

OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide. Learn how to become an Oracle-certified Database Administrator

Steve Ries, Walter S Ries

Ebook
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 11g: Database 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 11g: Database 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.
  • 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 Oracles 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
  • Title: OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide. Learn how to become an Oracle-certified Database Administrator
  • Author: Steve Ries, Walter S Ries
  • Original title: OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide. Learn how to become an Oracle-certified Database Administrator
  • ISBN: 9781849687317, 9781849687317
  • Date of issue: 2013-02-22
  • Format: Ebook
  • Item ID: e_3boo
  • Publisher: Packt Publishing