Tuesday, July 31, 2012

Oracle Database


Oracle database: An Oracle database consists of files. 
·        Sometimes these are referred to as operating system files, but they are actually database files that store the database information that a firm or organization needs in order to operate. 
·        The redo log files are used to recover the database in the event of application program failures, instance failures and other minor failures.
·        The archived redo log files are used to recover the database if a disk fails. 
·        Other files not shown in the figure include:
o   The required parameter file that is used to specify parameters for configuring an Oracle instance when it starts up. 
o   The optional password file authenticates special users of the database – these are termed privileged users and include database administrators. 
o   Alert and Trace Log Files – these files store information about errors and actions taken that affect the configuration of the database.

No comments:

Post a Comment