Oracle Database 12c Backup, Recovery and Server Tuning

Oracle Database 12c Backup and Recovery Course Outline

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

• Backing up and Recovering with Cloud Control 12c

  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

  • 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