This diagram shows the logical, physical, and recovery-related structures of the database, and the relationships between them. Dotted horizontal lines divide the image into three sections. The top section shows logical structures, the middle section shows physical structures, and the bottom section shows recovery-related structures in the flash recovery area.

The logical structures are all tablespaces. Each tablespace points to a datafile or tempfile, which are physical structures. Other physical structures include a control file, a server parameter file, and a password file.

The flash recovery area contains the following structures: a backup of the server parameter file and control file (stored in an archival format called a backup set); another backup set containing a backup of the datafiles; the online redo log files; and the archived redo log files, which are copies of redo log files after they are filled.