|
Answer» The following SECTIONS explain the physical database structures of an ORACLE database, including datafiles, redo log files, and CONTROL files.
Datafiles
Every Oracle database has one or more physical datafiles. A database’s datafiles CONTAIN all the database data. The data of logical database structures such as tables and INDEXES is physically stored in the datafiles allocated for a database.
Redo Log Files
Every Oracle database has a set of two or more redo log files. The set of redo log files for a database is collectively known as the database’s redo log. A redo log is made up of redo entries (also called redo records), each of which is a group of change vectors describing a single atomic change to the database.
Control Files
Every Oracle database has a control file. A control file contains entries that specify the physical structure of the database. The following sections explain the physical database structures of an Oracle database, including datafiles, redo log files, and control files. Datafiles
Every Oracle database has one or more physical datafiles. A database’s datafiles contain all the database data. The data of logical database structures such as tables and indexes is physically stored in the datafiles allocated for a database. Redo Log Files
Every Oracle database has a set of two or more redo log files. The set of redo log files for a database is collectively known as the database’s redo log. A redo log is made up of redo entries (also called redo records), each of which is a group of change vectors describing a single atomic change to the database. Control Files
Every Oracle database has a control file. A control file contains entries that specify the physical structure of the database.
|
