Search This Blog

Thursday, February 16, 2012

Oracle Database Directory Structure (UNIX)

This section describes the directory structure for the Oracle database with the Windows 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_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\

¡        spfile<DBISD>.ora Oracle spfile

¡        init<DBSID>.ora Profile for Oracle

¡        init<DBSID>.sap Profile for BR*Tools

¡        cntrl<DBSID>.dbf Control file

·        bin\

Contains binaries such as sqlplusexpimp, and so on


SAP Home Directory

For the files starting log_gmeans 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\

¡        cntrl\cntrl<DBSID>.dbf Control file

¡        system_1\system.data1 SYSTEM tablespace file

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

¡        ...

·        sapdata2\

¡        cntrl\cntrl<DBSID>.dbf Control file

¡        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:

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

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

Copies of database files

¡        <DBSID>

§         spfile<DBSID>.ora

§         init<DBSID>.ora

§         init<DBSID>.sap

§         back<DBSID>.log Summary log

§         <coded timestamp).xyz Detail log

¡        BRRECOVER log files

·        sapcheck/

¡        <encoded timestamp>.chk: 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 logs

¡        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 <drive>:\orant

·        brarchive.exe

·        brbackup.exe

·        brconnect.exe

·        brrecover.exe

·        brrestore.exe

·        brspace.exe

·        brtools.exe

·        mkszip.exe

·        uncompress.exe

·        cpio.exe

·        mt.exe

·        dd.exe

No comments:

Post a Comment