Drive details files primarily contain the following types:
Data and catalog files assignment help
Data and catalog files: Those details files are necessary for the actual shed, which can contain the details dictionary details (associated to the desk place SYSTEM), user details, or catalog details. These details files can be maintained manually or maintained by Oracle itself ("Oracle-managed files"). Be aware that a computer data file has to fit in with exactly one desk place, whereas a desk place can contain several details.
Redo log details files consisting of all changes to the data source, used to recover from an example failing. Be aware that often these details files are saved many times, for extra security in case of hard drive failing. The identical update log details files are said to fit in with the same group.
Undo files assignment help
Undo files: Those unique details, which can only contain fix details, are used for restoration, rollbacks, and read consistency.
Archive log files assignment help
Archive log files: Those details files are copies of the update log details files, but are usually saved at different places. They are necessary for example to be applied to a standby data source, or to perform restoration after an example failing. It is possible to store to several places.
Temp files Assignment help
Tempfiles: Those unique details are used exclusively for temporary shed details (used for example for large sorts)
Control data file, necessary for data source startup. "A binary data file that records the actual structure of a data source and contains the names and places of update log details files, the time stamp of the data source creation, the current log sequence number, checkpoint details, and so on."
At the actual level, details comprise one or more details blocks, where the block size can vary between details.
Data details files can occupy pre-allocated place in the data file system of a computer server, utilize raw hard drive directly, or exist within ASM logical volumes.