oracle里的一些file

最新推荐文章于 2025-03-12 08:58:07 发布

转载最新推荐文章于 2025-03-12 08:58:07 发布 · 96 阅读

标签

#数据库

收录于

本文介绍了Oracle数据库的基本结构，包括其物理结构组成部分：数据文件、在线重做日志文件及控制文件，并简述了参数文件、密码文件及归档重做日志文件的作用。

Oracle Database

The general purpose of a database is to store and retrieve related information. An Oracle database has a logical and a physical structure. The physical structure of the database is the set of operating system files in the database. An Oracle database consists of three file types.

•1.Data files containing the actual data in the database

•2.Online redo log files containing a record of changes made to the database to enable recovery of the data in case of failures

•3.Control files containing information necessary to maintain and verify database integrity

The Oracle server also uses other files that are not part of the database:

•4.The parameter file defines the characteristics of an Oracle instance. For example, it contains parameters that size some of the memory structures in the SGA.

•5.The password file authenticates users privileged to start up and shut down an Oracle instance.

•6.Archived redo log files are offline copies of the online redo log files that may be necessary to recover from media failures.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10640532/viewspace-591143/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10640532/viewspace-591143/