Oracle DBA Programming

Course details

Oracle is the world's most popular and sophisticated databases.

This course helps students to make a career as a successful Oracle DBA.

Who Should Take This Course:

Those who are interested to make a career as Oracle DBA, should take the below modules progressively and this will help them be successful on their career path as a DBA.

Course Content:

Introduction

• Overview of Oracle Grid Architecture
• Difference between a cluster and a grid
• Responsibilities of Database Administrators

Managing Tablespaces and Datafiles

• Creating New Tablespaces
• Decreasing the size of a tablespace
• Coalescing Tablespaces & Taking
• tablespaces Offline or Online
• Making a Tablespace Read only
• Renaming & Dropping Tablespaces
• Temporary Tablespace
• Diagnosing and Repairing Locally
• Managed Tablespace Problems
• Transporting Tablespaces
• Viewing Information about Tablespaces and Datafiles
• Relocating or Renaming Datafiles

Managing REDO LOGFILES

• Adding a New Redo Logfile Group
• Adding & Dropping Members from an existing group
• Dropping Logfile Group
• Resizing Logfiles
• Renaming or Relocating Logfiles
• Clearing REDO LOGFILES
• Viewing Information About Logfiles

Managing Control Files

• Multiplexing Control File
• Changing the Name of a Database
• Creating A New Control File
• Cloning an Oracle Database

Managing the UNDO TABLESPACE

• Switching to Automatic Management of Undo Space
• Calculating the Space Requirements For Undo Retention
• Altering UNDO Tablespace
• Dropping an Undo Tablespace
• Switching Undo Tablespaces
• Viewing Information about Undo Tablespace

Import

• Invoking Export and Import
• Using Import Utility

DATA PUMP Utility

• Using Data Pump Export Utility
• Exporting Inpidual Tables using
• Data Pump Export
• Excluding and Including Objects during Export

Flash Back Features

• Flashback Query
• Enabling Flash Back Database

BACKUP AND RECOVERY

• Opening the Database in Archivelog Mode
• Bringing the Database again in NoArchiveLog mode
• Taking Offline (COLD) Backups
• Taking Online (HOT) Backups
• Recovering from the Loss of a Datafile