This section describes the directory structure for the Oracle database with the UNIX 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_SID |
<TSP> |
Tablespace short name For example, BTABD for the tablespace PSAPBTABD. |
There are the following main structures:
$ORACLE_HOME for Oracle-specific objects with the default directory /oracle/<DBSID>/<Oracle version>
$SAPDATA_HOME for SAP-specific objects with the default directory /oracle/<DBSID>
Executables with the directory /usr/sap/<SAPSID>/SYS/exe/run
This directory contains the following subdirectories:
dbs/
spfile<DBSID>.ora: Oracle spfile
init<DBSID>.ora: Profile for Oracle
init<DBSID>.sap: Profile for BR*Tools
cntrl<DBSID>.dbf: Database control file
bin/ contains binaries such as oracle, sqlplus, exp, imp
rwsr-xr-x ora<dbsid> dba oracle
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: Database control file
system_1/system.data1: First SYSTEM tablespace file
btabd_1/btabd.data1: Example of a SAP data file for tablespace PSAPBTABD
...
sapdata2/
cntrl/cntrl<DBSID>.dbf: Database control file
system_2/system.data2
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:
<encoded timestamp>.sve: Original saved
<encoded timestamp>.svd: Original saved and deleted
<encoded timestamp>.cpy: Original copied
<encoded timestamp>.cpd: Original copied and deleted
<encoded timestamp>.dsv: Deleted, were saved once
<encoded timestamp>.dcp: Deleted, were saved twice
<encoded timestamp>.ssv: Parallel saved on two stations
<encoded timestamp>.ssd: Parallel saved on two stations and deleted
<encoded timestamp>.cps: Copy and save
<encoded timestamp>.cds: Copy, delete and save
<encoded timestamp>.qua: Query which tapes to be used
<encoded timestamp>.cma: Determination of software compression rate
<encoded timestamp>.tia: Tape initialization
<encoded 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
<encoded 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
<encoded 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
<encoded timestamp>/: Disk backups
Copies of database files
<DBSID>/: Copies of profiles and log files
spfile<DBSID>.ora
init<DBSID>.ora
init<DBSID>.sap
back<DBSID>.log Summary log
<encoded timestamp).xyz: Detail log
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 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
brarchive
brbackup
brconnect
brrecover
brrestore
brspace
brtools