Book Image

Oracle 10g/11g Data and Database Management Utilities

Book Image

Oracle 10g/11g Data and Database Management Utilities

Overview of this book

Does your database look complicated? Are you finding it difficult to interact with it? Database interaction is a part of the daily routine for all database professionals. 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.

Related Content you might be interested in

Current Title:

Small book image
Oracle 10g/11g Data and Database Management Utilities
Jun, 2009 | 432 pages
No titles found
Table of Contents (18 chapters)
Oracle 10g/11g Data and Database Management Utilities
Oracle 10g/11g Data and Database Management Utilities
Credits
Credits
About the Author
About the Author
About the Reviewer
About the Reviewer
Preface
Preface
Free Chapter
1
Data Pump
Data Pump
Data Pump features
Data Pump architecture
Setting up the practical scenarios
Data Pump export
Data Pump restart capability
Getting information about the export job
Data Pump import
Improving performance with Data Pump
Working with the Data Pump API
Data Pump 11g new features
Summary
2
SQL*Loader
SQL*Loader
SQL*Loader basics
Preparing the demo environment
Specifying a particular character set
Load on the fly
Direct path versus Conventional path load
Loading Large Objects (LOBs)
Loading multimedia files
Resumable load
Parallel load
General performance booster tips
Summary
3
External Tables
External Tables
The External Table basics
Let's setup the environment
Inter-version compatibility
Data transformation with External Tables
Mapping XML files as External Tables
Dynamically changing the external reference
Oracle 11g External Table enhancements
Summary
4
Recovery Manager Advanced Techniques
Recovery Manager Advanced Techniques
Recovery Manager basics
Backup compression
Faster backups through intra-file parallel backup and restore operations (11g only)
Block media recovery
Backup duration and throttling
Database cloning
Inter-platform database migration
Migrate to and from an ASM environment
General backup advices
Summary
5
Recovery Manager Restore and Recovery Techniques
Recovery Manager Restore and Recovery Techniques
Oracle database recovery
Loss of data files
Loss of redo log files
Test restore
Crosscheck command
Nologging considerations
Summary
6
Session Management
Session Management
User sessions in a dedicated server architecture
Blocking sessions
Services
Resource Manager
Active Session History (ASH)
Session monitoring, the traditional way
Summary
7
Oracle Scheduler
Oracle Scheduler
Oracle Scheduler concepts
Getting started with the Oracle Scheduler
Time expression syntax
Programs
Schedules
Jobs and Job Classes
Managing the Scheduler
Data dictionary related views
Summary
8
Oracle Wallet Manager
Oracle Wallet Manager
The Oracle Wallet Manager
Oracle Wallet Manager CSR generation
Storing the Oracle Wallet in the Windows registry
Storing the Wallet in an LDAP server
Using certificates for authentication
Using the Oracle Wallet to store database credentials
Summary
9
Security Management
Security Management
Using the Oracle Wallet to encrypt backups
The enterprise user
Summary
10
Database Configuration Assistant
Database Configuration Assistant
DBCA
Database creation
Database edition
Database template management
Automatic Storage Management configuration
DBCA, Batch mode
Summary
11
Oracle Universal Installer
Oracle Universal Installer
OUI basics
OUI basic and advanced installation modes
Modes of installation
OUI command line parameters
Silent installation mode
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 Configuration Assistant
Enterprise Manager Components
Enterprise Manager configuration
EMCA Command Line Interface
EMCA 10g Release 1
EM directory structure
Environment changes
Securing Enterprise Manager
Summary
13
OPatch
OPatch
OPatch
Downloading the latest OPatch version
OPatch requirements
OPatch syntax
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
Hot patching (11g only)
Troubleshooting OPatch
Using Enterprise Manager for software maintenance
Managing Patches in EM 11g
Summary

About the Author

Hector R. Madrid is a highly respected Oracle professional with 20 years of experience as a full time DBA. He has been working with Oracle databases from version 5.0 up to the latest 11g release. He was the first Oracle Certified Master in Latin America and he holds the Oracle Certified Professional certificate for all Oracle versions starting with 7.3 up to 11g.

He obtained a bachelor's degree in Electronic Engineering from the Metropolitan Autonomous University in 1992, with a major in Digital Systems and Computers. He obtained a Master's degree in Computer Science from the same University. He has collaborated with Oracle Corp. as an instructor teaching the database track since 1996.

Hector works as a database consultant for several major firms, dealing with a wide range of DBA requirements, ranging from daily DBA tasks to defining and maintaining mission critical and high availability systems.

He has presented different technical papers at several Oracle conferences. He is the author of the Blog 'Oracle by Madrid' a Blog specializing in Oracle database topics.

To my parents Higinio Rivera and Teresa Madrid who taught me the basis of who I am now.

My wife Claudia and my daughter Alexandra for their extraordinary patience and support during the development of this book

Hans Forbrich, a respected Oracle ACE Director, who has forged each letter of this title with knowledge and experience, for his valuable technical feedback and all his comments both in this book and in general in the Oracle community.

Previous Section
Next Chapter