Show TOC

Directory Structure (UNIX)Locate this document in the navigation structure

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

  • 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