Components of Physical Databse Structure

In Oracle Database, what are the components of its physical database structure?

There are 6 files(components) of physical database structure.

Out of 6, 3 are mandatory and the other 3 are optional.

Three mandatory files are :

1. [B]Data file[/B] : store actual data
2. [B]Control file[/B] : strores stuctural & status information of database.
3. [B]Redolog file[/B] : stores changed/committed data

Three optional files are :

4. [B]Parameter file[/B] : strores all size related parameters note : this file is mandatory whne you create a database for the first titme , then it is optional.

5 . [B]Archivelog file[/B] : its offline copy of redolog

6. [B]Password file[/B] : used to make normal user to behave as a super user.

Hope this helps....

Thanks,
Suji

This topic is interesting but could you let me know what the difference between Redolog file and Archivelog file is. I assume that both have copy of the same data. Is that there is any difference in the storage structure