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).
