Done. Using Backup and Recovery in Oracle Database 12c

These flashcards cover key vocabulary and concepts related to backup and recovery in Oracle Database 12c, enabling effective exam preparation.

ARCHIVELOG mode

A mode that allows the database to archive redo log files before they are overwritten, enabling recovery of committed transactions.

Control File

A binary file that stores the structure of the database and important metadata such as data file locations and their states.

Fast Recovery Area (FRA)

A designated storage location for Oracle to manage all recovery-related files, such as undo data, archived logs, and backup files.

Redo Log Files

Files that record changes to the database before they are written to data files, essential for restoring the database to a consistent state.

Incremental Backup

A backup that only includes changes made since the last backup, allowing for faster recovery times.

Recovery Manager (RMAN)

Oracle's command-line tool for backing up, restoring, and recovering Oracle databases.

Data Recovery Advisor (DRA)

A feature that helps DBAs diagnose and repair database failures automatically, integrating with RMAN.

Checkpoint (CKPT)

A process that synchronizes the data files with the control file, recording the last successful transaction.

Flashback Query

A feature that allows users to view the state of a table at a specified time in the past using undo data.

User-managed Backup

A traditional method of backup where the DBA manually performs backup operations using operating-system commands.