Show TOC

Object documentationDirectory Structure (Windows) Locate this document in the navigation structure

 

This section describes the directory structure for the Oracle database with the Windows 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_DBSID%

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

  • %SAPDATA_HOME% for SAP-specific objects with the default directory :\oracle\<DBSID>

  • Executables with the directory x:\usr\sap\<DBSID>\SYS\exe\run

Oracle Home Directory

This directory contains the following subdirectories:

  • database\

    • spfile<DBISD>.ora: Oracle spfile

    • init<DBSID>.ora: Profile for Oracle

    • init<DBSID>.sap:: Profile for BR*Tools

    • cntrl<DBSID>.dbf: Control file

  • bin\

    Contains binaries such as sqlplus, exp, imp, and so on

SAP Home Directory

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

  • origlogA\

    • log_tg101m1.dbf

    • log_tg103m1.dbf

  • origlogB\

    • log_tg102m1.dbf

    • log_tg104m1.dbf

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

  • mirrlogA\

    • log_tg101m2.dbf

    • log_tg103m2.dbf

  • mirrlogB\

    • log_tg102m2.dbf

    • log_tg104m2.dbf

  • sapdata1\

    • cntrl\cntrl<DBSID>.dbf: Control file

    • system_1\system.data1: SYSTEM tablespace file

    • btabd_1\btabd.data1: Example of a SAP data file for tablespace PSAPBTABD

    • ...

  • sapdata2\

    • cntrl\cntrl<DBSID>.dbf: Control file

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

    • <coded timestamp>.sve: Original saved

    • <coded timestamp>.svdOriginal saved and deleted

    • <coded timestamp>.cpy: Original copied

    • <coded timestamp>.cpd: Original copied and deleted

    • <coded timestamp>.dsv: Deleted, were saved once

    • <coded timestamp>.dcp: Deleted, were saved twice

    • <coded timestamp>.ssv: Parallel saved on two stations

    • <coded timestamp>.ssd: Parallel saved on two stations and deleted

    • <coded timestamp>.cps: Copy and save

    • <coded timestamp>.cds: Copy, delete and save

    • <coded timestamp>.qua: Query which tapes to be used

    • <coded timestamp>.cma: Determination of software compression rate

    • <coded timestamp>.tia: Tape initialization

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

    • rest<DBSID>.log: BRRESTORE summary log

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

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

    • <coded timestamp>\: Disk backups

      Copies of database files

    • <DBSID>

      • spfile<DBSID>.ora

      • init<DBSID>.ora

      • init<DBSID>.sap

      • back<DBSID>.log: Summary log

      • <coded timestamp).xyz: Detail log

    • BRRECOVER log files

  • 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

  • oraarch: Oracle offline redo log files

Executables in Directory <drive>:\usr\sap\<SAPSID>\SYS\exe\run
  • brarchive.exe

  • brbackup.exe

  • brconnect.exe

  • brrecover.exe

  • brrestore.exe

  • brspace.exe

  • brtools.exe

  • mkszip.exe

  • uncompress.exe

  • cpio.exe

  • mt.exe

  • dd.exe