DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: quick io

  1. #1
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840

    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

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    What is "quick io"?
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    he probably means Veritas Quick I/O for Oracle, sort of simulate direct i/o without using raw devices

  4. #4
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Ah, I see. Thanks.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  5. #5
    Join Date
    Jan 2001
    Posts
    2,828

    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

  6. #6
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    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
  •  


Click Here to Expand Forum to Full Width