Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: moving Vertias quick io files in oracle
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 <ORACLE-L_at_fatcity.com>
:X-Comment: Oracle RDBMS Community Forum
:X-Sender: Kathy Duret <KathyD_at_belkin.com>
:From: Kathy Duret <KathyD_at_belkin.com>
: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: KathyD_at_belkin.com
:
:
: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 <ORACLE-L_at_fatcity.com>
::X-Comment: Oracle RDBMS Community Forum
::X-Sender: Kathy Duret <KathyD_at_belkin.com>
::From: Kathy Duret <KathyD_at_belkin.com>
::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: KathyD_at_belkin.com
::>
::> 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: ListGuru_at_fatcity.com (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: lvordos_at_qwest.com
::
::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: ListGuru_at_fatcity.com (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: KathyD_at_belkin.com
::
::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: ListGuru_at_fatcity.com (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 donita.hilfinger_at_gwl.com
: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: KathyD_at_belkin.com
:
: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: ListGuru_at_fatcity.com (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 donita.hilfinger_at_gwl.com ISIS Oracle Database Administrator Ph:(303)737-4179 Great-West Life Assurance Co. Fax:(303)737-48508515 E. Orchard Rd, m/s 7T3
"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: dohi_at_gwl.com 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: ListGuru_at_fatcity.com (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).Received on Mon Jul 08 2002 - 17:05:55 CDT