Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: URGENT: Need to move TS from ufs to vxfs file system
larry1962_at_ureach.com (Larry) wrote in message news:<a1238369.0204041910.2ee129e1_at_posting.google.com>...
> Howard et. al.,
>
> Thanks for the feedback.
>
> 2. To "undo" what I did, I did NOT need to copy or move the file back
> (at the OS level). It was still in the original location.
You DO need to copy it back or recover if SCN in a datafile header was changed. But given that it's something wrong with the copies you're lucky you didn't. Just keep originals safe.
> 4. My Oracle blocksize is 8192. UFS uses a blocksize of what, 512?
AFAIK by default 8K but could be something else. Use df -g to check. BTW which Unix do you use?
> Veritas uses something different from ufs.
Yep, it's a different type of a filesystem.
> 5. Is it OK to COPY the datafile, as opposed to MOVE the datafile?
> Is there any real difference. I mean, a unix cp command creates an
> exact copy, right?
I donno if cp is 'sparce file safe'. Search metalink (e.g. have a look at Note:6224.1) for more details about sparce files.
> Any thoughts?
>
> Thanks to all,
> Larry
Cheers,
Igor
Received on Thu Apr 11 2002 - 23:30:51 CDT