Directory Structure (UNIX)
Definition
This section describes the directory structure for the Oracle database with the UNIX 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_SID |
<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>/<Oracle version>
· $SAPDATA_HOME for SAP-specific objects with the default directory /oracle/<DBSID>
· Executables with the directory /usr/sap/<SAPSID>/SYS/exe/run
Oracle Home Directory
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
SAP Home Directory
For the files starting log_, gmeans 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
· 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), 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
¡ <encoded timestamp>.xyz BRRESTORE detail log, where:
§ xyz = rsb Restore backup files
§ xyz = rsa Restore archive files
§ xyz = rsf Restore individual files
¡ <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
Executables in Directory /usr/sap/<SAPSID>/SYS/exe/run
· brarchive
· brbackup
· brconnect
· brrecover
· brrestore
· brspace
· brtools
See also: