Data Migration help!!

[roadrunner_1]

Experts!!! I need all your help..
I need to migrate data from old legacy storage to XP512 frames. The data is Oracle DB and flat files...
What is the best way to perform this migration and what will be the steps involved...

POINTS will be awarded to all those who will contribute to this post

[Steven E. Protter]

Okay, all you need to do is shut down your databases and take a backup.

Oracle migration will work just fine if the db is shut cold. You can migrate the databases with an fbackup tape, or via ftp or sftp.

If your db size includes files all less than 2G, you can use Ignite, but fbackup or the above is just fine.

You'll need to obviously be networked to use transfer protocols.

Need more info? Reply with specific questoins.

P

[RAC_1]

Both storages are connected to system.

New group for XP. Shutdown oracle.

Create appropriate file systems on new VG.
(check you have large file system support enabled-if you have files greater then 2gb. if it is enabled on old storage)

go to old file system1
find . |cpio -pudlm /new_filesys

repaet procedure for all file systems.
you can use -v option in cpio redirect it to file and check file counts also.

OR

Take a cold backup and restore on new XP.

[Rajeev Shukla]

One more best way would be if you have both old legacy storage and XP512 connected to the system.
Add the disk from XP512 to the existing volume groups and then do a pvmove. This will move all the physical extents from one disk to another disk (you wont know which was u'r original disk) now go through man pages of pvmove before you use it.
The beauty is you can either move one LV or the whole disk from on to another.
pvmove /dev/dsk/c1t0d0 /dev/dsk/c2t0d0 /dev/dsk/c3t0d0 moves physical extents from /dev/dsk/c1t0d0 to /dev/dsk/c2t0d0 & /dev/dsk/c3t0d0

Cheers
Rajeev

[Rajeev Shukla]

One more best way would be if you have both old legacy storage and XP512 connected to the system.
Add the disk from XP512 to the existing volume groups and then do a pvmove. This will move all the physical extents from one disk to another disk (you wont know which was u'r original disk) now go through man pages of pvmove before you use it.
The beauty is you can either move one LV or the whole disk from on to another.
pvmove /dev/dsk/c1t0d0 /dev/dsk/c2t0d0 /dev/dsk/c3t0d0 moves physical extents from /dev/dsk/c1t0d0 to /dev/dsk/c2t0d0 & /dev/dsk/c3t0d0

one more thing You can do this online. Though the system will be slow at that time.
Cheers
Rajeev

[Michael Tully]

Beware of attempting to use the pvmove scenario. You need to make sure that the number PE extent size for the XP LUN's are smaller than the first existing LUN in each group. If they are not you *will* waste valuable space for each LUN utilised. I would suggest that you create a new volume group structure with having both the legacy and new disk attached to the new server if possible.

Here is an example, assuming you have the new volume groups created, and old disk information exported/imported via mapfiles.

For each filesystem
# cd /oldfilesystem1
# find . -xdev | cpio -pdumv /newfilesystem1

Once you have done this, you can copy to the second/third filesystems etc.
Once you have completed, you can re-mount however you need.

If you don't have both disks attached, you'll need to probably create tapes and restore from them or do the data transfer via ftp.

[Sridhar Bhaskarla]

Hi,

Prepare a make_tape_recovery image. Make sure you have good data backups.

I assume you have old legacy on SCSI and XP512 through Fiber channel.

I would do the following.

Get the XP connected. Create new volume groups and file systems on the XP LUNs and mount them as /newdb* etc.,

Then use either cpio or just cp -Rp to copy data from old file systems to new file systems.

Unmount new file systems and old filesystems. Mount new file systems on the old mount points. Update /etc/fstab to replace old logical volumes with the new ones. Start the database. Verify if everything is fine. Keep the old legacy connections in tact for a week. Take another maintenance window, export the old volumegroups. Shutdown the database. Shutdown the systems. Disconnect the cables and cards if you want. Bring up the system.

If you are using fiber channel now, then vgreduce the alternate links and free up one card. Connect XP to the free card. Create volume groups and new file systems. Follow the above procedure. Once everything is verified, export the old volume groups, connect the other cable from XP, run ioscan -f and vgextend the new volume groups with the alternate links.

This is a safe procedure and backout is real easy in case of unexpected issues.

-Sri

[roadrunner_1]

Thanks for all the responses...Keep posting, points will be awarded to all good answers