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.exesqlplus.exeexpdp.exeimpdp.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
  • sapcheck/
  • sapreorg\
    • 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

0 comments:

Copyright © 2013 VENKAT SAP BASIS