Kathy, I am assuming that you did a cp and not a mv to get the file into /u18 from /u16.
If you do an ls -ltra in both directories (u16 & u18) is there an atest.dbf and a .atest.dbf in both directories (atest.dbf links to .atest.dbf::cdev:vxfs:)? The error seems to imply that the original file or directory does not exist. donita :Date: Mon, 08 Jul 2002 12:44:59 -0800 :To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> :X-Comment: Oracle RDBMS Community Forum :X-Sender: Kathy Duret <[EMAIL PROTECTED]> :From: Kathy Duret <[EMAIL PROTECTED]> :Subject: RE: moving Vertias quick io files in oracle :X-ListServer: v1.0g, build 71; ListGuru (c) 1996-2001 Bruce A. Bergman : :This is what I did : :I created a file at the unix level using quickio in /u16 :/opt/VRTSvxfs/sbin/qiomkfile -h 8k -s 100k atest.dbf : :Then created the tablespace atest with datafile /u16/oracle/proddata/atest.dbf : :To simulate moving a files I did the same thing in u18 :/opt/VRTSvxfs/sbin/qiomkfile -h 8k -s 100k atest.dbf : :In oracle as system I altered offline atest : :unix as oracle cp -rp atest.dbf to /u18/oracle/proddata : :ls -lrt : :lrwxrwxrwx 1 oracle dba 22 Jul 8 10:21 atest.dbf -> .atest.dbf::c :dev:vxfs: : :looks just fine. Then went back into oracle and as system: : :alter database rename file '/u16/oracle/proddata/atest.dbf' to :'/u18/oracle/proddata/atest.dbf' : :And then I get this error. : : : ::> * ::> ERROR at line 1: ::> ORA-01511: error in renaming log/data files ::> ORA-01516: nonexistent log file, datafile or tempfile ::> '/u16/oracle/proddata/atest.dbf' ::> : : :-----Original Message----- :Sent: Monday, July 08, 2002 12:28 PM :To: [EMAIL PROTECTED] : : :Hi Kathy. : :I am still a little new to Veritas, but maybe I can make a couple of helpful :suggestions. : :We use exact names instead of the links. This means that the name in the :database and the name on the file system are actually different. We have to move :the file at the os level and then change the name in the database using the :names the database is expecting. (we have a ::cdev:vxfs: on the end of the :files). : :The use of the symbolic links is a little more straight forward. It is necessary :to move the file (actually a .file) and create a new symbolic link for it (with :the Q I/O extension). Then in the database the .file name is used without the . :I beleive. : :Hope this helps. :donita : : ::Date: Mon, 08 Jul 2002 11:58:27 -0800 ::To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> ::X-Comment: Oracle RDBMS Community Forum ::X-Sender: Kathy Duret <[EMAIL PROTECTED]> ::From: Kathy Duret <[EMAIL PROTECTED]> ::Subject: RE: moving Vertias quick io files in oracle ::X-ListServer: v1.0g, build 71; ListGuru (c) 1996-2001 Bruce A. Bergman :: ::Yes :: ::-----Original Message----- ::Sent: Monday, July 08, 2002 12:48 PM ::To: Multiple recipients of list ORACLE-L :: :: :: ::Did you first move the file at the OS level? :: ::Kathy Duret wrote: ::> ::> I am trying to move some oracle files that have been quick ioed using :Veritas. ::> ::> I have no problem creating quickio files or growing them but when I try to :move them I get ::> ::> SQL> / ::> alter database rename file '/u16/oracle/proddata/atest.dbf' to :'/u18/oracle/prod ::> * ::> ERROR at line 1: ::> ORA-01511: error in renaming log/data files ::> ORA-01516: nonexistent log file, datafile or tempfile ::> '/u16/oracle/proddata/atest.dbf' ::> ::> ::> All the lovely manual says regarding moving files is: trying moving the :"hot" files. ::> ::> I tried making a new quick io file on the new disk, copying the unix file :using cp -rp ::> and did an ls -lrt and the file looks fine, linked and everything. But when :I alter the tablespace offline and try the move I get the above. ::> ::> Anybody know how to do this? ::> ::> Thanks, ::> ::> Kathy ::> ::> Confidential ::> This e-mail and any files transmitted with it are the property ::> of Belkin Components and/or its affiliates, are confidential, ::> and are intended solely for the use of the individual or ::> entity to whom this e-mail is addressed. If you are not one ::> of the named recipients or otherwise have reason to believe ::> that you have received this e-mail in error, please notify the ::> sender and delete this message immediately from your computer. ::> Any other use, retention, dissemination, forwarding, printing ::> or copying of this e-mail is strictly prohibited. ::> -- ::> Please see the official ORACLE-L FAQ: http://www.orafaq.com ::> -- ::> Author: Kathy Duret ::> INET: [EMAIL PROTECTED] ::> ::> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 ::> San Diego, California -- Public Internet access / Mailing Lists ::> -------------------------------------------------------------------- ::> To REMOVE yourself from this mailing list, send an E-Mail message ::> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in ::> the message BODY, include a line containing: UNSUB ORACLE-L ::> (or the name of mailing list you want to be removed from). You may ::> also send the HELP command for other information (like subscribing). ::-- ::Please see the official ORACLE-L FAQ: http://www.orafaq.com ::-- ::Author: Suzy Vordos :: INET: [EMAIL PROTECTED] :: ::Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 ::San Diego, California -- Public Internet access / Mailing Lists ::-------------------------------------------------------------------- ::To REMOVE yourself from this mailing list, send an E-Mail message ::to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in ::the message BODY, include a line containing: UNSUB ORACLE-L ::(or the name of mailing list you want to be removed from). You may ::also send the HELP command for other information (like subscribing). :: ::Confidential ::This e-mail and any files transmitted with it are the property ::of Belkin Components and/or its affiliates, are confidential, ::and are intended solely for the use of the individual or ::entity to whom this e-mail is addressed. If you are not one ::of the named recipients or otherwise have reason to believe ::that you have received this e-mail in error, please notify the ::sender and delete this message immediately from your computer. ::Any other use, retention, dissemination, forwarding, printing ::or copying of this e-mail is strictly prohibited. ::-- ::Please see the official ORACLE-L FAQ: http://www.orafaq.com ::-- ::Author: Kathy Duret :: INET: [EMAIL PROTECTED] :: ::Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 ::San Diego, California -- Public Internet access / Mailing Lists ::-------------------------------------------------------------------- ::To REMOVE yourself from this mailing list, send an E-Mail message ::to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in ::the message BODY, include a line containing: UNSUB ORACLE-L ::(or the name of mailing list you want to be removed from). You may ::also send the HELP command for other information (like subscribing). : : : |\ _,,,---,,_ : ZZZzz /,`.-'`' -. ;-;;,_ :_________________|,4- ) )-,_. ,\ (____-'___________________ : '---''(_/--' `-'\_) : :Donita Hilfinger [EMAIL PROTECTED] :ISIS Oracle Database Administrator Ph:(303)737-4179 :Great-West Life Assurance Co. Fax:(303)737-4850 :8515 E. Orchard Rd, m/s 7T3 :Englewood, CO 80111 : :"The promise is remembered long after the conditions attached to it are :forgotten" :-- author unknown : :Confidential :This e-mail and any files transmitted with it are the property :of Belkin Components and/or its affiliates, are confidential, :and are intended solely for the use of the individual or :entity to whom this e-mail is addressed. If you are not one :of the named recipients or otherwise have reason to believe :that you have received this e-mail in error, please notify the :sender and delete this message immediately from your computer. :Any other use, retention, dissemination, forwarding, printing :or copying of this e-mail is strictly prohibited. :-- :Please see the official ORACLE-L FAQ: http://www.orafaq.com :-- :Author: Kathy Duret : INET: [EMAIL PROTECTED] : :Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 :San Diego, California -- Public Internet access / Mailing Lists :-------------------------------------------------------------------- :To REMOVE yourself from this mailing list, send an E-Mail message :to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in :the message BODY, include a line containing: UNSUB ORACLE-L :(or the name of mailing list you want to be removed from). You may :also send the HELP command for other information (like subscribing). |\ _,,,---,,_ ZZZzz /,`.-'`' -. ;-;;,_ _________________|,4- ) )-,_. ,\ (____-'___________________ '---''(_/--' `-'\_) Donita Hilfinger [EMAIL PROTECTED] ISIS Oracle Database Administrator Ph:(303)737-4179 Great-West Life Assurance Co. Fax:(303)737-4850 8515 E. Orchard Rd, m/s 7T3 Englewood, CO 80111 "The promise is remembered long after the conditions attached to it are forgotten" -- author unknown -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Donita Hilfinger INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
