Object documentationDirectory 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

  • bin/ contains binaries such as oracle, sqlplus, expdp, impdp

    rwsr-s--x ora<dbsid> dba oracle

SAP Home Directory

For the files starting log_, g means 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

    • undo_1/undo.data1: Example of a SAP data file for tablespace PSAPUNDO

    • ...

  • sapdata2/

    • cntrl/cntrl<DBSID>.dbf: Database control file

    • system_2/system.data2

    • sr3_1/sr3.data1 Example of a SAP data file for tablespace PSAPSR3

    • ...

  • 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 tape stations

    • <encoded timestamp>.ssd: Parallel saved on two tape 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

    • <encoded timestamp>.vra: Offline redo log file verification with RMAN

    • <encoded timestamp>.aab: Abort archiving with brarchive -g|-abort

  • 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), v, (util_vol), 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

      • xyz = bab: Abort backup with brbackup -g|-abort

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

      • xyz = rsb : Restore backup files

      • xyz = rsa: Restore archive files

      • xyz = rsf: Restore individual files

      • xyz = qur: Query which tapes to be used

      • xyz = rab: Abort restore with brrestore -g|-abort

    • <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 logs

  • sapcheck\

  • 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

    • diag/rdbms/<dbname>/<DBSID>: Oracle 11g traces

  • oraarch/: Oracle offline redo log files

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

  • brarchive

  • brbackup

  • brconnect

  • brrecover

  • brrestore

  • brspace

  • brtools

More Information

Directory Structure (Windows)