Curriculum
- 1 Section
- 22 Lessons
- 5 Days
Expand all sectionsCollapse all sections
- Topics22
- 1.1MANAGING MEMORY ABOUT advanced administration ABOUT manual memory management AUTOMATIC memory management MEMORY_ target MEMORY_MAX_TARGET SGA_TARGET SGA-MAX_SIZE WORKAREA_SIZE_POLICY & pga_aggressive_target USING EM & the memory advisors MONITOR in memory access mode
- 1.2MANAGING STORAGE & THE SEGMENT ADVISOR MONITOR tablespaces ABOUT resumable space allocation TABLE storage management USE the segment advisor
- 1.3GLOBALIZATION GLOBALIZATION settings NLS_LANG NLS_LANGUAGE & NLS_TERRITORY DATE & time localization LINGUISTIC indexes ABOUT locale builder
- 1.4DIAGNOSING DATABASE PROBLEMS FAULT diagnosability infrastructure USING the alert log ABOUT the trace files DATABASE instance health snapshot USING the support workbence ENABLE oracle configuration manage
- 1.5RECOVERY CONCEPTS THE backup & recovery structures ORACLE secure backup MANAGING redo data MANAGING archived redo data CHECKLIST for sound recovery
- 1.6ORACLE FLASHBACK TECHNOLOGY ABOUT flashback technology SELECT…as of timestamp SELECT…as of SCN UNDO management for flashback UNDO_retention FLASHBACK table FLASHBACK drop FLASHBACK versions query FLASHBACK transaction query FLASHBACK transaction backout
- 1.7FLASHBACK DATABASE & FLASHBACK DATA ARCHIVE ABOUT flashback database CONFIGURING the flash recovery area PEROFRMING database flashback MONITORING flashback performance FLASHBACK database considerations CONFIGURE flashback
- 1.8MANAGING RESOURCES RESOURCE manager architecture CONSUMER groups RESOURCE plans AUTOMATIC & adaptive mapping ACTIVATING plans MONITORING resource allocation EXPLICIT consumer group switching INSTANCE caging
- 1.9AUTOMATING TASKS WITH THE SCHEDULER (BASIC) SCHEDULER architecture MANAGE programs MANAGE schedules MANAGE jobs
- 1.10AUTOMATING TASKS WITH THE SCHEDULER (ADVANCED) MANAGE job classes MANAGE windows & window groups MANAGE chains ABOUT events & the scheduler
- 1.11MANAGING DATABASE PERFORMANCE MANAGEMENT & advisory framework MANGE AWR ADDM SQL tuning advisor SQL access advisor
- 1.12INSTANCE RECOVERY ABOUT instance recovery INSTANCE recovery parallelism CHANGING recovery_parallelism MTTR advisor & tuning checkpoints LOG_CHECKPOINTS_TO_ALERT REDO logfile size advisor FAST-START ON-DEMAND parallelism
- 1.13CONFIGURING RMAN RMAN architecture LAUNCE & use RMAN CONFIGURE RMAN settings ALLOCATE RMAN channels
- 1.14BACKUP WITH RMAN ABOUT backup file types PERFORMING full backups PERFORMING incremental backups ESTABLISHING backup retention policy GENERATE reports REPROT unrecoverable REPORT need backup LIST incarnation
- 1.15RMAN MANAGEMENT WITH EM MONITORING the flash recovery area THE EM interface to RMAN SCHEUDLING RMAN backups ORACLE-SUGGESTED backup strategy MANAGE current backups BACKUP reports MANAGE restore points
- 1.16USER-MANAGED RECOVERY OPERATIONS RECOVERY concepts RECOVER temporary tablespaces RECOVER read-only tablespaces RECOVER index tablespaces RECOVER redo log group member RECREATE the password file
- 1.17RECOVERY WITH RMAN COMPLETE media recovery INCOMPLETE media recovery RECOVERY using EM
- 1.18USING THE RMAN RECOVERY CATALOG UNDERSTANDING catalog concepts CREATE the recovery catalog MANAGE virtual private catalogs PROTECTION of the recovery catalog USING RMAN scripts
- 1.19DATABASE DUPLICATION & CLONING WHY perform database duplication? RMAN duplicate database RMAN duplicate DATABASE cloning
- 1.20ADVANCED RMAN CAPABILITIES BACKUP optimization ENHANCHING parallelism, section sizes BACKUP performance & control MINIMIZE time vs. minimize load ARCHIVAL backups COPYING files between databases
- 1.21TRANSPORTING TABLESPACES ABOUT tablespace transportation READ-ONLY tablespace transportation READ-WRITE tablespace transport TRANSPORT tablespaces using EM
- 1.22RECOVERING FROM CURRUPTION WITH DATA RECOERY ADVISOR HOW does corruption occur? DETECTING corruption ANALYZE V$DATABASE_BLOCK-_CORRUTION view DB_BLOCK_CHECKING DB_BLACK_CHECKSUM DB_LOST_WRITE_PROTECT DB_ULTRA_SAFE USING the data recovery advisor BLOCK media recovery DBMS_REPAIR() isolation