Log file

Contents

<timestamp>.dba

Database startup and shutdown messages, deletion of logs, trace, and audit files, log of functions: restoring one tablespace (Restore/Recovery ® Restore one tablespace) or restoring individual files (Restore/Recovery ® Restore individual file(s))

<timestamp>.rch

Log of the check function (in submenus of Reorganization ® Check extents and fragmentation)

<timestamp>.ral

Log of function: configuration of storage parameters
(Reorganization ® Alter/Show table or index storage parameters)

<timestamp>.rsi

Log of function: reorganize a single table or index
(Reorganization ® Reorganize single table or index)

<timestamp>.rli

Log of function: Reorganize a list of objects (Reorganization ® Reorganize list of tables or indexes)

<timestamp>.rtc

Log of function: Reorganization of a tablespace
(Reorganization ® Reorganize tablespace)

<timestamp>.rtd

Log of function: reorganize a tablespace with data files
(Reorganization ® Reorganize tablespace and datafiles)

<timestamp>.rmv

Log of function: change the data file assignment of a tablespace (Reorganization ® Move/rename data files of a tablespace)

<timestamp>.rrs

Log of function: Resize data file (Reorganization ® Resize data files of a tablespace)

<timestamp>.ext

Log of function: tablespace administration, including the data file statistics before and after the extension, and the messages displayed by the command ALTER TABLESPACE or CREATE TABLESPACE (Tablespace administration)

<timestamp>.exd

Log of function: export with data (Export/import ® Export tables and indexes including data)

<timestamp>.exs

Log of function: export tables and index structures
(Export/import ® Export structures of tables and indexes)

<timestamp>.exg

Log of function: export other objects
(Export/import ® Export constraints, synonyms, sequences, views, grants)

<timestamp>.imd

Log of function: import with data (Export/import ® Import tables and indexes including data)

<timestamp>.ims

Log of function: structure import (Export/import ® Import structures)

<timestamp>.chk

Statistics generated by using the SAPDBA command option
-check (e.g. display using SAPDBA daily check log files)

<timestamp>.nxt

Log generated by using the SAPDBA command option
-next (e.g. display using SAPDBA daily check log files)

<timestamp>.aly

Log generated by using the SAPDBA command option
-analyze (e.g. display using SAPDBA daily check log files)

<timestamp>.opt

Log generated by using the SAPDBA command option
-checkopt (requirements planning for the DB optimizer).

<timestamp>.brb

Log of the BRBACKUP call by SAPDBA (Backup database)

<timestamp>.bra

Log of the BRARCHIVE call by SAPDBA (Backup archive log)

<timestamp>.rcv

Log of function: recovery (Check (and repair) Database)

<timestamp>.rsn

Log of function: recovery to current time (now) (Restore/Recovery ® Full restore and recovery)

<timestamp>.rsp

Log of function: point in time recovery (Restore/Recovery ® Full restore and recovery)

<timestamp>.rst

Log of function: restore the database (Restore/Recovery ® Full restore)

esc<TSP>.log
esc<TSP>_<n>.log

R3chop logs (n=1,...,number of processes). Unlike the export, import, unload, load logs, these are not appended to the main log <timestamp>.<ext> but are generated separately in the subdirectory <timestamp> of the working directory.

ldr|exp|imp<TSP>
_<n>.log

Depending on the number of parallel processes, from the second ORACLE Export/Import process onwards (n=2,...,number of processes) partial, temporary logs are written (see Logging of Parallel Export/Import Processes and SAP Unload/Load, SQL*Loader).

ldr<TSP> <n>.log

Temporary logs if the Export/Import tools SAP unload/SAP load or SAP unload/SQL*Loader are used for test purposes. (See SAP Unload/Load, SQL*Loader).

reorg<DBSID>.log

Main log with overview information on the operations performed (see Main Log)

struct<DBSID>.log

Structure log containing information on the structure of the database (see Structure Log).