Networking Overview
- Explaining solutions included with Oracle 9i 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