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 -- 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 -- 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.