The following table shows all the SAPDBA log files and what they contain
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 |
<timestamp>.rsi |
Log of function: reorganize a 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 |
<timestamp>.rtd |
Log of function: reorganize a tablespace with data files |
<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 |
<timestamp>.exg |
Log of function: export other objects |
<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 |
<timestamp>.nxt |
Log generated by using the SAPDBA command option |
<timestamp>.aly |
Log generated by using the SAPDBA command option |
<timestamp>.opt |
Log generated by using the SAPDBA command option |
<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 |
BRTOOLS logs (n=1,...,number of processes). Unlike the export, import logs, these are not appended to the main log <timestamp>.<ext> but are generated separately in the subdirectory <timestamp> of the working directory. |
exp|imp<TSP> |
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 Logs for Parallel Export and Import Processes. |
reorg<DBSID>.log |
Central log with overview information on the operations performed. See Central Log reorg<DBSID>.log. |
struct<DBSID>.log |
Structure log containing information on the structure of the database. See Structure Log. |