Central Log reorg<DBSID>.log (SAP Library - SAP Database Guide: Oracle (BC-DB-ORA-DBA))

Central Log reorg<DBSID>.log

Definition

The central log, reorg<DBSID>.log , contains information on important database operations such as creating, extending and reorganizing a tablespace, restarting an operation, and resetting, restoring or recovering a database. Each time one of these operations is performed, it is entered in the log. The time information ( BEGIN or END ) helps you to estimate the amount of time needed for operations on tables or tablespaces. This helps you plan your reorganizations more efficiently.

Use

SAPDBA uses the central log to display the tablespaces where structure changes (reorganization of a tablespace with data files, extension or creation of a tablespace) have been made. This information is particularly important when you are recovering the database, since the recovery depends on any changes that have been made to the structure.

There is no entry in the central log reorg<DBSID>.log for the results of the analysis functions Estimate/compute table/tablespace and Validate index. For more information, see Extent Check Functions. However, SAPDBA instead writes detail logs ( <timestamp>.rch ) and you can display the latest analysis by using the check functions of the SAPDBA reorganization menu (for example, Reorganization ® Check extents and fragmentation ® Estimate/Compute table ® Get last analysis).

Structure

reorg<DBSID>.log contains the following information:

Mode of action

Possible values: N for normal, B for batch, R for restart

The operation was performed in normal mode ( N ) or in the background ( B ) or started or restarted at a later time ( R ).

LOG_TIME

<timestamp> in YYMMDDHHMM format

Logging time

BEGIN

<timestamp> in YYMMDDHHMM format

Time process started

END

<timestamp> in YYMMDDHHMM format

Time process ended

FID

Function ID; also in the extension of the corresponding process log

ext	Extension/creation of a tablespace
rli	Reorganization of a list of objects
rmv	Renaming and moving of data files of a tablespace
rrs	Resizing a data file
rsi	Reorganization of a single table or index
rsn	Restoration of the database and subsequent recovery to the current time (Recovery until now)
rsp	Restoration of the database and subsequent point in time recovery
rst	Resetting the database
rtc	Reorganization of a tablespace without data files
rtd	Reorganization of a tablespace with data files

OBJECT <table name> / <tablespace name>

Name of the table or tablespace on which the operation was performed.

RESET	if the database was reset
RES	if a point in time recovery was performed
REC	if a Recovery until now was performed

SIZE_B <n> (in KB)

Size of the object before the start of the operation. This can be 0 if the tablespace is new, for restart functions, and when resetting, restoring or recovering the database.

SIZE_A <n> (in KB)

Size of the object after reorganization or extension, or the size of the new tablespace. This can be 0 if the tablespace is new, for restart functions, and when resetting, restoring or recovering the database.

SIZE_T <n> (in KB)

Size of the export dump file. This can be 0 if the tablespace is new, for restart functions, and when resetting, restoring or recovering the database, for index reorganization and tablespace extensions.

Return Codes in the Central Log reorg<DBSID>.log

Integration

For more information, see Logging Information in CCMS.