Oracle 10g/11g Data and Database Management Utilities Table Of Contents

Table of Contents

• Preface

• Chapter 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

• Chapter 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

• Chapter 3: External Tables
• The External Table basics
• Let's 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
• Mapping XML files as External Tables
• Dynamically changing the external reference
• Oracle 11g External Table enhancements
• Summary

• Chapter 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

• Chapter 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

• Chapter 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

• Chapter 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

• Chapter 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

• Chapter 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

• Chapter 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

• Chapter 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

• Chapter 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

• Chapter 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