Oracle 10g/11g Data and Database Management Utilities. Master 12 must-use Oracle Database Utilities with this Oracle book and Hector R. Madrid, Hector Rivera Madrid

Spis treści książki

• Oracle 10g/11g Data and Database Management Utilities
  • Table of Contents
  • Oracle 10g/11g Data and Database Management Utilities
  • Credits
  • About the Author
  • About the Reviewer
  • 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 for the book
      • Errata
      • Piracy
      • Questions
  • 1. Data Pump
    • Data Pump features
    • Data Pump architecture
    • Setting up the practical scenarios
    • Data Pump export
      • Data Pump export modes
      • A simple Data Pump export session
      • Data Pump export filtering operations
      • Use of parameter file
      • Retrieve original data
      • Data Pump export space estimation
      • Dump file multiplexing
      • Transporting data among different versions
      • Data Pump export interactive mode
    • Data Pump restart capability
    • Getting information about the export job
    • Data Pump import
      • Remap function
      • Data Pump import network mode
    • Improving performance with Data Pump
    • Working with the Data Pump API
    • Data Pump 11g new features
      • Compression
      • Encrypted dump file sets
      • Enhancements for Data Pump External Tables
      • Single partition transportable for Oracle Data Pump
      • Overwrite dump files
      • XML Datatypes
    • Summary
  • 2. SQL*Loader
    • SQL*Loader basics
    • Preparing the demo environment
      • Our first simple load
      • The SQL*Loader log file
      • Fixed record size format load
      • Variable record size format load
      • Stream record format load
    • Specifying a particular character set
    • Load on the fly
    • Direct path versus Conventional path load
      • Direct path load pros
      • Direct path load cons
    • Loading Large Objects (LOBs)
    • Loading multimedia files
    • Resumable load
    • Parallel load
    • General performance booster tips
    • Summary
  • 3. External Tables
    • The External Table basics
    • Lets setup the environment
      • A basic External Table
      • Creating External Table metadata, the easy way
      • Unloading data to External Tables
    • Inter-version compatibility
    • Data transformation with External Tables
      • Extending the alert.log analysis with External Tables
      • Reading the listener.log from the database
        • • • Connect String
            • Protocol
    • Mapping XML files as External Tables
    • Dynamically changing the external reference
    • Oracle 11g External Table enhancements
    • Summary
  • 4. Recovery Manager Advanced Techniques
    • Recovery Manager basics
      • Getting started with a Recovery Manager session
      • Format masks used by recovery manager
      • What happens in a user-managed online backup?
        • Myths related to the online backup method
      • Configuring a multiplexed backup
      • Configuring the RMAN recovery catalog
      • A simple backup session
    • Backup compression
      • Fast backup compression
      • Improving data set compression with the ZLIB algorithm (11g only)
    • Faster backups through intra-file parallel backup and restore operations (11g only)
    • Block media recovery
    • Backup duration and throttling
    • Database cloning
      • Database cloning procedure
      • Database cloning on the fly (11g only)
    • Inter-platform database migration
    • Migrate to and from an ASM environment
    • General backup advices
    • Summary
  • 5. Recovery Manager Restore and Recovery Techniques
    • Oracle database recovery
      • Instance failure
      • Media failure
      • Complete recovery
      • Incomplete recovery
    • Loss of data files
      • Queries used to diagnose data files
      • Loss of a non-critical datafile
      • Loss of a temporary datafile
        • Managing temporary datafiles
      • Loss of a critical datafile
    • Loss of redo log files
      • Loss of the inactive redo log group
      • Loss of the current redo log group
    • Test restore
    • Crosscheck command
    • Nologging considerations
    • Summary
  • 6. Session Management
    • User sessions in a dedicated server architecture
      • Instance self registration process
    • Blocking sessions
      • Optimistic versus pessimistic locking
      • Row lock contention monitoring
      • Killing sessions
      • Deadlock handling
      • Sniped sessions
      • Orakill
    • Services
    • Resource Manager
      • Resource Manager Elements
      • Configuring resources assigned to users
      • Configuring resources assigned to services
        • Creating the database user
        • Service names definition
        • Listener verification
        • TNS entry configuration
        • Resource consumer group creation
        • Service mapping
        • Resource plan definition
        • Resource manager plan activation
        • Testing and monitoring
    • Active Session History (ASH)
    • Session monitoring, the traditional way
    • Summary
  • 7. Oracle Scheduler
    • Oracle Scheduler concepts
    • Getting started with the Oracle Scheduler
      • Required privileges
      • Scheduling our first job
        • Creating the job
        • Specifying procedure arguments
        • Enabling the job schedule
        • Using Enterprise Manager
    • Time expression syntax
      • The repeat interval
      • Regular schedule
      • Combined schedule
        • Exclude scenario
        • Include scenario
        • Intersect scenario
      • Time expression examples
    • Programs
      • Creating programs manually
      • Defining a program using Enterprise Manager
    • Schedules
    • Jobs and Job Classes
    • Managing the Scheduler
      • Enable or disable components
      • Managing job logs
        • Monitor a Job Execution
        • Purging the job log
    • Data dictionary related views
    • Summary
  • 8. Oracle Wallet Manager
    • The Oracle Wallet Manager
      • Creating the Oracle Wallet
      • Enabling Auto Login
      • mkwallet, the CLI OWM version
      • Managing Wallets with orapki
    • Oracle Wallet Manager CSR generation
    • Storing the Oracle Wallet in the Windows registry
      • Save Wallet to the registry
      • Open the Wallet from the registry
      • Save as to a different registry location
      • Open the Wallet from the registry, save it to the file system and vice versa
      • Delete the Wallet from the registry
      • Configuring the Wallet location
    • Storing the Wallet in an LDAP server
      • Uploading the Wallet to an LDAP server
      • Downloading the Wallet from LDAP
    • Using certificates for authentication
      • Public Key Infrastructure tools
    • Using the Oracle Wallet to store database credentials
    • Summary
  • 9. Security Management
    • Using the Oracle Wallet to encrypt backups
      • Recovery Manager encryption
        • Using the transparent mode
        • Using the password mode
        • Using the dual mode
      • RMAN backup shredding (11g only)
      • Data pump encryption
    • The enterprise user
      • Configuring the environment
        • How Oracle SSO works
      • Configure access to the LDAP directory
      • Registering the database against the OID
      • Shared schema
    • Summary
  • 10. Database Configuration Assistant
    • DBCA
    • Database creation
      • Database templates
      • Database identification
      • Management options
      • Database credentials
      • Storage options
      • Database file locations
      • Database content
      • Initialization parameters
        • Memory
        • Character sets
        • Connection mode
      • Database storage
      • Creation options
    • Database edition
    • Database template management
      • Template management operations
      • Creating a seed database out of a current database
      • Database related file location
      • Migrating a single instance database to RAC
    • Automatic Storage Management configuration
      • ASM
      • How to setup ASM using DBCA
        • Select the Configure ASM option
        • Run the localconfig shell script as root
        • Set the SYS password and the ASM instance parameters
        • Setup disk groups
        • ASM disk group's validation
      • Setting up ASM in a Windows environment
        • ASM setup
        • Disk layout
        • Logical partitions
        • Setup ASM
    • DBCA, Batch mode
      • DBCA response file example
      • Where can you get a DBCA response file
    • Summary
  • 11. Oracle Universal Installer
    • OUI basics
      • OUI components
      • Setting up a stage area
        • DVD distribution
      • Troubleshooting an installation session
      • Oracle Universal Installer JRE
      • OUI system requirements
    • OUI basic and advanced installation modes
      • OUI Basic Installation
      • Licensed installed options
      • OUI Advanced Installation
    • Modes of installation
    • OUI command line parameters
      • Command line variables usage
    • Silent installation mode
      • The response file structure and syntax
      • Customizing a response file
      • Creating a response file out from an actual installation
      • The Batch installation, step by step
      • Creating a response file to perform a batch deinstallation
    • The oraparam.ini file
    • OUI return codes
    • Installing Oracle from the Web
    • Recovering a lost Inventory
    • Cloning Oracle Home using OUI
    • Summary
  • 12. Enterprise Manager Configuration Assistant
    • Enterprise Manager Components
      • Differences between EM DB Control and EM Grid Control
    • Enterprise Manager configuration
      • How to find out if the console components are currently installed
      • Console setup prerequisites
      • Configuring EM using DBCA
      • Manually configuring Enterprise Manager with EMCA
      • Manually assigning EM managing ports
    • EMCA Command Line Interface
      • EMCA commands
      • EMCA flags
      • EMCA general Command-Line Parameters
      • EMCA backup parameters
      • EMCA ASM parameters
      • EMCA Cluster (RAC) parameters
    • EMCA 10g Release 1
      • EMCA 10gR1 syntax
      • EMCA 10gR1 options
      • EMCA 10gR1 parameters
      • EMCA 10gR1 RAC parameters
      • EMCA silent mode
    • EM directory structure
      • EMCA log files
      • The SYSMAN configuration files
      • The SYSMAN log files
    • Environment changes
      • Changing the IP address or host name
      • Changing administrative passwords
        • Changing SYSMAN password
        • Changing DBSNMP password
    • Securing Enterprise Manager
    • Summary
  • 13. OPatch
    • OPatch
    • Downloading the latest OPatch version
    • OPatch requirements
    • OPatch syntax
      • OPatch options
    • Oracle maintenance using OPatch
    • Applying a single patch using OPatch
    • Querying the Oracle inventory
    • Rolling back a failed OPatch session
    • Considerations after applying a patch
    • OPatch in Oracle 11g
    • Oracle Configuration Manager Registration
    • Critical Patch Updates
      • Find out the installed patches
      • Critical Patch Advisory
    • Hot patching (11g only)
    • Troubleshooting OPatch
      • PATH environment variable
      • OPatch log files
    • Using Enterprise Manager for software maintenance
      • Enterprise Manager Metalink configuration
      • Refresh from Metalink Job
      • Downloading and staging patches
      • The Patch Cache
    • Managing Patches in EM 11g
      • Patch Advisor
        • Critical Security Patches
        • Feature based patching
      • View Patch Cache
      • Patch prerequisites
      • Stage patch
      • Apply patch
    • Summary
  • Index

pokaż cały spis treści

ukryj recenzje