Oracle Database 11g: Administration II

This course has been superseded

We suggest the following instead:
Oracle Database Administration Course

Course Description

This Oracle 11g training course will bring database administrators beyond a basic understanding of their environment and to focus attention on more advanced skills needed to effectively configure, administer, monitor and tune the database within a large-scale enterprise.
5 Days
Contact us for pricing
 

Prerequisites

Many students taking this course have familiarity with system administration and administration of other non-Oracle databases, and this is helpful though not mandatory. Specific course prerequisites for this course are:
• ORACLE DATABASE 11g: SQL FUNDAMENTALS – COMPLETE LIBRARY
• ORACLE DATABASE 11g: PL/SQL FUNDAMENTALS – COMPLETE LIBRARY
• ORACLE DATABASE 11g: ADMINISTRATION I

MANAGING MEMORY

ABOUT MANUAL MEMORY MANAGEMENT
AUTOMATIC MEMORY MANAGEMENT
MEMORY_TARGET
MEMORY_MAX_TARGET
SGA_TARGET
SGA_MAX_SIZE
WORKAREA_SIZE_POLICY & PGA_AGGREGATE_TARGET
USING EM & THE MEMORY ADVISORS
MONITOR IN MEMORY ACCESS MODE

MANAGING STORAGE & THE SEGMENT ADVISOR

MONITOR TABLESPACES
ABOUT RESUMABLE SPACE ALLOCATION
TABLE STORAGE MANAGEMENT
PCTFREE Illustrated
USE THE SEGMENT ADVISOR
Using The SHRINK SPACE Option
CASCADE To Dependent Objects
Optionally Call DELETE_TASK()

MANAGING RESOURCES

DATABASE RESOURCE MANAGER ARCHITECTURE
CONSUMER GROUPS
RESOURCE PLANS
AUTOMATIC & ADAPTIVE CONSUMER GROUP MAPPING
ACTIVATING PLANS
MONITORING RESOURCE ALLOCATION
EXPLICIT CONSUMER GROUP SWITCHING

AUTOMATING TASKS WITH THE SCHEDULER (BASIC)

SCHEDULER ARCHITECTURE
RAC Environment
MANAGE PROGRAMS
MANAGE SCHEDULES
MANAGE JOBS

AUTOMATING TASKS WITH THE SCHEDULER (ADVANCED)

MANAGE JOB CLASSES
MANAGE WINDOWS & WINDOW GROUPS
MANAGE CHAINS
ABOUT EVENTS & THE SCHEDULER

GLOBALIZATION

GLOBALIZATION SETTINGS
NLS_LANG
NLS_LANGUAGE & NLS_TERRITORY
DATE & TIME LOCALIZATION
LINGUISTIC INDEXES
ABOUT LOCALE BUILDER

DIAGNOSING DATABASE PROBLEMS

ABOUT THE FAULT DIAGNOSABILITY INFRASTRUCTURE
ADR Highlights From EM
USING THE ALERT LOG
ABOUT THE TRACE FILES
DATABASE INSTANCE HEALTH SNAPSHOT
USING THE SUPPORT WORKBENCH
ENABLE ORACLE CONFIGURATION MANAGER

AUTOMATIC STORAGE MANAGEMENT

ASM & THE BROADER DATABASE ARCHITECTURE
CREATING THE ASM INSTANCE
ADMINISTERING THE ASM INSTANCE
SYSASM Super Administrator
ASM Storage Parameters
Using DBCA
Using ASMCMD
CONFIGURING DATABASES FOR ASM STORAGE
DBCA
DBUA
ASM Migration Using EM

RECOVERY CONCEPTS

ABOUT THE BACKUP & RECOVERY STRUCTURES
MANAGING REDO DATA
Is LOG_BUFFER Large Enough?
What V$LOG Reveals
What V$LOG_HISTORY Reveals
What V$LOGFILE Reveals
What V$ARCHIVED_LOG Reveals
MANAGING ARCHIVED REDO DATA
ARCHIVELOG Status
CREATING A FOUNDATION FOR SOUND RECOVERY

ORACLE FLASHBACK TECHNOLOGY

ABOUT FLASHBACK TECHNOLOGY
FLASHBACK QUERY
SELECT...AS OF TIMESTAMP
SELECT...AS OF SCN
Using DBMS_FLASHBACK()
CONFIGURING UNDO MANAGEMENT FOR FLASHBACK
UNDO_RETENTION
FLASHBACK TABLE
FLASHBACK DROP
FLASHBACK VERSIONS QUERY
FLASHBACK TRANSACTION QUERY
FLASHBACK TRANSACTION BACKOUT

FLASHBACK DATABASE

ABOUT FLASHBACK DATABASE
CONFIGURING THE FLASH RECOVERY AREA
More About DB_RECOVERY_FILE_DEST
PERFORMING DATABASE FLASHBACK
MONITORING FLASHBACK PERFORMANCE
FLASHBACK DATABASE CONSIDERATIONS
CONFIGURE FLASHBACK DATA ARCHIVE

INSTANCE RECOVERY

ABOUT INSTANCE RECOVERY
SMON Process & Instance Recovery
PMON Process & Process Recovery
INSTANCE RECOVERY PARALLELISM
Changing RECOVERY_PARALLELISM
MTTR ADVISOR & TUNING CHECKPOINTS
LOG_CHECKPOINTS_TO_ALERT
REDO LOGFILE SIZE ADVISOR
FAST-START ON-DEMAND PARALLELISM

CONFIGURING RMAN

RMAN ARCHITECTURE
RMAN Sample Backup Session
LAUNCH & USE RMAN
CONFIGURE RMAN SETTINGS
ALLOCATE RMAN CHANNELS

BACKUP WITH RMAN

ABOUT BACKUP FILE TYPES
PERFORMING FULL BACKUPS
PERFORMING INCREMENTAL BACKUPS
ESTABLISHING A BACKUP RETENTION POLICY
GENERATE REPORTS
REPORT UNRECOVERABLE
REPORT NEED BACKUP
LIST INCARNATION
VALIDATE BACKUP DATA INTEGRITY

RMAN MANAGEMENT WITH EM

MONITORING THE FLASH RECOVERY AREA
THE EM INTERFACE TO RMAN
SCHEDULING RMAN BACKUPS
USING THE ORACLE-SUGGESTED BACKUP STRATEGY
MANAGE CURRENT BACKUPS
BACKUP REPORTS
MANAGE RESTORE POINTS

USER-MANAGED RECOVERY OPERATIONS

RECOVERY CONCEPTS
RECOVER TEMPORARY TABLESPACES
RECOVER READ-ONLY TABLESPACES
RECOVER INDEX TABLESPACES
RECOVER REDO LOG GROUP MEMBER
RECREATE THE PASSWORD FILE

RECOVERY WITH RMAN

COMPLETE MEDIA RECOVERY
INCOMPLETE MEDIA RECOVERY
TSPITR
DBPITR
RECOVERY USING EM
OracleOracle 11gOracle Database 11gOracle Database Administration