Managing log files using edgetmsg2


Managing log files using edgetmsg2
Prev	Appendix B. Storage Foundation for Databases (SFDB) tools command line interface	Next

You can use the edgetmsg2 utility to manage message log files. You can use the edgetmsg2 utility to write a message to a log file or to the console, read the log file and print to the console, and display the available log files.

Before managing log files with the edgetmsg2 command, review the following information:

Prerequisites	You must be logged in as the Database Administrator or root to use this command.
Usage notes	The default log file for a database is located in the following directory: /etc/vx/vxdbed/logs/sfua_database.log where database is the ORACLE_SID. By default, only messages with a severity equal to or greater than ERROR will be logged. See the edgetmsg2(1M) manual page for more information.

Table: edgetmsg2 options lists options for edgetmsg2.

Table: edgetmsg2 options

Option	Description
-s set_num	Specifies the message catalogue set number. The default is 1.
-M msgid[:severity]	Specifies the message ID and severity to be printed.
-f msg_catalog \| logfile \| log_directory	Specifies the message catalogue path, log file, or log directory.
-v severity \| severity	Overwrites the minimum log severity or creates a severity filter. The severity values are either 0-8 or 100-108.
-p	Pauses the cursor at the end of a display message. By default, a line feed is added to each display message. Use the -p option to indicate that no line feed is to be added.
-o list [,suppress_time]	Displays the content of a log file. You can specify ,suppress_time to exclude time information in the utility output.
-o report[,no_archive]	Displays the available log files. You can specify ,no_archive to exclude log files from the utility output.
-t from_time[,to_time]	Reduces the length of the utility output by specifying the time range to include. This option must be used together with the -o list option. Use the following format: yyy-mm-dd HH:MM:SS.
-S ORACLE_SID	Specifies the ORACLE_SID for an Oracle database.
"default format string"	Specifies the C language printf() format string.
[args]	Specifies arguments for the format string conversion characters.

To print a message

Use the edgetmsg2 command as follows:

$ /opt/VRTS/bin/edgetmsg2 [-s set_num] \

[-M msgid[:severity]] \ 
[-f msg_catalog] [-v severity] [-p] [-m value] \ 
["default format string" [args]]

To read a message log file

Use the edgetmsg2 command as follows:

$ /opt/VRTS/bin/edgetmsg2 -o list[,suppress_time] \ 
-S ORACLE_SID | [-f logfile] \ 
[-v severity] [-t from_time,to_time]

To list available log files

Use the edgetmsg2 command as follows:

$ /opt/VRTS/bin/edgetmsg2 -o report[,no_archive] \ 
[-f log_directory]

Prev	Up	Next
Creating or shutting down a clone database using dbed_vmclonedb	Home	Identifying VxFS files to convert to Quick I/O using qio_getdbfiles