Veritas Storage Foundation 5.1 SP1: Storage and Availability Management for Oracle (5900-1504, April 2011)

/var/vx/vxdba/logs/vxsnapadm_50.log
Troubleshooting SmartTier for Oracle
If the SmartTier for Oracle commands fail as in the following example, review the
tsdb_debug.log.
The tsdb_debug.log is located at:
/var/vx/vxdba/logs/tsdb_debug.log
For example, when the following message appears after issuing a dbdst_addvol
command review the tsdb_debug.log:
$ /opt/VRTS/bin/dbdst_addvol -S BLM21 -M /dev/vx/dsk/nobody_data1/ \
data1vol -v new_vol1:fast_storage,new_vol2:slow_storage,new_vol3:slow_storage
SFORA dbdst_addvol ERROR V-81-6222 Could not add volume new_vol1 to vset
The tsdb_debug.log file contains information that resembles the following:
# view /var/vx/vxdba/logs/tsdb_debug.log
1216606 Tue May 13 10:11:05 2008
/opt/VRTS/bin/dbdst_addvol -S BLM21 -M /dev/vx/dsk/nobody_data1/data1vol -v
new _vol1:fast_storage,new_vol2:slow_storage,
new_vol3:slow_storage
1216606 Tue May 13 10:11:09 2008
RACmaster = system1
1216606 Tue May 13 10:11:09 2008
system1:/opt/VRTSdbed/common/.dba/tsdb_setup.sh -g nobody_data1 -o addvol -d\
data1vol - v new_vol1 -m /oradata1 -t vxfs.placement_class.FAST_STORAGE
1216606 Tue May 13 10:11:09 2008
command failed, ret=1
1216606 Tue May 13 10:11:09 2008
tsdb_setup.sh arguments -g nobody_data1 -o addvol -d data1vol -v
new_vol1 -m /or
adata1 -t vxfs.placement_class.FAST_STORAGE
05/13/08@17:08:11
size of volume new_vol1 is 204800
VxVM vxvset ERROR V-5-1-10035 Volume set data1vol contains volume(s)
in snapshot chain.
This can cause inconsistencies in the snapshot hierarchy. Specify "-f" option
to force the operation.
^^^^ NOTE: here is the reason for the failure, barried in this log file:
299Troubleshooting SFDB tools
Troubleshooting SmartTier for Oracle