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
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
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
Clearing REDO LOGFILES
Viewing Information About Logfiles
Multiplexing Control File
Changing the Name of a Database
Creating A New Control File
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
Example:
Convert Data from MS-ACCESS to Oracle
Example: Migrate Data from Fixed Length file into Oracle
Example: Convert from
MySQL to Oracle
Example:
Migrating data from MS SQL Server 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
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
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)
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
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
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.....
Interface Computers Academy © 2007-2017 All Rights Reserved