Cargando…
Oracle 10g/11g data and database management utilities : master twelve must-use utilities to optimize the efficiency, management, and performance of your daily database task /
"Using Oracle Utilities the user can benefit from improved maintenance windows, optimized backups, faster data transfers, and more reliable security and in general can do more with the same time and resources. You don't have to reinvent the wheel, just learn how to properly use the Oracle...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Otros Autores: | , , |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham, U.K. :
Packt Pub.,
2009.
|
| Colección: | From technologies to solutions.
|
| Temas: | |
| Acceso en línea: | Texto completo |
Tabla de Contenidos:
- Cover; 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 PumpWorking 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 prosDirect 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 referenceOracle 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