Forum

Number Of Page View:100,000+/Months
LOGIN |New User

Reply

What are the components of physical database structure of Oracle database?
Physical components of oracle database are: 
> Control files,
> Redo log files and 
> Datafiles.

> Control file : control file is basicaly a type of file .Its read in the mount state of database. control file is a small binary file which records the physical structure of database which includes
* Database name
* names and locations of datafiles and online
redo log files.
* timestamp of database creation
* check point information
* current log sequence number.

Redo log files : Redo log files usually use for the saving to the files. This files saves all the changes that are made to the database as they occur. This plays a great role in the database recovery.

Datafiles : Datafiles are the physicalfiles which stores data of all logical structure.