Data Structures Used for backup and recovery in DB2 and Oracle (1)

This article describes in detail the data structures used for backup and recovery in DB2 and Oracle. Both databases have a group of components that constitute the backup and recovery mechanisms, the main backup and recovery components are illustrated below for your reference.

Data structure used for backup and recovery

Both Oracle and DB2 UDB have a group of components that form backup and recovery mechanisms. The architecture diagram shown in figures 1 and 2 gives an overview of the main components that provide Oracle and DB2 backup and recovery.

Figure 1. Oracle Architecture

Oracle Memory Structure

Buffer cache-memory allocated to store data blocks read from physical data files.

Shared Pool-memory allocated to store parsed SQL statements and data dictionary information of PL/SQL processes.

Log buffer-memory allocated to store the images before and after the changed data. The data items recorded in it are continuous.