SAPDBA Support for Raw Device Configuration (SAP Library - Database Administration (Oracle) with SAPDBA)

SAPDBA Support for Raw Device Configuration

The following information is important for you if you intend to use SAPDBA for ORACLE database administration on raw devices:

The data for a tablespace can be stored either in raw devices or in files. Be sure to observe the SAP naming convention for tablespaces on raw devices:

<ORACLE_HOME>/sapraw/<TSP>_<Number> ® <Raw-Device-Dir>/<Device>

<Number> : Sequence number assigned to the raw devices (or files) belonging to the tablespace

<Raw-Device-Dir> : Specifies the central directory containing the devices. This directory may also be specified in the rawdev_dir parameter.

See also Environment Variables.

Each tablespace "file" (held on a raw device) visible to ORACLE is a symbolic link to a raw device. SAPDBA checks that the naming convention has been observed.

Tablespace PSAPDOCUD

/oracle/C11/sapraw/docud_1 ® /dev/rdsk/C11docud_1

You should also compare this with the Naming Convention for tablespaces in the file system.

The database link structure is one of things recorded in the structure log struct<DBSID>.log .

If the database check is done using SAPDBA, SAPDBA uses this structure log to check whether the link structure is still complete and immediately repairs it if not. If a tablespace is extended, a new tablespace is created or a tablespace is reorganized with data files then SAPDBA updates the structure log. See Structure Log.

Each raw device can contain only one tablespace "file" (requirement of ORACLE). SAPDBA can set the size of this partition. Therefore, in the case of tablespace extension (adding a "file" from a raw device), for example, the size of the raw device is determined automatically and is used for the size of the file. See Extending a Tablespace.

It may be a good idea to specify the rawdev_dir and blkdev_dir parameters in the init<DBSID>.dba profile.