Show TOC

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

Definition

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

    <drive>:\oracle\<DBSID>\<Oracle version>

  • %SAPDATA_HOME% for SAP-specific objects with the default directory:

    <drive>:\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

  • bin\

    Contains binaries such as oracle.exe, sqlplus.exe, expdp.exe, impdp.exe, and so on

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: Control file

    • system_1\system.data1: SYSTEM tablespace file

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

    • ...

  • sapdata2\

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

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

    • <coded timestamp>.sve: Original saved

    • <coded timestamp>.svd Original 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 tape stations

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

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

Note

The software with the following executables from the above list is no longer delivered by SAP:

  • mkszip.exe

  • uncompress.exe

  • cpio.exe

  • mt.exe

  • dd.exe

You can purchase this software from the manufacturer (MKS Inc.).

More Information