MapReduce course for graduates by Feria IT Solutions

Tasks of an Oracle Database Administrator

Installation of Oracle Database Software

Optimal Flexible Architecture (OFA)

Oracle Universal Installer

Prerequisite Checks

Installation

Configuration Assistants

Creating an Oracle Database

Database Architecture

Exploring the Storage Structure

Control Files

Redo Log Files

Table spaces and Data files

Segments, Extents, and Blocks

Oracle Instance Management

Oracle Memory Structures

Oracle Processes

Data Dictionary

Database Control

Grid Control

Database Configuration Assistant (DBCA) Overview

Creating a Database

Passwords and Storage

File Locations and Backup Recovery

Content and Initialization Parameters

Other Actions with DBCA

Managing the Database

Starting and Stopping iSQL*Plus

Starting and Stopping Database Control

Accessing Database Control

SYSOPER and SYSDBA

Database Home Page

Changing the Listener Status

NOMOUNT MOUNT OPEN States

SHUTDOWN Options

Initialization Parameter Files

Viewing the Alert Log

Net Services

Oracle Net Services

Oracle Net Listener

Monitoring the Listener

Listening Addresses

Static Database Registration

Listener Control Utility

Oracle Net Connections

Directory Naming

Advanced Connections

Oracle Net Manager

Configuring Service Aliases with Net Manager

Managing Schema Objects

Schemas

Accessing Schema Objects

Schema Object Namespaces

Specifying Data Types in Tables

Other Data Types

Creating and Modifying Tables

Understanding Data Integrity

Defining Constraints

Viewing the Attributes of a Table

Viewing the Contents of a Table

Creating Indexes

Creating Views

Using a Sequence

Storage Structures

Tablespaces and Data Files

Space Management in Tablespaces

Storage for Locally Managed Tablespaces

Altering a Tablespace

Actions with Tablespaces

Dropping Tablespaces

Viewing Tablespace Information

Administering Users

Database User Accounts

Creating a User

Profiles and Users

Authenticating Users

Database Users and Schemas

Privileges : System and Object

Roles

Assigning Quota to Users

Assigning Roles to Users

Managing Data

Data Pump Export

Data Pump Import

DIRECTORY Objects

Control File Syntax Considerations

Input Data and Data Files

Loading Methods

Comparing Direct and Conventional Path Loads

Loading Data with SQL*Loader

External Tables

Transportable tablespace

Undo Management

Undo Data

Transactions and Undo Data

Storing Undo Information

Monitoring Undo

Administering Undo

Configuring Undo Retention

Guaranteeing Undo Retention

Sizing the Undo Tablespace

Using the Undo Advisor

Backup and Recovery Concepts

Backup and Recovery Issues

Categories of Failures

Instance Recovery

Phases of Instance Recovery

Tuning Instance Recovery

Configuring for Recoverability

ARCHIVELOG Mode

Configuring Backup Strategy

Scheduling Backups: Review

Backup Control File to Trace

Manage Backups

Database Recovery

Opening a Database

Changing Instance Status

Keeping a Database Open

Scenarios:

Loss of a Control File

Loss of a Redo Log File

Loss of a Data File in NOARCHIVELOG Mode

Loss of a Noncritical Data File in ARCHIVELOG Mode

Loss of a System-Critical Data File in ARCHIVELOG Mode

Oracle Recovery Manager

Oracle Recovery Catalog maintenance

Backups using Oracle Recovery Manager

Recovery using Oracle recovery manager

Database Cloning using RMAN

Tablespace Point in time recovery

Incomplete recovery

many more.......