Oracle Database 9i: Administration Fundamentals II.

V tomto kurzu, navazujícím na Oracle9i Administrace databáze I, si správce databáze doplní znalosti o témata týkající se zálohování, obnovy, přenosu dat a základní konfigurace sítí. Součástí kurzu jsou dvě skupinová cvičení, ve kterých si budou moci posluchači vyzkoušet řešení simulovaných případů nedostupnosti databáze. Používanou verzí serveru je Oracle9i R2, ale kurz je vhodný i pro správce databáze starších verzí Oracle.

Cíle kurzu
Configure the network environment for an Oracle client-server system
Describe the database utilities (Export and Import) and the situations where they can be used
Develop network configuration and recovery techniques through various workshop scenarios
List the Oracle architecture components related to backup and recovery operations
List the different Oracle backup methods and recovery operations that can be used to resolve database failure
Perform database and datafile backups with and without Recovery Manager (RMAN)
Define networking requirements and the solutions provided by Oracle to implement these requirements


Témata kurzu

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