09-23-2013 11:19 AM
Hi Experts,
A device file was created as a result of running the Veritas qiomkfile command:
# cd /sybase/k2rpt_sql/TOR_K2RPT_UAT/sybase_devices # /opt/VRTS/bin/qiomkfile -s 2000m log06.dat.qio # ls -l log06.dat.qio lrwxrwxrwx 1 root root 26 Sep 18 10:29 log06.dat.qio -> .log06.dat.qio::cdev:vxfs: # ls -l .log06.dat.qio::cdev:vxfs: crw-r--r-- 1 root root 283, 35 Sep 18 10:29 .log06.dat.qio::cdev:vxfs:
Now I want to remove the link, which I have no problem doing so with rm command, and the device file, on which rm command has no effect:
# rm -f .log06.dat.qio::cdev:vxfs:
# ls -l .log06.dat.qio::cdev:vxfs:
crw-r--r-- 1 sybase sybase 283, 35 Sep 18 10:29 .log06.dat.qio::cdev:vxfs:
# rm -f ".log06.dat.qio::cdev:vxfs:"
# ls -l .log06.dat.qio::cdev:vxfs:
crw-r--r-- 1 sybase sybase 283, 35 Sep 18 10:29 .log06.dat.qio::cdev:vxfs:
Any help is appreciated.
Alex
Solved! Go to Solution.
09-23-2013 11:43 AM
The SF Oracle guide say:
To disable Quick I/O1 If the database is running, shut it down.2 To change Quick I/O files back to regular VxFS files, run the followingcommand from the directory containing the mkqio.dat list:$ /opt/VRTSdbed/bin/qio_convertdbfiles -uThe list of Quick I/O files in the mkqio.dat file is displayed. For example:.file1::cdev:vxfs: --> file1.file2::cdev:vxfs: --> file2.file3::cdev:vxfs: --> file3.file4::cdev:vxfs: --> file4.file5::cdev:vxfs: --> file5The qio_convertdbfiles command with the undo option (-u) renames thefiles from .filename to filename and removes the symbolic link to .filenamethat was created along with the Quick I/O files.3 To remount the file system with Quick I/O disabled, use the mount -o noqiocommand as follows:# /opt/VRTS/bin/mount -F vxfs -o remount,noqio /mount_point
09-23-2013 12:49 PM
You MAY be able to edit mkqio.dat to contain just the file you want (making a copy of file first) and then restore mkqio.dat back afterwards.
Mike
09-23-2013 11:43 AM
The SF Oracle guide say:
To disable Quick I/O1 If the database is running, shut it down.2 To change Quick I/O files back to regular VxFS files, run the followingcommand from the directory containing the mkqio.dat list:$ /opt/VRTSdbed/bin/qio_convertdbfiles -uThe list of Quick I/O files in the mkqio.dat file is displayed. For example:.file1::cdev:vxfs: --> file1.file2::cdev:vxfs: --> file2.file3::cdev:vxfs: --> file3.file4::cdev:vxfs: --> file4.file5::cdev:vxfs: --> file5The qio_convertdbfiles command with the undo option (-u) renames thefiles from .filename to filename and removes the symbolic link to .filenamethat was created along with the Quick I/O files.3 To remount the file system with Quick I/O disabled, use the mount -o noqiocommand as follows:# /opt/VRTS/bin/mount -F vxfs -o remount,noqio /mount_point
09-23-2013 12:30 PM
Hi Mike,
Thanks for your valuable information. I learned a new command!
However, the command will convert all QIO files back to regular files, which is not desirable. My senario is that in case of a QIO file was added with wrong size/filename, I want to delete it and recreate it. Is there a way we can do this for a single file?
Best regards,
Alex
09-23-2013 12:49 PM
You MAY be able to edit mkqio.dat to contain just the file you want (making a copy of file first) and then restore mkqio.dat back afterwards.
Mike
09-23-2013 01:01 PM
Micke, Thank you again.
Alex