Structure Log
Definition
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.Use
This information helps you keep an accurate overview of the structure of the database. 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 is 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.
Structure
Entry |
Explanation |
S/D/C |
S : File recognized by SAPDBA as belonging to the databaseD : File was deleted C : File was created |
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). |