ORACLE Directory Structure (Windows)

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 mirrlogAand 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/
  • <encoded timestamp>.sta: log of brconnect -f stats
  • <encoded timestamp>.chk: log of brconnect -f check
  • <encoded timestamp>.nxt: log of brconnect -f next
  • <encoded timestamp>.cln: log of brconnect -f cleanup
• 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