Oracle 11g / 12c Tutorial 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
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
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