logo

Bangalore

Lessons - Academic, Arts, Sports

Oracle 11g DBA Online/Onsite Courses

Bangalore, Karnataka - 23 Sep, 2013

Description

Oracle 11g DBA
Oracle Database 11g: Administration Workshop I
Audience:
Database Administrators
Database Designers
Developer
Support Engineer
Technical Administrator
Required Prerequisites:
A working knowledge of SQL (Basic)

Course Topics:
Oracle Database 11g Architecture
Oracle database architecture
The Oracle instance
Memory structures
Background processes
Server and client processes
The Oracle database
Installation and Configuration of an Oracle Database
System Hardware Requirements
Optimal Flexible Architecture
Install Oracle software using the Oracle Universal Installer (OUI)
Use the database Configuration Assistant (DBCA)
Create a database with DBCA
Manage a database with DBCA
Delete a database with DBCA
Manual DB creation (with & without OEM)
Creating Data Dictionary Views
Creating Standard Packages

Manage an Oracle Instance
Access an Oracle database
Database authentication methods
Password file
The Startup Process
The Shutdown Process
Initialization parameters
Shutdown a database and instance using SQL
Startup a database and instance using SQL
View alert log and trace files

Parameter management:
Setting Parameters in the Parameter file
Suspending and Quiescing the Database
Parameter file Management
Creating Server Parameter file using Text Parameter file
Managing Server Parameter file
Creating Text Parameter file using Server Parameter file

Tablespace and Datafile Management
Overview of tablespaces and datafiles
Locally managed tablespaces
Dictionary managed tablespaces
Bigfile tablespaces
Temporary tablespaces
Multiple temporary tablespaces & tablespace groups
Create tablespaces
Manage tablespaces
Use standard and non-standard block sizes
Create and manage tablespaces using OMF
Create and alter tablespace commands
Drop tablespace command

Manage Redo Logs
Redo log overview
Plan redo logs
Redo log data dictionary tables
Log switches and checkpoints
Log file maintenance
Add and drop log file members and groups
Clear a log file
Move or rename an online redo log file
Multiplex redo log files

Manage Control Files
The usage of the control file
The contents of a control file
Manage control files
Replace a lost or damaged control file
Mirror a control file
Manage control files with OMF
List control file information (MAX parameters)

Schema & IO management with partition tables:
Partitioned Table Management
Creating and Managing Range Partitioned Table
Creating and Managing Hash Partitioned Table
Creating and Managing Composite Partitioned Table
Creating and Managing List Partitioned Table
Creating and Managing Index-Organized Tables
Redefining Tables Online
Resumable Operations

Index management:
Index Management
Creating and Managing B*Tree Indexes
Creating and Managing Bitmap Indexes
Creating and Managing Partition Indexes
Index Monitoring

Manage Users
Database administration accounts
User accounts
Create a user account
Operating system authentication
Change a user's password
Manage a user account
Drop a user account
Monitor user information
Terminate user sessions
Product user profiles

Manage Profiles and Resources
Overview of user profiles
Profile resource parameters
Create profile command
Manage passwords with profiles
Control resource usage with profiles
Maintain profiles
Drop profiles

Managing Privileges
Database access
Oracle supplied roles
System level privileges
Object level privileges
The grant and revoke commands
Create roles
Modify and drop roles
Control the availability of roles
Use predefined roles
Synonyms
Listing valid grants

Undo Management
Undo data overview
Monitor and administer undo
Configure undo retention
Switch undo tablespaces
Specify the retention period
Guarantee undo retention
Oracle Database 11g: Administration Workshop II
Configuring for Recoverability
Purpose of Backup and Recovery (B&R), Typical Tasks and Terminology
Using the Recovery Manager (RMAN)
Configuring your Database for B&R Operations
Configuring Archivelog Mode
Configuring Backup Retention
Configuring and Using a Flash Recovery Area (FRA)
Using the RMAN Recovery Catalog
Tracking and Storing Backup Information
Setting up a Recovery Catalog
Recording Backups
Using RMAN Stored Scripts
Managing the Recovery Catalog
Configuring Backup Settings
Configuring and Managing Persistent Settings for RMAN
Configuring Autobackup of Control File
Backup optimization
Advanced Configuration Settings: Compressing Backups
Configuring Backup and Restore for Very Large Files (Multisection)

Creating Backups with RMAN
RMAN backup types
Creating and Using the following:
- Backup Sets and Image Copies
- Whole Database Backup
- Fast Incremental Backup
- Configure Backup Destinations
- Duplexed Backup Sets
- Archival Backups

Restore and Recovery Task
Restoring and Recovering
Causes of File Loss
Automatic Tempfile Recovery
Recovering from the Loss of a Redo Log Group
Recovering from a Lost Index Tablespace
Re-creating a Password Authentication File
Complete and Incomplete Recovery
Other Recovery Operations

Using RMAN to Perform Recovery
Complete Recovery after Loss of a Critical or Noncritical Data File
Recovering Image Copies and Switching Files
Restore and Recovery of a Database in NOARCHIVELOG Mode
Incomplete Recovery
Performing Recovery with a Backup Control File
Restoring from Autobackup: Server Parameter File and Control File
Restoring and Recovering the Database on a New Host

Diagnosing the Database
Data Recovery Advisor (DRA)
Block Corruption
Automatic Diagnostic Repository (ADR)
Health Monitor
The ADR Command-Line Tool, ADRCI
Using Flashback Technology I
Flashback Technology: Overview and Setup
Using Flashback Technology to Query Data
Flashback Table
Flashback Transaction Query
Performing Flashback Transaction Backout

Using Flashback Technology II
Oracle Total Recall
Flashback Drop and the Recycle Bin

Performing Flashback Database
Configuring Flashback Database
Performing Flashback Database Operations
Monitoring Flashback Database

Managing Resources
Database Resource Manager: Overview and Concepts
Accessing and Creating Resource Plans
Creating Consumer Group
Specifying Resource Plan Directives, including:
- Limiting CPU Utilization at the Database Level
- Instance Caging
Activating a Resource Plan
Monitoring the Resource Manager

Automating Tasks with the Scheduler
Simplifying Management Tasks
Creating a Job, Program, and Schedule

Managing Space in Blocks
Free Space Management
Monitoring Space
Compressing Data

Managing Space in Segments
Shrinking Segments
Managing Resumable Space Allocation

For more details mail to contact@ahana.co.in or call to 080-65462066

Related ads

ALL SIMILAR ADS