oracle sql and dba tutorial logo

Oracle DBA

Learn Oracle 11g / 12c Database Admin step by step



Oracle SQL

Tutorial for Oracle SQL

 

Oracle DBA Interview Questions

Most asked Oracle DBA Interview Questions.

60 Technical Questions
42 Backup & Recovery Questions

Unix For Oracle DBA 20 Questions


Download Oracle 11g Software

Links to Download Oracle 11g for Linux, Windows etc.



Oracle 11g / 12c Database Administration Topics


Oracle Database Administration Contents

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
Creating Oracle Container Database in 12c using SQL commands

Managing Oracle 12c Container Databases

Creating User Accounts and Connecting to Oracle 12c Container and Pluggable Databases

Managing Pluggable Databases in Oracle 12c

Creating Pluggable Database from Seed
Cloning an Existing Pluggable Database
Unplugging and Plugging databases from one CDB to another CDB

Managing Tablespaces and Datafiles

Creating  New Tablespaces
Bigfile Tablespaces (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

Scenario 1: Fixing Bitmap When Allocated Blocks are Marked Free (No Overlap)
Scenario 2: Dropping a Corrupted Segment
Scenario 3: Fixing Bitmap Where Overlap is Reported
Scenario 4: Correcting Media Corruption of Bitmap Blocks
Scenario 5: 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

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

SQL Loader

CASE STUDY (Loading Data from MS-ACCESS to Oracle)
CASE STUDY (Loading Data from Fixed Length file into Oracle)
CASE STUDY (Loading Data from MySQL to Oracle)
Loading Data into Multiple Tables using WHEN condition
Conventional Path Load and Direct Path Load
Direct Path
Restrictions on Using Direct Path Loads

Export and Import

Invoking Export and Import
Command Line Parameters of Export tool
Example of Exporting Full Database
Example of Exporting Schemas
Exporting Individual Tables
Exporting Consistent Image of the tables

Using Import Utility

Example Importing Individual Tables
Example, Importing Tables of One User account into another User account
Example Importing Tables Using Pattern Matching

Migrating a Database across platforms

DATA PUMP Utility

Using Data Pump Export Utility
Example of Exporting a Full Database
Example of Exporting a Schema
Exporting Individual Tables using Data Pump Export
Excluding and Including Objects during Export
Using Query to Filter Rows during Export
Suspending and Resuming Export Jobs (Attaching and Re-Attaching to the Jobs)

Data Pump Import Utility

Importing Full Dump File
Importing Objects of One Schema to another Schema
Loading Objects of one Tablespace to another Tablespace

Generating SQL File containing DDL commands using Data Pump Import

Importing objects of only a Particular Schema

Importing Only Particular Tables
Running Import Utility in Interactive Mode

Flash Back Features

Flashback Query
Using Flashback Version Query
Using Flashback Table to return Table to Past States
Purging Objects from Recycle Bin
Flashback Drop of Multiple Objects With the Same Original Name

Flashback Database: Alternative to Point-In-Time Recovery
Enabling Flash Back Database
To how much size we should set the flash recovery area

How far you can flashback database

Example: Flashing Back Database to a point in time

Flashback Data Archive (Oracle Total Recall)

Introduction
Creating Flashback Data Archive tablespace
Creating Flashback Data Archive
Querying historical data 

Log Miner

LogMiner Configuration
LogMiner Dictionary Options
Using the Online Catalog
Extracting a LogMiner Dictionary to the Redo Log Files
Extracting the LogMiner Dictionary to a Flat File

Redo Log File Options

Example: Finding All Modifications in the Current Redo Log File
Example : Mining Redo Log Files in a Given Time Range

 

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
        When the Database is running in Noarchivelog Mode
        When the Database is running in Archivelog Mode

Recovering from loss of Control File

Recovery Manager ( RMAN )

Taking Offline Backups using RMAN
Recovering the Database running in NOARCHIVELOG mode using RMAN

More coming soon.....

 

 


HomeContact Us

Data Loader

Data Loader is a simple yet powerful tool to
export and import Data between many common database formats


Forms Data Loader

Tool to load data into Oracle Applications 11i / R12 using Macros and Forms Record and Playback

Interface Computers Academy © 2007-2017 All Rights Reserved