ORACLE DATA MIGRATION

[bonsky]

I believe oracle is using a raw data.. what if have one datavg of oracle ang i want to transfer it to another physical disk for upgrade of space..what bachup should i use??? is there a way to backup the whole vg? should i use savevg?

thanks

 

[PSD]

Bonsky,

If the physical volume is in the same volume group you can use migratepv. If you have not used this before check out the man page and use smitty migratepv to move the data. If the logical volume needs to be moved to another volume group then you can use cplv, or backup and restore.

Cheers

PSD
IBM Certified Specialist - AIX V4.3 Systems Support
IBM Certified Specialist - AIX V4 HACMP

 

[bonsky]

okay... but then ill be migrating this data from a higher physical disk which is from 4gb to 18.2 gb of disk.. so all PP's need to be adjust, can backup restore of datavg will keep the raw data intact?
thanks

 

[PSD]

bonsky,

Well yes you could use savevg and that should be o.k. everything should be backed up.

Cheers


PSD
IBM Certified Specialist - AIX V4.3 Systems Support
IBM Certified Specialist - AIX V4 HACMP

 

[aixqueen]

Raw lv?
Raw logical volume data will NOT be archived using a savevg. I don't believe?


-----------------------------------------------------

http://techsupport.services.ibm.com...mode=9&documents=390605220514846&database=aix

Make sure you have your table data archived separately to file incase you have to recreate those tables as well.

savevg with a larger pp size

http://techsupport.services.ibm.com...mode=9&documents=G91745667913562&database=aix

savevg info

http://techsupport.services.ibm.com...mode=9&documents=090605221714620&database=aix

 

[PSD]

Well done for spotting that about raw lv's, I did not read that part correctly. I have done a few savevg's over the years and am fairly sure that raw logical volumes do get backed up. I suppose you can give it a try....A good example of this is the JFSlog which is restored. It does however not back up unmounted filesystems but a raw lv without a f/s whould be backed up. I am not able to fully check this at the moment.

Cheers

PSD
IBM Certified Specialist - AIX V4.3 Systems Support
IBM Certified Specialist - AIX V4 HACMP

 

[bonsky]

bro and sis,
if i use savevg do i need to mount it while saving the vg otherwise it wont be back up on my tape?
Also, if i am to use the dd command, you mean to say i have to do it one by one for each file system that contains my raw data?

Thanks and have a nice day!

 

[PSD]

bonsky,

Well there are two different issues here:

filesystems and raw l.v's are two different things.

If you have a raw lv you do not use JFS to access the data, data access is controlled by the application. If you have filesystems i.e. a mount point then LVM uses JFS to access the data.

If you use savevg all filesystems will need to be mounted to be backed up.

If you use dd you will have to specify an input device for each dd command i.e. one lv at a time. You could write a script to automate this or speed it up.

If you are not sure whether you have raw lv's or filesystems post up the output of

lsvg -l <vgnamne>

Cheers



PSD
IBM Certified Specialist - AIX V4.3 Systems Support
IBM Certified Specialist - AIX V4 HACMP

 

[MikeLacey]

Bonsky,

I suggest that, in addition to the excellent suggestions above, you backup your Oracle data with the Oracle command 'exp'.

Put a copy of the exp output file on tape and, if you have room, put a copy on a disk somewhere else as well. Mike
michael.j.lacey@ntlworld.com
Email welcome if you're in a hurry or something -- but post in tek-tips as well please, and I will post my reply here as well.

 

[bonsky]

Thanks a lot,
for your help guys!!