-
quick io
Hi Friends,
We have quick io enabled for all our datafiles in one of our database.
Now i want to move some of the datafiles to other files system.
How do i move the datafiles along with the quick io files.
Do i need to disable them in the current location. Add them in the new location and move the corresponding datafiles to that location.
Thanks in advance.
regards
anandkl
anandkl
-
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
he probably means Veritas Quick I/O for Oracle, sort of simulate direct i/o without using raw devices
-
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
Re: quick io
Originally posted by anandkl
Do i need to disable them in the current location. Add them in the new location and move the corresponding datafiles to that location.
Yes you need to
1)delete the soft links created by quick io.
2)Move the datafile at the os level
3)Recreate the soft links to the datafile
regards
Hrishy
-
Hi Friends,
Thanks a lot . I found this info in metalink and got the job done.
Thanks once again.
regards
anandkl
To relocale the file do
# ls -la
shows the qio_test01.dbf and
.qio_test01.dbf::cdev:vxfs:
# rm qio_test01.dbf
# cp .qio_test01.dbf
/dbdist03/u04/oradata/djd1/.qio_test01.dbf
# cd /dbdist03/u04/oradata/djd1/
# ln -s .qio_test01.dbf::cdev:vxfs: qio_test01.dbf (note that ::cdev:vxfs: is just in ln command and tells filesystem to treat it as a rawdevice file, and you need verify that all : in link is correct. Compare with file created by qiomkfile command, I´m pulling this from memory)
anandkl
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|