Oracle Database 10g: Administration II

Request more details:

Description:
The overall objective of this course is to 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. Specific subjects to be considered are: Using flashback technology to recover from user errors and from database failures. Controlling resource utilization on database servers whose resource demand exceeds its capacity. Automating routine tasks and functions using the database Scheduler. Handling database corruption and even preventing such occurrences wherever possible. Utilizing diagnostic sources in troubleshooting database problems. Automatic database management, monitoring and tuning facilities. Included is automatic management of storage space and memory resources within the database. Automatic resumption of database operations even in the face of failures and errors. User-managed and automatically managed backup strategies and database recovery operations.

View other Oracle Courses available
Prerequisites:
Oracle Database 10g: Administration I
ORACLE FLASHBACK TECHNOLOGY :
about flashback technology
flashback query select...as of timestamp
select...as of scn flashback table
flashback versions query
flashback transaction query
guarantee undo retention
MANAGING RESOURCES :
database resource manager architecture
consumer groups
resource plans
automatic & adaptive consumer group mapping
enabling & monitoring the resource manager
explicit consumer group switching
AUTOMATING TASKS WITH THE DATABASE SCHEDULER (BASIC) :
scheduler architecture
manage programs
manage schedules
manage jobs
AUTOMATING TASKS WITH THE DATABASE SCHEDULER (ADVANCED) :
manage job classes
manage windows & window groups
manage chains
about events & the scheduler
GLOBALIZATION SUPPORT OBJECTIVES :
globalization settings
nls_lang
nls_language & nls_territory
date & time localization
linguistic indexes
about locale builder
HANDLING DATABASE CORRUPTION :
about database corruption
db_block_checksum
analyze...validate structure
dbverify
using dbms_repair()
DIAGNOSTIC SOURCES :
more about the trace & alert files
diagnostic highlights from em
configuring the alert log
managing policies
SECURING THE ORACLE LISTENER :
managing & monitoring the listener
secure the listener
secure external procedure calls
MONITORING & MANAGING MEMORY :
automatic shared memory management
using em & the memory advisors
monitor in memory access mode
MONITORING & MANAGING STORAGE :
about resumable space allocation
table management
using the segment advisor
MANAGING REDO LOG STORAGE & MONITORING INSTANCE RECOVERY :
about redo data
tune redo writing & archiving
more about instance recovery
log_checkpoints_to_alert flashback database
about flashback database
configuring the flash recovery area
performing database flashback
monitoring
FLASHBACK PERFORMANCE :
flashback database considerations
CONFIGURING RMAN :
about database backup & recovery structures
rman architecture
launch & use rman
configure rman
allocate rman channels
BACKUP WITH RMAN :
about backup file types
performing full backups
performing incremental backups
establishing a backup retention policy
generate catalog reports
report unrecoverable
report need backup
report schema
list incarnation
BACKUP WITH RMAN USING EM :
monitoring the flash recovery area
about em & rman
scheduling backups with rman
manage current backups
backup reports
manage restore points
NON-CRITICAL RECOVERY OPERATIONS :
about the recovery process
recover temporary tablespaces
recover read-only tablespaces
recover index tablespaces
recover redo log group member
recreate the password file
DATABASE RECOVERY OPERATIONS :
control file recovery
complete media recovery
incomplete media recovery
performing block media recovery
recovery using em
AUTOMATIC STORAGE MANAGEMENT :
asm and the broader database architecture
defining an asm instance
configuring storage in the asm instance