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 |
%$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_, gmeans 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>.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 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
· 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) , 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
¡ <coded timestamp>.xyz BRRESTORE detail log, where:
§ xyz = rsb Restore backup files
§ xyz = rsa Restore archive files
§ xyz = rsf Restore individual files
¡ <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/
¡ <encoded timestamp>.chk: 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 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>:\orant
· brarchive.exe
· brbackup.exe
· brconnect.exe
· brrecover.exe
· brrestore.exe
· brspace.exe
· brtools.exe
· mkszip.exe
· uncompress.exe
· cpio.exe
· mt.exe
· dd.exe
See also: