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>
$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/
Profile for Oracle
init<DBSID>.dba Profile for SAPDBA
init<DBSID>.sap Profile for BRBACKUP, BRARCHIVE, and BRRESTORE
bin/ contains binaries such as oracle, svrmgrl, sqlplus, exp, imp
- rwsr-xr-x ora<dbsid> dba oracle
- rwxr-xr-x ora<dbsid> dba svrmgrl
SAP Home Directory
For the files starting
log_, g means group and m means member:
origlogA/
- log_g11m1.dbf
- log_g13m1.dbf
- log_g11m1.dbf
- log_g13m1.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
- log_g12m2.dbf
- log_g14m2.dbf
Database control file
system_1/system.data1
btabd_1/btabd.data1 Example of a SAP data file for tablespace PSAPBTABD
...
Database control file
system_1/system.data1
btabi_1/btabi.data1 Example of a SAP data file for tablespace PSAPBTABI
...
Logs written by SAPDBA:
<timestamp>.rch Log check option
<timestamp>.ral Alter storage in reorganization menu
<timestamp>.rsi Reorganize a single table or index
<timestamp>.rtc Reorganize tablespace without data file
<timestamp>.rtd Reorganize tablespace with data file
<timestamp>.ext Tablespace extension
<timestamp>.exs Export table and index structures
<timestamp>.exd Export table with data
<timestamp>.exg Export constraints, synonyms, sequences, views, grants
<timestamp>.ims Import structure
<timestamp>.imd Import table with data
<timestamp>.rcv Recovery
<timestamp>.brb Backup start with BRBACKUP
<timestamp>.bra Archive start with BRARCHIVE
<timestamp>.dba Database startup or shutdown
<timestamp>.rmv Change data file assignment of a tablespace
<timestamp>.rli Reorganize a list of objects
<timestamp>.rsn Restore or recovery to current time
<timestamp>.rsp Restore or recovery to point-in-time
<timestamp>.rst Restore or recover the database
struct<DBSID>.log Structure log
reorg<DBSID>.log Main log
For more information on SAPDBA logs, see
SAPDBA Log Files and Their Contents.
SAPDBA writes scripts, parameter files, and restart files as follows to the directory
sapreorg/<datestamp>/:
alt<TSP>.sql Delete index analysis
con<TSP>.sql Create constraints
cssvg.sql Create constraints, grants, synonyms, sequences, and views
dro<TSP>.sql Drop table or tablespace
grants.sql Create grants
ind<TSP>.sql Create indexes
inx<TSP>.sql Test script
swi<TSP>.sql Switch redo log file, backup control file
tsp<TSP>.sql Create tablespace PSAP<TSP>
tab<TSP>.sql Create tables
del<TSP>.sh Delete various objects
exp<TSP>.sh Export tables and data
imp<TSP>.sh Import tables and data
exc<TSP>.sh Compress or split export dump files
imc<TSP>.sh Decompress or merge export dump files for import
exp<TSP>.par Parameter file for export
exc<TSP>.par Parameter file for splitting export dump files
restart.rli Restart for reorganization list
restart.rmv Restart for move or rename
restart.rsi Restart for reorganization of table or index
restart.rtc Restart for reorganization of tablespace
restart.rtd Restart for reorganization of tablespace with data file
restart.exs Restart for export or import of tables and index definitions
restart.exd Restart for export or import of tables with indexes and data
For more information on files with the endings:
sh
or sql, see SAPDBA Scripts and Files
par
see SAPDBA Log Files and Their Contents
rsi
, rli, rtc, rtd, or rmv, see Restart File for Reorganizations
exs
or exd, see Restart File for Export or Import
- <timestamp>.chk Log of sapdba –check
- <timestamp>.nxt Log of sapdba -next
- <timestamp>.aly
Log of sapdba -analyze
- <timestamp>.opt
Log of sapdba –checkopt
- <timestamp>.sta
Log of sapdba –statistics
For more information, see SAPDBA Log Files and Their Contents.
- back<DBSID>.log BRBACKUP 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
- cntrl.dbf
If online backup was performed
- ctrl<DBSID>.dbf
If offline backup was performed
- back<DBSID>.log
Summary log
- init<DBSID>.ora
- init<DBSID>.sap
- <coded timestamp).xyz
Detail log
- saparch/
Offline redo logs or archive logs
- <DBSID>arch<thread_number>_<log seq.number>.dbf
- For example:
C11arch1_4711.dbf (Default is OS-dependent)
- arch<DBSID>.log
BRARCHIVE summary log
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>.dev
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
- alert_<DBSID>.log Oracle Alert file
- *.trc
Oracle trace files
Executables in Directory /usr/sap/<SAPSID>/SYS/exe/run
sapdba
brbackup
brarchive
brconnect
brrestore
brtools
...