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