Structure Log
SAPDBA continuously writes data to the log
struct<DBSID>.log , including details of the files belonging to the database and whether they were deleted or created. You can find the following information there:|
Explanation | |
S/D/C |
S: File recognized by SAPDBA as belonging to the database. |
Time stamp |
When the log entry was made. |
Tablespace |
Name of the tablespace to which the file belongs |
ID Filename |
ORACLE file ID Full path of this file |
Size Size |
File size (ORACLE) File size (operating system) |
Path Path |
If a link exists for this file, this is where it is logged. First is the ORACLE name or partial name of the file, and then the point to which for this file has been set. This could be a link to a file or a link to a raw device. SAPDBA uses these entries to monitor the link structure of the database and to correct it where necessary (Database Check). |
This information should help you keep as accurate an overview of the structure of the database as possible. For example, you can compare the ORACLE and operating system file sizes, you can discover the allocation of tablespaces to files and you can find out whether the "files" are really files or raw devices. If the log does not exist, then it will be created the next time that SAPDBA is started. This means that you can generate an up-to-date structure log at any time, for example if the old one has become too confusing.