Data base administrator DBA Online for freshers by Dheeksha Technologies

Oracle DBA Concepts
Introduction to Oracle Database
Overview of Oracle Grid Architecture
Difference between a cluster and a grid
Responsibilities of Database Administrators
Creating Oracle Database
Creating Oracle 11g / 10g Database using SQL commands
Creating Oracle Container Database in 12c using DBCA
Managing Table spaces and Data files
Creating New Table spaces
Big file Tables paces (Introduced in Oracle Ver. 10g)
To Extend the Size of a tablespace
To decrease the size of a tablespace
Coalescing Tablespaces
Taking tablespaces Offline or Online
Making a Tablespace Read only.
Renaming Tablespaces
Dropping Tablespaces
Viewing Information about Tablespaces and Datafiles
Relocating or Renaming Datafiles
Renaming or Relocating Datafiles belonging to a Single Tablespace
Procedure for Renaming and Relocating Datafiles in Multiple
Tablespaces
Temporary Tablespace
Increasing or Decreasing the size of a Temporary Tablespace
Tablespace Groups
Creating a Temporary Tablespace Group
Assigning a Tablespace Group as the Default Temporary Tablespace
Diagnosing And Repairing Locally Managed Tablespace Problems
Scenario1: Migrating from a Dictionary-Managed to a Locally Managed Tablespace
Transporting Tablespaces
Procedure for transporting tablespaces
Transporting Tablespace Example
Managing REDO LOGFILES
Adding a New Redo Logfile Group
Adding Members to an existing group
Dropping Members from a 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
Managing The UNDO TABLESPACE