The UNIX and Linux Forums  


Go Back   The UNIX and Linux Forums > Special Forums > UNIX and Linux Applications
.
google unix.com



UNIX and Linux Applications Discuss UNIX and Linux software applications. This includes SQL, Databases, Middleware, MOM, SOA, EDA, CEP, BI, BPM and similar topics.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Used Space on Logical Volumes aldowsary AIX 7 04-24-2007 03:13 AM
Setting up Logical Volumes in Solaris 10 jimthompson UNIX for Dummies Questions & Answers 3 09-25-2006 08:43 AM
filesystems and logical volumes uXion AIX 1 08-16-2006 12:39 AM
Did not know about logical volumes gezi News, Links, Events and Announcements 2 04-27-2005 11:10 AM
AIC logical volumes 98_1LE UNIX for Dummies Questions & Answers 1 09-14-2002 10:33 PM

Reply
English Japanese Spanish French German Portuguese Italian Dutch Swedish Russian Norwegian Hungarian Hebrew Danish Bulgarian Greek Powered by Powered by Google
 
LinkBack Thread Tools Search this Thread Rate Thread Display Modes
  #1 (permalink)  
Old 09-15-2009
daveisme daveisme is offline
Registered User
  
 

Join Date: Jul 2007
Posts: 39
raw logical volumes to jfs2

Does anybody if it is possible to convert raw logical volumes to jfs2? If so how is it done or where can I find the information to make the conversion. We have an Oracle Db on AIX and it is using raw lv's which we want to convert to jfs2 because the raw devices don't restore correctly from our sysback backup.
  #2 (permalink)  
Old 09-15-2009
daveisme daveisme is offline
Registered User
  
 

Join Date: Jul 2007
Posts: 39
Oracle raw devices (logical volumes) to jfs2

Is there an easy way to convert Oracle raw logical volumes on AIX to jfs2?
  #3 (permalink)  
Old 09-15-2009
jim mcnamara jim mcnamara is online now Forum Staff  
...@...
  
 

Join Date: Feb 2004
Location: NM
Posts: 5,790
Bumping up posts or double posting is not permitted in these forums.

Please read the rules, which you agreed to when you registered, if you have not already done so.

You may receive an infraction for this. If so, don't worry, just try to follow the rules more carefully. The infraction will expire in the near future

Thank You.

The UNIX and Linux Forums.
  #4 (permalink)  
Old 09-15-2009
daveisme daveisme is offline
Registered User
  
 

Join Date: Jul 2007
Posts: 39
sorry 2nd post was made in another thread area. I wanted to make sure it was seen by apps (Oracle) people and AIX people.
  #5 (permalink)  
Old 09-15-2009
zxmaus's Avatar
zxmaus zxmaus is offline Forum Staff  
Moderator
  
 

Join Date: May 2008
Location: /etc/objrepos
Posts: 303
Hi,

there is no conversion from raw to jfs2 because jfs2 is basically a rawdevice with a filesystem in it - you have data in your rawdevices - and there's no space for both

Oracle recommends following way using rman:

Use RMAN to move datafiles from raw devices to file system.

1. Connect to the database:


Code:
$ sqlplus system/manager@orcl

2. Put the tablespace with the datafile, which should be converted, offline:


Code:
SQL> alter tablespace test_ts offline;

3. Start rman and connect it to the database:


Code:
$ rman nocatalog target rman/rman@orcl

4. Move the datafile to file system:


Code:
RMAN> run { 
2> allocate channel c1 type disk; 
3> copy datafile '/dev/raw1' to '/u01/oradata/orcl/test_ts.dbf'; 
4> }

5. Rename the moved datafile:


Code:
SQL> alter database rename file '/dev/raw1' to '/u01/oradata/orcl/test_ts.
dbf';

6. Put the tablespace back online:


Code:
SQL> alter tablespace test_ts online;


But be careful ...

If you are using RMAN as the backup tool then a backup after the performed
steps is recommended, because otherwise RMAN treats the copied file as a
backup.

Usually Oracle datafiles are moved from filesystem to raw devices using
the dd command. Using dd is the fastest method to accomplish it. However, it is
necessary to know how many blocks to skip in the raw device, so that the information necessary for the Operating System is not overwritten. The information on how many blocks to skip is different on the different platforms. Using RMAN there's no necessity
to know such platform specific information.

Kind regards
zxmaus
Reply

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On




All times are GMT -4. The time now is 03:20 PM.


Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited. Language Translations Powered by .
vBCredits v1.4 Copyright ©2007 - 2008, PixelFX Studios
The UNIX and Linux Forums Content Copyright ©1993-2009. All Rights Reserved.Ad Management by RedTyger

Content Relevant URLs by vBSEO 3.2.0