Directory Structure (Windows NT) (SAP Library - SAP Database Guide: Oracle (BC-DB-ORA-DBA))

Directory Structure (Windows NT)

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_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\

init<DBSID>.ora Profile for Oracle

init<DBSID>.dba Profile for SAPDBA

init<DBSID>.sap Profile for BRBACKUP, BRARCHIVE, and BRRESTORE

cntrl<DBSID>.dbf Control file

rdbms\

bin\

Contains binaries such as svrmgrl , sqlplus , exp , imp , and so on

SAP Home Directory

For the files starting log_ , g means 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\

system_1\system.data1

btabd_1\btabd.data1 Example of a SAP data file for tablespace PSAPBTABD

...

sapdata2\

btabi_1\btabi.data1 Example of a SAP data file for tablespace PSAPBTABI

sapdata<n>\

sapreorg\

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<SID>.log Structure log

reorg<SID>.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

exp<TSP>.dmp Export dump file

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

sapcheck\

conn<DBSID>.log BRCONNECT summary log

BRCONNECT detail logs:

<coded timestamp>.chk Log of –check function

<coded timestamp>.nxt Log of -next function

<coded timestamp>.aly Log of -analyze function

<coded timestamp>.opt Log of –checkopt function

<coded timestamp>.sta Log of -statistics function

<coded timestamp>.cln Log of -cleanup function

For more information, see SAPDBA Log Files and Their Contents.

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 Q uery 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

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>.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

saptrace\

background\

alert_<DBSID>.log Oracle Alert file

*.trc Oracle trace files

usertrace\

*.trc User trace files

Executables in Directory <drive>:\orant

sapdba

brbackup

brarchive

brconnect

brrestore

brtools

compress

uncompress

cpio