Oracle 10g database file directory structure

After Oracle 10g installation is complete, its directory structure differs greatly from that of oracle9i. The main structure of the Oracle Database 10g and Oracle9i file directories is shown in the following illustration. The ora92 in the Oracle9i file directory structure is replaced with db_1 in the Oracle Database 10g file directory.

In Oracle Database 10g, Oracle's directory structure is made up of oracle_base and its subdirectories oracle_home, admin, Flash_recovery_area, and Oradata directories. To facilitate discussion, use Oracle_base to represent the root of the Oracle directory tree, with oracle_home representing the home directory under the root directory.

1.oracle_base Directory
Oracle_base represents the root of an Oracle directory tree. If the Oracle Universal Installer is used for installation, then oracle_base refers to system_drive:/oracle/product/10.2.0.

2.oracle_home Directory
The Oracle_home home directory is located under System_drive:/oracle_base, which contains subdirectories and network files related to the operation of Oracle software, and selected components, and so on, and if the Oracle database is installed for the first time on the host, If there are no other Oracle products, the default home directory/db_1 is used, and if multiple products are installed or 2nd times installed under the same root directory of the same host, the Oracle_home home directory will appear as Db_n, db_2, Db_3, and so on. This is why the Oracle_base directory can have multiple oracle_home directories.
The primary subdirectories included in the Oracle_home directory are:
/bin--mainly includes various commands for database management.
/css--files related to Oracle Cluster Synchronization Services.
/dbs--holds the database server-side parameter file SPFile.
/demo--A script that holds the database instance schema.
/install--is used to store the port number after Oracle installation, Isql*plus and how Enterprise Manager Database control starts and logs on.
/network/admin--about listeners Listener.ora and Sqlnet.ora as well as Tnsnames.ora.
/sysman/config--is used for port management related to Oracle Enterprise management.

3.admin Directory
The database management files are stored in the Oracle_base/admin/db_name directory. The main meanings of each subdirectory are as follows:
/bdump--Background Process trace file.
/cdump--Information dump file (core dump).
/create--The database to create a file.
/exp--Database Export file.
/pfile--initializes the parameter file.
/udump--User SQL Trace file.

4.Oradata Directory
The database file is stored in the Oracle_base/oradata/db_name directory, which mainly stores the control files, data files, and redo log files of the database. Where the *.dbf file corresponds to each table space in the database; the. ctl file is the control file; the. log file corresponds to the Redo logfile group and its members.

5.flash_recovery_area Directory
The Flash_recovery_area directory stores and manages files related to backup and recovery. It contains subdirectories of each database in the system. This directory can be used to store files related to recovery, such as control files, online redo log copies, archive logs, flashback logs, and Oracle Database Recovery Manager (RMAN) backups.