Oracle Database 11g: Administration II

Request more details:

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.
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