What are Database storage Architecture files in Oracle?

     1.      Control file

-         Contains the data about the database it self

-         Physical structure of the database and other metadata about the database

-         Without this the data files are unable to open

     2.      Data Files

-         Contains the data related to the user or application data

-         Contains data dictionary and other metadata

     3.      Online Redo Log file

-         Useful to recover the database in case of any crash or other issues

-         It will be used to recover when the data files are not lost and able to access

     4.      Password Files

-         Allows users having sysasm, sysdba, sysoper to connect to the database instance remotely and perform administrative tasks

     5.      Parameter File

-         It contains the information about how the instance was configured when it is started

     6.      Archived redo log file

-         Contains series history of the data changes (Redo)  and useful to recover the data lost when we have the backup of the dB and these redo log files

     7.      Backup File

-         Is used to recover a database when an user accidentally deletes the dB or caused any damage to the database

     8.      Alert Log file and Trace files

-         Alert logs are special type of the trace files that logs each informational and error messages and Oracle recommends to review these logs periodically

-         Trace files are used trace out the process errors and are written by the server and BG processes when an error is occurred and the information about the error is written to these trace files and these intended to the DBA and other Oracle support team.