Directory Structure (UNIX)

Definition

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

Use

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

 

See also:

Directory Structure (Windows)