WA1381 Oracle Database 10g: Administration II Course Outline
 
1. DATABASE RECOVERY STRUCTURES
  • THE MECHANISMS FOR RECOVERY
  • SQL STATEMENT EXECUTION
  • EXAMINING THE RECOVERY COMPONENTS
2. IDENTIFYING THE DATA STRUCTURES
  • DATA STRUCTURES WITHIN THE DATABASE
  • IDENTIFYING THE TABLESPACES
  • IDENTIFYING THE CONTROL FILES
  • IDENTIFYING THE ALERT & TRACE FILES
  • IDENTIFYING THE REDO LOG FILES
3. ARCHIVING
  • DEVELOPMENT OF BACKUP & RECOVERY STRATEGIES
  • MANAGING THE ARCHIVE OPTIONS
4. USER-MANAGED PHYSICAL BACKUPS
  • BACKUP CHARACTERISTICS
  • PERFORMING A FULL BACKUP
  • PERFORMING AN OFFLINE TABLESPACE BACKUP
  • PERFORMING AN ONLINE TABLESPACE BACKUP
  • PERFORMING SUSPEND MODE BACKUPS
  • PERFORMING A CONTROL FILE BACKUP
5.AN OVERVIEW TO DATABASE RECOVERY
  • THE RECOVERY
  • IDENTIFYING THE TYPE OF FAILURE
6.INSTANCE RECOVERY & FAST-START
7. USER-MANAGED COMPLETE MEDIA RECOVERY
  • MEDIA FAILURE CONCEPTS
  • COMPLETE CLOSED RECOVERY
  • COMPLETE OPEN RECOVERY
  • HANDLING SPECIAL SITUATIONS
8. USER-MANAGED INCOMPLETE MEDIA RECOVERY
  • ABOUT INCOMPLETE RECOVERY
  • POINT-IN-TIME BASED RECOVERY
  • HANDLING SPECIAL SITUATIONS
9.USER-MANAGED INCOMPLETE MEDIA RECOVERY
  • ABOUT INCOMPLETE RECOVERY
  • POINT-IN-TIME BASED RECOVERY
10.HANDLING & ANTICIPATING STUCK RECOVERIES
  • ABOUT STUCK RECOVERIES
  • HANDLING CORRUPTION OF DATA
  • PERFORMING TRIAL RECOVERY
11. USER-MANAGED RECOVERY TROUBLESHOOTING
  • MOVE DATA FILE LOCATION
  • RECOVERY WITH NO DATA FILE BACKUP
  • HANDLING READ ONLY TABLESPACES
  • HANDLING THE LOSS OF CONTROL FILES
12. USING THE RECOVERY MANAGER (RMAN)
  • USING THE RECOVERY CATALOG
  • CONFIRMING REGISTRATION & OTHER OPERATIONS
  • USING RUN BLOCKS & SCRIPTS
  • ALLOCATING CHANNELS
  • ACCESSING RMAN VIA OEM
13. SERVER-MANAGED BACKUPS WITH RMAN
  • PERFORMING FULL BACKUPS
  • PERFORMING INCREMENTAL BACKUPS
14. EXPLORING ENHANCED RMAN CAPABILITIES
  • RESUME FAILED BACKUP OPERATIONS
  • ESTABLISHING A BACKUP RETENTION POLICY
  • SHOW ALL CONFIGURATION SETTINGS
  • GENERATE CATALOG REPORTS
  • REPORT SCHEMA
  • LIST INCARNATION
15. SERVER-MANAGED RECOVERY WITH RMAN
  • RECOVERY MANAGER RECOVERY
  • PERFORMING RESTORATION & FILE MEDIA RECOVERY
  • PERFORMING BLOCK MEDIA RECOVERY
16. STANDBY DATABASES WITH ORACLE DATA GUARD
  • ABOUT THE DATA GUARD ARCHITECTURE
  • DATA GUARD INTERFACES
17. DATA GUARD CONFIGURATION & OPERATION
  • CONFIGURING LOG TRANSPORT
  • CONFIGURING LOG APPLY
  • DATABASE SWITCHOVER OPERATIONS
  • DATABASE FAILOVER OPERATION
  • MONITORING THE STANDBY DATABASE