- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Moving a data file from a node to RAC shared (raw)...
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
тАО01-13-2006 08:51 PM
тАО01-13-2006 08:51 PM
Moving a data file from a node to RAC shared (raw) volume
-If I have a data files (database data files) created on a normal file system seen only by node1 ,Can I move or copy these files from this file system to be in a logical volume under /dev/vg_billing_data/ (the shared volume that handle the raw devices to be seen by both nodes).
-If yes, kindly I need the procedure to do that.
-If I dropped a raw device from my data base, will this drop the related logical volume?
-In Solaris you can add raw device without deactivate the current volume group, export the map and import on the other node ,why in HP we canтАЩt ,Is there any other way to add raw devices on HP without DB shutdown and deactivating volume group, map export ,map import тАжтАжтАжтАж..??
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-13-2006 09:11 PM
тАО01-13-2006 09:11 PM
Re: Moving a data file from a node to RAC shared (raw) volume
Yes you can do that but it will require some DBA's suggestions on how to do it. In my opinion you will have to drop one datafile and reallocate a new one on the desired path.
Dropping a raw device from the database will only stop access to that file, the LVOL will still exist.
In HP as well you can do all these functions online without deactivating the VG.
lvcreate does not require deactivation of the VG (The newly device created is used as a raw device)
vgexport wiht -p option does not actually export or deactivate the VG but does other functions requires and mentioned on commandline.
HTH,
Devender
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-13-2006 09:48 PM
тАО01-13-2006 09:48 PM
Re: Moving a data file from a node to RAC shared (raw) volume
-If I have a data files (database data files) created on a normal file system seen only by node1 ,Can I move or copy these files from this file system to be in a logical volume under /dev/vg_billing_data/ (the shared volume that handle the raw devices to be seen by both nodes).
-If yes, kindly I need the procedure to do that.
You said:
"Yes, you can do that but it will require some DBA's suggestions on how to do it. In my opinion you will have to drop one datafile and reallocate a new one on the desired path."
Here, the source datafile is formated with the vxfs filesystem and mounted to one node (node1) which is a member of a RAC cluster. The shared volume (/dev/vg_billing_data) for the cluster is not formated it is raw (not formated). My query was, can I move or copy datafile from node1 that is formated with the vxfs filesystem to be a part of logical volume under /dev/vg_billing_data/ (the raw shared volume) and to be seen by both nodes.
If yes then how?
Best regards,
Rana
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-13-2006 09:53 PM
тАО01-13-2006 09:53 PM
Re: Moving a data file from a node to RAC shared (raw) volume
In annyway you can not copy a file from the filesystem to a raw device. In turn you will have to drop the formatted file and reallocate database space on the raw device.
As I mentioned earlier I am not a DBA and some DBA will better suggest about achiving it.
HTH,
Devender
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-14-2006 02:29 AM
тАО01-14-2006 02:29 AM
Re: Moving a data file from a node to RAC shared (raw) volume
I beg to differ. It's just not standard operating practice and normally is more trouble than it's worth, notably think support.
If anything were to go wrong, then one will always wonder whether it was due to moving data behind oracle back.
The binary contents of a db file vs raw device is exaclty the same. So you can just dd your file onto a raw device, replace the file with a softlink to the raw device and be happy, or at least test.
Next you may want to SQL> ALTER DATABASE ... RENAME ...
For the dd you normally need an oseek.
Try on a 1MB file dummy tablespace/file first!
Good luck,
Hein,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-21-2006 04:45 PM
тАО01-21-2006 04:45 PM