| Parameters |
|
|
| Name |
Default value |
Description |
| export log name |
export.log |
The name of the export log file. However, if your export script makes a new name for each export log file, you can use the “$” signs to append the date-format to the filename. For example, if the filename is exp_weekly_$(date “+%m%d%y”).log which would become, for 25Th of May 2010, exp_weekly_052510.log, you set the parameters to the following value: exp_weekly_$MMDDYY$.log |
| export log path |
null |
The path name of the export log file which is used to create directory object. |
| export log directory name |
DBW_EXPORT_DIR |
The name of the directory object created with the DDL – “create directory”. Directory object value should be the path to the export.log file. |
| export log error text |
ORA- |
Defines which strings (errors) the Check must look for. Values for this parameter must be separated with commas (,). |
| export log line HWM |
0 |
Each time the Check read the export log, it registers how many rows have been checked. The next time the Check executes, it browses pass the rows already checked. The value of how many rows of the export log have already been checked are registered by this parameter. |
| export log max lines |
200000 |
If the export log has more lines than the value of this parameter, then the Check terminates and returns WARNING status. |
| export log max elapsed time |
60 |
Define the maximum running time the Check can execute (values are in seconds). If the execution time reach the export log max elapsed time value before reaching the end of file, the Check terminates and returns WARNING status. |
| export log error text allowed |
null |
Specifies the error strings which are excluded. |
| export log confirm text |
terminated successfully without warnings |
The Check loop throughout the log file, searching for a confirm text. If the Check do not find at least one of the confirm strings, it returns WARNING status. You can specify more than one confirm string for the Check to look for, the strings should be separated by comma (,). |
| export log date format |
dd-mm-yyyy hh24:mi |
If a value is assigned to the parameter export log date position, you have to specify the date-format by using the Oracle date format (ex. Fri 22:30:04 10-Jan-03 , dd hh24:mi:ss dd-mon-yy). |
| export log date position |
export finished |
If the log-file has a date/time stamp in it, you can have the Check to check how recently the log-file has been created (so you do not read a “good” but old log). To be able to find the date/time stamp in the log-file, you have to specify a unique string which must appear on the same line as the date/time stamp or on the line above. The unique string value must be specified by using this parameter. If no value is assigned to that parameter, the Check do not check the date of the log-file. Otherwise you also have to specify the date-format by using the dbWatch parameter “export log date format”. |
| export log nls lang |
English |
Defines handling of language-specific date-format used by the dbwatch parameter “export log date format”. |
| export log expire time |
24 |
You can specify how old the log-file is allowed to be before the Check returns the WARNING status. In other words, if the log-file is created at 22:00 and the Check which checks the log-file is executed at 06:00 (next morning), the value of the parameter must at least be 8 hours. Otherwise the Check will return WARNING status because the log-file is to “old”. |
Post your comment on this topic.