Oracle9i Database Administration Fundamentals II

Develop your ability to manage the industry's most advanced information system. Learn several methods to backup and to recover your Oracle database. Hands-on workshops give you experience in a realistic technical environment. Develop skills for basic network administration. Simplify your duties with Oracle Recovery Manager. This course gives the Oracle database administrator (DBA) a firm foundation in Oracle Net administration and backup and recovery operations.

Students learn about transporting data between databases and the utilities used to perform these activities. Students are also introduced to networking concepts and configuration parameters, as well as how to solve some common network problems. In hands-on exercises, students configure network parameters so that database clients and tools can communicate with the Oracle database server.

This course also addresses backup and recovery techniques, and examines various backup, failure, restore and recovery scenarios. Students also examine backup methodologies based on business requirements in a mission critical enterprise. Students use multiple strategies and Oracle Recovery Manager to perform backups, and restore and recovery operations. This course includes two interactive workshops that provide participants with the opportunity to walk through numerous real-world networking, backup, and recovery case studies.

course content details

	Networking Overview

	Explaining solutions included with Oracle9i for managing complex networks
	Describing Oracle networking add-on solutions

	Basic Oracle Net Architecture

	Explaining the key components of Oracle Net architecture
	Explaining Oracle Net Services role in client-server connections
	Describing how web client connections are established through Oracle networking products

	Basic Oracle Net Services Server-Side Configuration

	Identifying How the Listener Responds to Incoming Connections
	Configuring the Listener using Oracle Net Manager
	Controlling the Oracle Net Listener by Using the Listener Control Utility
	Describing Dynamic Service Registration
	Configuring the Listener for IIOP and HTTP Connections

	Basic Oracle Net Services Client-Side Configuration

	Describing the Difference Between Host Naming and Local Service Name Resolution
	Using Oracle Net Configuration Assistant to Configure Host Naming Method, Local Naming Method, and Net Service Names
	Performing Simple Connection Troubleshooting

	Usage and Configuration of the Oracle Shared Server

	Identifying the Components of the Oracle Shared Server
	Describing the Oracle Shared Server Architecture
	Configuring Shared Servers by Using Initialization Parameter
	Configuring Dispatchers by Using Initialization Parameters
	Identifying Useful Data Dictionary Views

	Backup and Recovery Overview

	Describing the Basics of Database Backup, Restore, and Recovery
	Listing the Types of Failures that May Occur in an Oracle Environment
	Defining a Backup and Recovery Strategy

	Instance and Media Recovery Structures

	Describing the Oracle Processes, Memory Structures, and Files Relating to Recovery
	Identifying the Importance of Checkpoints, Redo Log Files, and Archived Log Files
	Describing Ways to Tune Instance Recovery

	Configuration of the Database Archiving Mode

	Noarchivelog and Archivelog Mode Configuration
	Automatic and Manual Archiving of Redo Log Files
	Multiple Archival Destinations and Processes

	Oracle Recovery Manager (RMAN) Overview and Configuration

	Identifying the Features and Components of RMAN
	Describing the RMAN Repository and Control File Usage
	Describing Channel Allocation
	Describing Media Management Library Interface
	Connecting to Recovery Manager
	Configuring the RMAN Environment

	User-Managed Backups

	Describing User-Managed Backup and Recovery Operations
	Performing Closed Database Backups
	Performing Open Database Backups
	Cleaning Up After a Failed Online Backup
	Backing Up the Control File
	Discussing Backup Issues Associated with Read-Only Tablespaces
	Identifying the Backup Implications of Operations with NOLOGGING Options
	Using DBVerify to Check for Block Corruption

	RMAN Backups

	Identifying RMAN Specific Backups
	Using the RMAN BACKUP Command to Create Backup Sets
	Backing Up the Control File
	Backing Up the Archived Redo Log Files
	Using the RMAN COPY Command to Create Image Copies

	User-Managed Complete Recovery

	Describing Media Recovery
	Performing Recovery in Noarchivelog Mode
	Performing Recovery in Archivelog Mode
	Read-only Tablespace Recovery
	Relocating and Recovering a Tablespace

	RMAN Complete Recovery

	Describing the Use of RMAN for Restoration and Recovery
	Performing Recovery in Noarchivelog Mode
	Performing Completing Recovery in Archivelog Mode
	Restoring Data Files to a Different Location
	Relocating and Recovering a Tablespace

	User-Managed Incomplete Recovery

	Describing the Steps of Incomplete Recovery
	Identifying the Situations Which Require Incomplete Recovery
	Performing an Incomplete Recovery
	Recovering from the Loss of Current Online Redo Logs

	RMAN Incomplete Recovery

	Performing Incomplete Recovery Using UNTIL TIME
	Performing Incomplete Recovery Using UNTIL SEQUENCE

	RMAN Repository Maintenance

	Performing Crosschecking of Backups and Copies
	Updating the Repository When Backups Have Been Deleted
	Changing the Availability Status of Backups and Copies
	Making a Backup or Copy Exempt from the Retention Policy
	Cataloging Backups Made with Operating System Commands

	RMAN Catalog Creation and Usage

	Describing the Contents of the Recovery Catalog
	Listing the RMAN Features Which Require the Recovery Catalog
	Creating the Recovery Catalog
	Maintaining the Recovery Catalog by Using RMAN Commands
	Using RMAN to Register, Resynchronize, and Reset a Database
	Querying the Recovery Catalog to Generate Reports and Lists
	Creating, Storing and Executing Scripts
	Describing Methods for Backing Up and Recovering the Recovery Catalog

	Transporting Data Between Databases

	Export
	Import
	Guidelines for Using Export and Import

	Backup and Recovery and Networking Workshop