VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Appendix A, VERITAS Storage Foundation for Oracle Command Line Interface
Prerelease 8 September 2005, 8:55am Examples of Using the Command Line Interface
485
▼
To print a message
Use the edgetmsg2 command as follows:
$ /opt/VRTSdbed/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/VRTSdbed/bin/edgetmsg2 -o list[,suppress_time] \
-S ORACLE_SID | [-f logfile] \
[-v severity] [
-t from_time,to_time]
Output similar to the following is displayed:
$ edgetmsg2 -o list -S t10 -t "2004-10-14 13:44:45,2004-10-14 14:46:31"
2004-10-14 13:44:45 SFORA vxsnapadm ERROR V-81-5542 Snapback datavol failed.2004-10-14
13:44:45 SFORA vxsnapadm ERROR V-81-5542 Snapback archvol failed.
2004-10-14 13:44:45 SFORA dbed_vmsnap ERROR V-81-5617 snapback failed.
2004-10-14 13:56:46 SFORA dbed_vmsnap ERROR V-81-5255 sp2 does not exist.
2004-10-14 14:46:16 SFORA dbed_vmclonedb ERROR V-81-4833 There already appears to be a database
T1 running.
2004-10-14 14:46:31 SFORA dbed_vmclonedb ERROR V-81-5713 The database name exceeds the maximum
length of 8 characters.
▼ To list available log files
Use the edgetmsg2 command as follows:
$ /opt/VRTSdbed/bin/edgetmsg2 -o report[,no_archive] \
[-f log_directory]
Output similar to the following is displayed:
dbid begin end size(K) file
---- ----- --- ---- ----
default 2004-10-25 09:50:17 2004-10-25 11:04:00 0 /etc/vx/vxdba/logs/sfua_default.log
t10 2004-09-09 08:54:59 2004-10-21 14:19:35 10 /etc/vx/vxdba/logs/sfua_t10.log
clone2 2004-10-11 09:22:35 2004-10-11 09:22:35 0 /etc/vx/vxdba/logs/sfua_clone2.log
T1 2004-10-14 14:51:33 2004-10-14 14:51:33 0 /etc/vx/vxdba/logs/sfua_T1.log
Tiff1 2004-10-21 14:24:27 2004-10-21 14:24:27 0 /etc/vx/vxdba/logs/sfua_Tiff1.log
clone 2004-08-05 09:23:19 2004-10-21 17:45:19 11 /etc/vx/vxdba/logs/sfua_clone.log
Displaying I/O Mapping and Statistics Using vxstorage_stats
You can use the VERITAS Storage Foundation for Oracle vxstorage_stats command to
display I/O mapping and statistics about VERITAS File System files one file at a time. The
statistics are recorded only for VxFS files and VxVM volumes. These statistics show I/O activity.