Oracle Database Files

Oracle database consists of 3-types of files

1.Controlfile:

Controlfile acts as a driver of the database. consists of critical database information like below 

• Database name
• When it got created 
• How many tablespaces
• Datafile details
• Backup information 
• System change number(SCN)
• It also contains check point number used to recover the database

2. Redologfile:

Redolog file contains latest transaction details

3. Database files:

Database files contains original data like tables,indexes