Oracle Database Directory Structure (UNIX)

This section describes the directory structure for the Oracle database with the UNIX operating system.

The directories contain a range of files such as profiles, log files, scripts, executables, and so on.

The following conventions apply to this section:

Term	Meaning
$<name>	Environment variable
<DBSID>	$ORACLE_SID
<TSP>	Tablespace short name For example, BTABD for the tablespace PSAPBTABD.

Structure

There are the following main structures:

·        $ORACLE_HOME for Oracle-specific objects with the default directory /oracle/<DBSID>/<Oracle version>

·        $SAPDATA_HOME for SAP-specific objects with the default directory /oracle/<DBSID>

·        Executables with the directory /usr/sap/<SAPSID>/SYS/exe/run

Oracle Home Directory

This directory contains the following subdirectories:

·        dbs/

¡        spfile<DBSID>.ora Oracle spfile

¡        init<DBSID>.ora Profile for Oracle

¡        init<DBSID>.sap Profile for BR*Tools

¡        cntrl<DBSID>.dbf Database control file

·        bin/ contains binaries such as oracle, sqlplus, exp, imp

rwsr-xr-x ora<dbsid> dba oracle

SAP Home Directory

For the files starting log_, gmeans group and m means member:

·        origlogA/

¡        log_g11m1.dbf

¡        log_g13m1.dbf

·        origlogB/

¡        log_g12m1.dbf

¡        log_g14m1.dbf

Mirrored redo logs are optional – although we strongly recommend using them – so the specification for mirrlogA and mirrlogB might vary:

·        mirrlogA/

¡        log_g11m2.dbf

¡        log_g13m2.dbf

·        mirrlogB/

¡        log_g12m2.dbf

¡        log_g14m2.dbf

·        sapdata1/

¡        cntrl/cntrl<DBSID>.dbf Database control file

¡        system_1/system.data1 First SYSTEM tablespace file

¡        btabd_1/btabd.data1 Example of a SAP data file for tablespace PSAPBTABD

¡        ...

·        sapdata2/

¡        cntrl/cntrl<DBSID>.dbf Database control file

¡        system_2/system.data2

¡        btabi_1/btabi.data1 Example of a SAP data file for tablespace PSAPBTABI

¡        ...

·        sapdata<n>/

·        saparch/

¡        arch<DBSID>.log BRARCHIVE summary log

BRARCHIVE detail logs:

¡        <encoded timestamp>.sve Original saved

¡        <encoded timestamp>.svd Original saved and deleted

¡        <encoded timestamp>.cpy Original copied

¡        <encoded timestamp>.cpd Original copied and deleted

¡        <encoded timestamp>.dsv Deleted, were saved once

¡        <encoded timestamp>.dcp Deleted, were saved twice

¡        <encoded timestamp>.ssv Parallel saved on two stations

¡        <encoded timestamp>.ssd Parallel saved on two stations and deleted

¡        <encoded timestamp>.cps Copy and save

¡        <encoded timestamp>.cds Copy, delete and save

¡        <encoded timestamp>.qua Query which tapes to be used

¡        <encoded timestamp>.cma Determination of software compression rate

¡        <encoded timestamp>.tia Tape initialization

¡        <encoded timestamp>.fst Stop archiving using brarchive –f stop

·        sapbackup/

¡        back<DBSID>.log BRBACKUP summary log

¡        <encoded timestamp>.xyz BRBACKUP detail log, where:

§         x = a (whole, previously all), p (partial) , f (full) , i (incremental)

§         y = n (online) or f (offline)

§         z = t (tape), p (pipe), d (disk), f(util_file), r (RMAN), s (remote disk, stage),

§         xyz = qub Query for which tapes are to be used

§         xyz = cmb Determination of software compression rate

§         xyz = tib Tape initialization

§         xyz = rmp RMAN preparation run

§         xyz = dbv Database verification with DBVERIFY

§         xyz = ddb Delete of disk backup

¡        <encoded timestamp>.xyz BRRESTORE detail log, where:

§         xyz = rsb Restore backup files

§         xyz = rsa Restore archive files

§         xyz = rsf Restore individual files

¡        <encoded timestamp>/ Disk backups

Copies of database files

¡        <DBSID>/ Copies of profiles and log files

§         spfile<DBSID>.ora

§         init<DBSID>.ora

§         init<DBSID>.sap

§         back<DBSID>.log Summary log

§         <encoded timestamp).xyz Detail log

¡        BRRECOVER log files

·        sapcheck/

¡        <encoded timestamp>.sta: log of brconnect –f stats

¡        <encoded timestamp>.chk: log of brconnect –f check

¡        <encoded timestamp>.nxt: log of brconnect –f next

¡        <encoded timestamp>.cln: log of brconnect –f cleanup

·        sapreorg/

¡        BRSPACE logs

¡        BRSPACE writes scripts, parameter files, and restart files as follows to the directory:

§         <encoded datestamp>/ddl.sql: Data Definition Language (DDL) statements for table reorganization

§         <encoded datestamp>.edd/expdat.dmp: export dump file for table export

§         <encoded datestamp>/parfile.exp: parameter file for table export

·        saptrace/

¡        background/

§         alert_<DBSID>.log Oracle Alert file

§         *.trc Oracle trace files

¡        usertrace/

§         *.trc User trace files

·        oraarch/     Oracle offline redo log files

Executables in Directory /usr/sap/<SAPSID>/SYS/exe/run

·        brarchive

·        brbackup

·        brconnect

·        brrecover

·        brrestore

·        brspace

·        brtools