Home / IT Books / Oracle 10g/11g Data and Database Management Utilities

Oracle 10g/11g Data and Database Management Utilities

Oracle 10g11g Data and Database Management Utilities

Data Pump provides these features:
• Better performance and more manageability than the old export/import
• It is a server side tool
• Resume / suspend control
• Network Mode
• Restartable
• Fine grained object Selection
• Provides a Metadata API

Transparent mode: This mode requires you to have the Oracle Wallet Manager properly configured. It uses the Oracle key management infrastructure. Transparent mode is best used for regular backups that are meant to be restored on the same system where they were taken from.

Password mode: This mode requires you to declare the password in the rman scripts by means of the SET ENCRYPTION ON IDENTIFIED BY password ONLY clause.

Dual mode: This mode is flexible, it uses both the transparent mode and the password mode. This kind of backup is useful when the data is to be recovered on environments where the wallet is not available. This provides an alternative means to restore the backup.

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

Oracle 10g/11g Data and Database Management Utilities


Top books

About huydam

Check Also

[UWP] The program could not build Windows Universal Samples

If you get this error like this: “Type universe cannot resolve assembly: System.Runtime, Version=4.0.0.0, Culture=neutral, …

Leave a Reply

Your email address will not be published. Required fields are marked *