Oracle Database 12c Backup, Recovery and Server Tuning

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

Configuring RMAN

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

Generating RMAN backups

• Optimising 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 forwards image copies with incremental backups
• Retrieving individual tables with table-level recovery

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

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

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

Exploiting manual performance techniques

• Optimising 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 minimise 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