ORACLE 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:
Structure
There are the following main structures:
- %ORACLE_HOME% for Oracle-specific objects with the default directory:<drive>:\oracle\<DBSID>\<Oracle version>
- %SAPDATA_HOME% for SAP-specific objects with the default directory:<drive>:\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
- bin\Contains binaries such as oracle.exe, sqlplus.exe, expdp.exe, impdp.exe, and so on
SAP Home Directory
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 mirrlogAand mirrlogB might vary:
- mirrlogA\
- log_g11m2.dbf
- log_g13m2.dbf
- mirrlogB\
- log_g12m2.dbf
- log_g14m2.dbf
- sapdata1\
- cntrl\cntrl<DBSID>.dbf: Control file
- system_1\system.data1: SYSTEM tablespace file
- undo_1\undo.data1: Example of a SAP data file for tablespace PSAPUNDO
- ...
- sapdata2\
- cntrl\cntrl<DBSID>.dbf: Control file
- sr3_1\sr3.data1: Example of a SAP data file for tablespace PSAPSR3
- 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 tape stations
- <coded timestamp>.ssd: Parallel saved on two tape 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
- <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
- 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), 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
- <coded 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
- <coded timestamp>\: Disk backupsCopies 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>.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
- diag\rdbms\<dbname>\<dbsid>: Oracle 11g traces
- oraarch: Oracle offline redo log files
Executables in Directory <drive>:\usr\sap\<SAPSID>\SYS\exe\run
- brarchive.exe
- brbackup.exe
- brconnect.exe
- brrecover.exe
- brrestore.exe
- brspace.exe
- brtools.exe
- mkszip.exe
- uncompress.exe
- cpio.exe
- mt.exe
- dd.exe
0 comments: