Course Search:
Request more details:


Print Page

Oracle Database 11g: Backup & Recovery

Description:
This Oracle 11g training course will consider the latest and most advanced elements of a robust backup and recovery strategy for the Oracle database platform. It is intended to allow a database administrator to become certified as a backup and recovery specialist.
  • Cost: Price on application
  • Duration: 5 Days
  • This course is not available as part of our public schedule but can be provided on a customised client specific basis.
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 these titles:
• ORACLE DATABASE 11g: SQL FUNDAMENTALS – COMPLETE LIBRARY
• ORACLE DATABASE 11g: PL/SQL FUNDAMENTALS – COMPLETE LIBRARY
• ORACLE DATABASE 11g: ADMINISTRATION I
RECOVERY CONCEPTS :
ABOUT THE BACKUP & RECOVERY STRUCTURES
MANAGING REDO DATA
MANAGING ARCHIVED REDO DATA
CREATING A FOUNDATION FOR SOUND RECOVERY
ORACLE FLASHBACK TECHNOLOGY:
ABOUT FLASHBACK TECHNOLOGY
FLASHBACK QUERY
SELECT...AS OF TIMESTAMP
SELECT...AS OF SCN
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
PERFORMING DATABASE FLASHBACK
MONITORING FLASHBACK PERFORMANCE
FLASHBACK DATABASE CONSIDERATIONS
CONFIGURE FLASHBACK DATA ARCHIVE
INSTANCE RECOVERY:
ABOUT INSTANCE RECOVERY
INSTANCE RECOVERY PARALLELISM
MTTR ADVISOR & TUNING CHECKPOINTS
LOG_CHECKPOINTS_TO_ALERT
REDO LOGFILE SIZE ADVISOR
FAST-START ON-DEMAND PARALLELISM
CONFIGURING RMAN :
RMAN ARCHITECTURE
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
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
RECOVERY USING EM
USING THE RMAN RECOVERY CATALOG:
UNDERSTANDING CATALOG CONCEPTS
CREATE THE RECOVERY CATALOG
MANAGE VIRTUAL PRIVATE CATALOGS
DATA PROTECTION OF THE RECOVERY CATALOG
USING RMAN SCRIPTS
DATABASE DUPLICATION & CLONING:
WHY PERFORM DATABASE DUPLICATION?
RMAN DUPLICATE DATABASE
RMAN DUPLICATE
DATABASE CLONING
ADVANCED RMAN CAPABILITIES:
BACKUP OPTIMIZATION
ENHANCING PARALLELISM WITH SECTION SIZES
ARCHIVAL BACKUPS
BACKUP SET ENCRYPTION
COPYING FILES BETWEEN DATABASES
TRANSPORTING TABLESPACES:
ABOUT TABLESPACE TRANSPORTATION
READ-ONLY TABLESPACE TRANSPORTATION
READ-WRITE TABLESPACE TRANSPORTATION
TRANSPORT TABLESPACES USING EM
RECOVERING FROM CORRUPTION WITH DATA RECOVERY ADVISOR:
HOW DOES CORRUPTION OCCUR?
DETECTING CORRUPTION
ANALYZE
V$DATABASE_BLOCK_CORRUPTION View
DB_BLOCK_CHECKING
DB_BLOCK_CHECKSUM
DB_LOST_WRITE_PROTECT
DB_ULTRA_SAFE
RECOVERY USING THE DATA RECOVERY ADVISOR
BLOCK MEDIA RECOVERY
ISOLATING CORRUPTION WITH DBMS_REPAIR()


Dublin: 01 6627700 - Cork: 021 4319010 - Limerick: 061 311982

© Professional Training Solutions Limited 1996-2012
CRO No. 252390 - Unit 22, Westland Square, Pearse Street, Dublin 2, Ireland.