Object documentationDirectory Structure (Windows)

 

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:

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

End of the note.

More Information

Directory Structure (UNIX)