Oracle 10g / 11g Database Administration
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 the Database
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
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
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
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)
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
Example
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
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
Automatically
Manually
Example: Finding All
Modifications in the Current Redo Log File
Example of Mining Without
Specifying the List of Redo Log Files Explicitly
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
| 
