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


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
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


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


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)

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



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

Taking Online Backups using RMAN
Taking backups of particular tablespaces or datafiles using RMAN

How to take Image Backups in RMAN

Taking Incremental Backup using RMAN
Incrementally updating backup copy for fast recovery

View information about RMAN backups

Configuring Retention policy in Oracle RMAN
Configure various Options in RMAN
Maintaining RMAN Repository

Recovering from the loss of datafiles using RMAN (Archivelog mode)
Recovering from the loss of datafile by changing it’s location

Performing Disaster Recovery using RMAN

More coming soon…..


Trả lời

Mời bạn điền thông tin vào ô dưới đây hoặc kích vào một biểu tượng để đăng nhập: Logo

Bạn đang bình luận bằng tài khoản Đăng xuất /  Thay đổi )

Google+ photo

Bạn đang bình luận bằng tài khoản Google+ Đăng xuất /  Thay đổi )

Twitter picture

Bạn đang bình luận bằng tài khoản Twitter Đăng xuất /  Thay đổi )

Facebook photo

Bạn đang bình luận bằng tài khoản Facebook Đăng xuất /  Thay đổi )

Connecting to %s