Moving oracle datafiles from one SAN storage to another SAN storage

We have a vnx5100 SAN storage for our oracle datafiles. we're planning to move to vnx5500 SAN storage.
what are the best methodes to move oracle datafiles to the new SAN storage?

thank you.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

johnsoneSenior Oracle DBACommented:
To me, easiest is to shut down the database.  Move the files to the new location.  Do a STARTUP MOUNT.  Issues ALTER DATABASE RENAME FILE... for each file moved.  Then ALTER DATABASE OPEN.
CCVOIPAuthor Commented:
we're not renaming the files, neither changing the paths. do I need to anything after the move?
slightwv (䄆 Netminder) Commented:
If the names/paths aren't changing then it should be a shutdown, move, startup.

There might be issues if you are using ASM.  Ive never used it so I'm not sure how it handles the logical file names as it relates to the raw storage.

If you want to do things live then there might be some magic but I would contact Oracle Support or your account team for that.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
johnsoneSenior Oracle DBACommented:
Agreed.  If the paths aren't going to change when complete, then shutdown, move, startup.  Would be the easiest.

ASM would be very different, but there wouldn't be paths.  LUNs would change, so you would have to do something else.  However, with ASM I believe you can do it live.  Both arrays would have to be attached, create the ASM disks on the new array and issue the moves then when it is done remove old.

You could probably make it go "faster" by using mirroring.  Where you mirror the new drives to the old, then shutdown and break the mirrors, but that adds complexity.
If you have datafiles in ASm, you can use RMAN to move the files to your new location. In the new SAN storage after creating your new disk groups -
1. Shut down the db and startup in Mount mode.

In rman

RMAN> copy datafile  '+ yourdiskgroup/data/datafile/mydata.441.864306861’  to '+newdiskgroup';

RMAN> Switch datafile ### to copy.  (### is the datafile number can be retrieved from v$datafile)
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.