Keesling Donna, Kim Sean. Oracle Database 19C: Backup and Recovery

2020. — 414 p.Course Practice Environment: Security Credentials
Course Practice Environment: Security Credentials.
Practices for Lesson 1: Backup and Recovery Overview
Practices for Lesson 1: Overview.
Practices for Lesson 2: Backup and Recovery Configuration
Practices for Lesson 2: Overview.
Practice 2-1: Verifying that the Control File is Multiplexed.
Practice 2-2: Configuring the Size of the Fast Recovery Area.
Practice 2-3: Verifying that the Redo Log File Is Multiplexed.
Practice 2-4: Configuring ARCHIVELOG Mode.
Practices for Lesson 3: Using Recovery Manager (RMAN)
Practices for Lesson 3.
Practice 3-1: Configuring the Default Backup Destination.
Practice 3-2: Setting the Date and Time Format for RMAN.
Practice 3-3: Configuring RMAN Settings.
Practices for Lesson 4: Backup Strategies
Practices for Lesson 4: Overview.
Practices for Lesson 5: Creating Database Backups
Practices for Lesson 5: Overview.
Practice 5-1: Backing Up the Control File.
Practice 5-2: Verifying Automatic Backups of the Control File and SPFILE.
Practice 5-3: Creating a Whole Database Backup.
Practice 5-4: Creating Partial Database Backups.
Practice 5-5: Configuring Block Change Tracking.
Practice 5-6: Using Incremental Backups.
Practice 5-7: Backing Up Additional Database Files.
Practices for Lesson 6: Using Optional Backup Features
Practices for Lesson 6: Overview.
Practice 6-1: Creating an Archival Backup.
Practices for Lesson 7: Tuning RMAN Backup Performance
Practices for Lesson 7: Overview.
Practice 7-1: Monitoring an RMAN Backup Job.
Practices for Lesson 8: Recovery Catalog Overview
Practices for Lesson 8.
Practices for Lesson 9: Creating a Recovery Catalog
Practices for Lesson 9: Overview.
Practice 9-1: Creating a Recovery Catalog Owner.
Practice 9-2: Creating the Recovery Catalog.
Practices for Lesson 10: Managing Target Database Records
Practices for Lesson 10: Overview.
Practice 10-1: Registering a Database in the Recovery Catalog.
Practice 10-2: Configuring the Recovery Catalog for Recovery.
Practices for Lesson 11: Using Stored Scripts
Practices for Lesson 11: Overview.
Practice 11-1: Creating a Stored Script.
Practice 11-2: Executing a Stored Script.
Practices for Lesson 12: Creating and Using Virtual Private Catalogs
Practices for Lesson 12: Overview.
Practice 12-1: Enabling the Virtual Private Database (VPD) Functionality.
Practice 12-2: Creating a Virtual Private Catalog.
Practice 12-3: Backing Up a PDB.
Practices for Lesson 13: Restore and Recovery Concepts
Practices for Lesson 13.
Practices for Lesson 14: Diagnosing Failures
Practices for Lesson 14: Overview.
Practice 14-1: Diagnosing and Repairing Database Failure.
Practices for Lesson 15: Performing Complete Recovery
Practices for Lesson 15: Overview.
Practice 15-1: Recovering from the Loss of a System-Critical Data File.
Practice 15-2: Recovering from the Loss of an Application Data File.
Practices for Lesson 16: Performing Point-in-Time Recovery
Practices for Lesson 16: Overview.
Practice 16-1: Recovering from Media Failure: Incomplete Recovery.
Practice 16-2: Recovering a Table from a Backup.
Practices for Lesson 17: Performing Block Media Recovery
Practices for Lesson 17: Overview.
Practice 17-1: Repairing Block Corruption.
Practices for Lesson 18: Performing Additional Recovery Operations
Practices for Lesson 18: Overview.
Practice 18-1: Recovering from the Loss of a Parameter File.
Practice 18-2: Restoring the Control File.
Practice 18-3: Recovering from the Loss of All Control Files.
Practice 18-4: Restoring the Password File.
Practices for Lesson 19: Oracle Flashback Technology Overview
Practices for Lesson 19: Overview.
Practices for Lesson 20: Using Logical Flashback Features
Practices for Lesson 20: Overview.
Practice 20-1: Preparing to Use Flashback Technologies.
Practice 20-2: Restoring a Dropped Table.
Practice 20-3: Using Flashback Table.
Practices for Lesson 21: Using Flashback Database
Practices for Lesson 21: Overview.
Practice 21-1: Enabling Flashback Logging.
Practice 21-2: Performing Flashback Database.
Practices for Lesson 22: Using PDB Snapshots
Practices for Lesson 22.
Practices for Lesson 23: Database Duplication Overview
Practices for Lesson 23.
Practices for Lesson 24: Creating a Backup-Based Duplicate Database
Practices for Lesson 24: Overview.
Practice 24-1: Duplicating a Database.
Practice 24-2: Duplicating a PDB into an Existing CDB.