| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: moving Vertias quick io files in oracle
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.:> '/u16/oracle/proddata/atest.dbf'
:> *
:> ERROR at line 1:
:> ORA-01511: error in renaming log/data files
:> ORA-01516: nonexistent log file, datafile or tempfile
-----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
"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).Received on Mon Jul 08 2002 - 15:44:59 CDT
 |
 |