What are the components of physical database structure of Oracle database?

What are the components of physical database structure of Oracle database?

Physical components of oracle database are: 
> Control files,
> Redo log files and
> Data files.

> Control file : control file is basically 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 physical files which stores data of all logical structure.

By:UMANG
Date:2009-01-09 00:00:00

Post Your Answers


User Email:

User Name:
Answers:

Related SQL Subjective Links

SQL Subjective interview questions and answers for experienced and fresher