Central Log reorg<DBSID>.log (SAP Library - Database Administration (Oracle) with SAPDBA)

Central Log reorg<DBSID>.log

Use

A central log, reorg<DBSID>.log , contains information on important 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 can help you to plan your reorganizations more efficiently, for example.

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 (see Extent Check Functions). However, detail logs are also written ( <timestamp>.rch ) and you can display the latest analysis by using the check functions of the reorganization menu (for example, Reorganization ® Check extents and fragmentation ® Estimate/Compute table ® Get last analysis).

Features

reorg<DBSID>.log contains the following information:

BEGIN
<timestamp> of the form YYMMDDHHMM
Time process started

END
<timestamp> of the form YYMMDDHHMM
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

LOG_TIME
<timestamp> of the form YYMMDDHHMM
Logging time

M
Mode of action
Possible values: N (ormal), B (atch), R (estart)
The operation was performed in normal mode ( N ) or in the background ( B ) or started or restarted at a later time ( R ).

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

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

SIZE_B
<n> (in KB)
Size of the object before the start of the operation; it 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; it 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; it 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.

Integration

For more information, see Connection to CCMS.