Oracle Database 12c Backup, Recovery and Server Tuning

• Introduction to Backup and Recovery
• Backup and recovery concepts
• Defining the Oracle architecture
• The roles of the Oracle background processes
• Multitenant databases overview
• Safeguarding the Oracle Database

Ensuring resilience

• Configuring control and redo log files
• Returning tables to any point with Temporal History

Performing backups

• Choosing appropriate backup strategies
• Generating full, partial, hot and cold backups

Achieving full database recovery

• Recovering tablespaces and datafiles
• Repairing online redo logs

Flashing back the database for fast recovery

• Configuring flashback database
• Returning to pre-arranged restore points
• Automating Backup and Recovery with Recovery Manager (RMAN)

Configuring RMAN

• Contrasting control file and Recovery Catalog usage
• Creating and maintaining the Recovery Catalog
• Specifying redundancy and channel utilization

Generating RMAN backups

• Optimizing full and incremental backups
• Managing space in the fast recovery area
• Scripting the backup activity
• Listing and reporting on backups

Performing automated recovery

• Recovering data from backup sets and image copies
• Rolling forward image copies with incremental backups
• Retrieving individual tables with table-level recovery
• Backing up and Recovering with Cloud Control 12

Navigating the backup interface

• Configuring default backup settings
• Performing, scheduling and managing backup jobs

Simplifying recovery

• Achieving full recovery with default settings
• Diagnosing and fixing corruptions with Database Recovery Adviser
• Implementing Disaster Recovery with Data Guard

Setting up standby configuration

• Constructing the primary and standby parameter files
• Duplicating the primary database to create a standby
• Transporting and applying redo log data to the standby
• Ensuring performance using Far Sync
• Evaluating physical vs. logical standby databases

Managing and activating the standby database

• Keeping an active standby database in read-only mode with Active Data Guard
• Failing over and switching to the standby facility
• Implementing Security Measures with Limited Performance Impact

Enhancing data privacy with Data Masking and Data Redaction

• Establishing the requirements for Data Masking
• Scrambling data to mask personal information
• Securing third-party applications using Data Redaction
• Comparing full, partial and random redaction

Monitoring and recording database actions

• Simplifying auditing with Oracle 12c unified auditing
• Managing the audit policies
• Configuring and Tuning the Oracle Server

Exploiting manual performance techniques

• Optimizing the shared pool and the buffer cache
• Monitoring latch contention and wait events
• Enhancing query performance with the result cache

Managing performance with the automated tool set

• Automating memory management to minimize DBA tasks
• Leveraging Oracle Enterprise Manager (OEM) Database Express and Cloud Control 12c performance pages
• Tuning the server with the Automatic Workload Repository
• Performing predictive testing with Database Replay