- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- want to move a filesystem database to a raw-databa...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-11-2002 02:07 PM
тАО10-11-2002 02:07 PM
currently, I have a filesystem database, and i want to move it to raw-database....Is there an easy way to do so, i don't want to destroy the database...
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-11-2002 03:06 PM
тАО10-11-2002 03:06 PM
Re: want to move a filesystem database to a raw-database
By far the easiest way to do this is by exporting your current database, destroying it, recreating it with raw devices, and then reimporting it.
Brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-11-2002 03:31 PM
тАО10-11-2002 03:31 PM
Re: want to move a filesystem database to a raw-database
Would you give me a little more procedure ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-12-2002 09:28 AM
тАО10-12-2002 09:28 AM
Re: want to move a filesystem database to a raw-database
Deanna,
SORRY, but you will can't just move the files to a raw disk and have it work. You will have to export your entire database, create the new table space on the raw disks and do an import.
If you are doing this to gain performance, you might not really see any great benefits. There are people in both camps, and personally I'm for either.
live free or die
harry
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-12-2002 05:37 PM
тАО10-12-2002 05:37 PM
Re: want to move a filesystem database to a raw-database
So the first question is: does your databse program handle a raw database? If not, there's no point in converting. If your program does handle raw data, then it should document very clearly how to convert. Typically it will be called export and import.
Bill Hassell, sysadmin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-14-2002 01:30 AM
тАО10-14-2002 01:30 AM
Re: want to move a filesystem database to a raw-database
The easier solution that I have tried a couple of times is to modify the mount_vxfs options to alter the system caching of the filesystems:
datafiles and redo:
Use mincache=direct,convosync=direct
rbs and temp:
Use mincache=dsync,convosync=dsync
You then get filesystems with "raw" like behavior.
I do not know if the performance boost is significant.
Andreas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-14-2002 04:26 PM
тАО10-14-2002 04:26 PM
SolutionLook at note 146384.1 on metalink. It is possible to move the database over from a cooked filesystem to a raw filesystem, however it is not an easy task, and shouldn't be done lightly. Overall, you are not going to see a good performance increase over cooked filesystem when you consider the added responsiblity of dealing with raw partitions.
Brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-14-2002 06:44 PM
тАО10-14-2002 06:44 PM
Re: want to move a filesystem database to a raw-database
Let's suppose that you have a datafile /u01/oradata/file01.dat that you want to make into a raw file.
0) Shutdown the database.
1) Create a raw logical volume about 1MB larger than the existing file01.dat. Let's call it /dev/vg05/rlvol1
2) Copy /u01/oradata/file01.dat to /dev/vg05/rlvol1 using dd. e.g. dd bs=64k if=/u01/oradata/fileo1.dat of=/dev/vg05/rlvol1
3) Rename the original file. e.g. mv /u01/oradata/file01.dat /u01/oradata/file01.dat.safe
4) Symbolically link the files. e.g.
ln -s /dev/vg05/rlvol1 /u01/oradata/file01.dat
5) Repeat for as many files as you like
6) Start the database.
P.S. I still think this is a dumb idea (unless this is a parallel server).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-14-2002 11:59 PM
тАО10-14-2002 11:59 PM
Re: want to move a filesystem database to a raw-database
to supplement the excellent post by Mr. A. Clay Stephenson above, please also see the following URL:
http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0xf9caa848deccd61190050090279cd0f9,00.html
Hope this helps!
All the best.
Regards
Yogeeraj