Oracle DBA - Level 3

Oracle DBA - Level 3

Oracle Database Administration – central level for configuration, securing, maintaining and protecting databases

Recovery and Flashback

• Restore and Recovering Databases with RMAN
• Perform CDB and PDB flashback

Backup Strategies and Terminology

• Perform Full and Incremental Backups and Recoveries
• Compress and Encrypt RMAN Backups
• Use a media manager
• Create multi-section backups of very large files
• Create duplexed backup sets
• Create archival backups
• Backup of recovery files
• Backup non database files
• Back up ASM meta data

Restore and Recovery Concepts

• Employ the best Oracle Database recovery technology for your failure situation
• Describe and use Recovery technology for Crash, Complete, and Point-in-time recovry

Using Flashback Technologies - Oracle Database: Backup and Recovery Workshop

• Configure  your Database  to support Flashback
• Perform flashback operations

Duplicating a Database

• Duplicate Databases

Configuring and Using RMAN - Oracle Database: Backup and Recovery Workshop

• Configure RMAN and the Database for Recoverability
• Configureand Using an RMAN recovery catalog

Diagnosing Failures

• Detect and repair database and database block corruption
• Diagnosing Database Issues

Performing Recovery

• Restore and Recovering Databases with RMAN
• Perform Non RMAN database recovery

Transporting Data

• Transport Data (Exporting / Importing)
• Transportable Tablespaces
• Transportable databases