Oracle 9i: Database Administration Fundamentals 2

What you will learn:
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.

Why Oracle 9i training from Mapple Edusoft :

• Official Course-ware from Oracle University.
  
• Authorized Structured Oracle Training in Jaipur.
• Highly Qualified Java Industry Experts as Trainer.
• Hands on experience on Oracle Software.
  
• Course Completion Certificate From Oracle University.
  
• Discount Vouchers for International Exams.
• 10 Full-length Online Mock Tests (Real-life Oracle® Exam) per Module.
  

Prerequisites :

• Introduction to Oracle 9i: SQL
  Oracle9i Database: Administration Fundamentals 1
  

Course Topics :
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 & 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

Certificate From Oracle University :

Oracle Training in Jaipur - DBA, Developer - OCA -OCP

Authorized Oracle 9i Training in Jaipur @ Mapple Edusoft