Database Reference
In-Depth Information
when are talking about physical files like control file, data files
etc., we are actually talking about physical architecture of Oracle
database.
Physical Architecture of Oracle Database
We can look at Oracle Database through two angles viz.,
logically and physically. We will talk about logical architecture
of Oracle Database in the next article. Physical architecture of
Oracle Database is comprised of five different types of files.
Those five files along with their brief description are given
below.
Figure 3-2: Physical Architecture of Oracle database. Oracle database
is composed of mainly three different types of files. Oracle Instance
updates the control file whenever the physical structure of database is
changed by DBA. Data Files holds the actual data and if you keeping
added records to your database tables, the sizes of these data files
increase along with the size of redo Log files. Redo Log files get
utilized in a circular fashion. It is recommended that Oracle should be
run under “Archived Log Mode” so that Redo Log files get copied
before getting overwritten. Redo Log files along with Archived Redo
Log files plays a major role in the database recovery process.
 
Search WWH ::




Custom Search