Diploma in Disaster Recovery Management (DDRM)

Module I - Oracle SQL

• Basic SQL Statement
• Restricting and Sorting Data
• Single Row Fucntions
• Displaying Data from Multiple Tables
• Aggregating Data by Using Group Functions
• Writing Sub queries
• Sqlplus, isqlplus
• Manipulating Data
• Managing Tab les, Constraints
• Views
• Other Database Objects
• Controlling User Access
• Using Set Operators
• Hierarchical Retrieval
• Oracle Extensions to and DDL Statements

Module II - Oracle Administration I

• Object Oriented Concepts
• Installing the Oracle Database Software
• Creating an Oracle Database
• Managing the Oracle Instance
• Managing Database Storage Structures
• Administering User Security
• Managing Schema Objects
• Managing Data and Concurrency
• Managing Undo Data
• Implementing Oracle Database Security
• Configuring the Oracle Network Environment
• Proactive Maintenance
• Performance Management
• Backup and Recovery Concepts
• Performing Database Backups
• Performing Database Recovery
• Performing Flashback
• Moving Data

Module III - Unix Fundamental & Shell Scripting

• Bash and Bash scripts
• The Bash environment
• Regular expression
• Building JSP pages
• Important Shell Utilities
• Conditional statements
• Writing interactive scripts
• Repetitive tasks
• More on variables
• Function
• Catching signals

Module VI - Administration II + Disaster Recovery Project

Administration II

• Configuring Recovery Manager
• Using Recovery Manager
• Oracle Secure Backup
• Recovering from Non-critical Losses
• Incomplete Recovery
• Flashback
• Dealing with Database Corruption
• Monitoring and Managing Memory
• Automatic Performance Management
• Monitoring and Managing Storage I
• Monitoring and Managing Storage II
• Automatic Storage Management
• VLDB Support
• Managing Resources
• Database Security
• Data Movement

Disaster Recovery Project

This project is about building a Disaster Recovery Site for your Oracle database. You will go through a step by step process on how to design, build and implement a Replicated DR site of an Oracle database. You will be using the following technologies to build the same.  


Oracle 11g Installation on Linux
Data Pump
Network Listener COnfiguration
Database Security, Profile, roles
Tablespace Management
RMAN backup & recovery
RMAN catalog
Database Cloning
Data Guard Setup and Configuration
Database Monitoring
Shell Scripting
ADDM, AWR - performance Tuning