Oracle 10g/11g Data and Database Management Utilities | Oracle 10g/11g Data and Database Management Utilities

Sign In Start Free Trial

Book Overview & Buying
Table Of Contents

Oracle 10g/11g Data and Database Management Utilities

By : Hector R. Madrid

4 (1)

Oracle 10g/11g Data and Database Management Utilities

4 (1)

By: Hector R. Madrid

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.

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

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

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

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

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

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

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

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

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

Security Management

Security Management

Using the Oracle Wallet to encrypt backups

The enterprise user

Summary

Database Configuration Assistant

Database Configuration Assistant

DBCA

Database creation

Database edition

Database template management

Automatic Storage Management configuration

DBCA, Batch mode

Summary

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

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

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

Oracle 10g/11g Data and Database Management Utilities

Copyright © 2009 Packt Publishing

All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews.

Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. Neither the author, Packt Publishing, nor its dealers or distributors will be held liable for any damages caused or alleged to be caused directly or indirectly by this book.

Packt Publishing has endeavored to provide trademark information about all the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information.

First published: June 2009

Production Reference: 1220609

Published by Packt Publishing Ltd.

32 Lincoln Road

Olton Birmingham, B27 6PA, UK.

ISBN 978-1-847196-28-6

www.packtpub.com

Cover Image by Vinayak Chittar (<[email protected]>)

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Oracle 10g/11g Data and Database Management Utilities

Search

Your notes and bookmarks