In Oracle Database, what are the components of its physical database structure?
Printable View
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