flytxtindia
asked on
Migrating data from one SAN to other
Hi Team,
we are in a situation to migrate data from existing HPMSA storage to New HP EVA 6300 storage.
right now oracle database server resides in our existing storage
i want to know how can i move the oracle binaries to the new san,
The HPMsa has been currently connected to one of HP server, where solaris 10 is the os running on it.
Please let me know if you need any other info
I
we are in a situation to migrate data from existing HPMSA storage to New HP EVA 6300 storage.
right now oracle database server resides in our existing storage
i want to know how can i move the oracle binaries to the new san,
The HPMsa has been currently connected to one of HP server, where solaris 10 is the os running on it.
Please let me know if you need any other info
I
Several assumptions here:
- you are refering to moving the Oracle Data Files
- not using Oracle Managed Files
- Server running Oracle, has access to both SAN locations
1) Shutdown Oracle or bring Tablespaces offline
2) OS copy/move tablespaces
3) Alter the tablespace and rename the datafiles within Oracle (new location)
4) start oracle or bring tablespaces online
Reference this material:
http://download.oracle.com/docs/cd/B10500_01/server.920/a96521/dfiles.htm#8765
- you are refering to moving the Oracle Data Files
- not using Oracle Managed Files
- Server running Oracle, has access to both SAN locations
1) Shutdown Oracle or bring Tablespaces offline
2) OS copy/move tablespaces
3) Alter the tablespace and rename the datafiles within Oracle (new location)
4) start oracle or bring tablespaces online
Reference this material:
http://download.oracle.com/docs/cd/B10500_01/server.920/a96521/dfiles.htm#8765
Not sure why do you need to migrate binaries. IDeally, you should be migrating only database and binaries continue on the server.
You can backup and recover or ask HP to provide a tool for this. All storage vendors have these tools.
You can backup and recover or ask HP to provide a tool for this. All storage vendors have these tools.
ASKER
let me explain you more
a) currently oracle is running on asm
b) asm diks and oracle binaries are on hp msa storage
c)oracle binaries are imported using zfs pools
d) we are planning to migrate the data from asm using the metalink doc : Procedure – (Exact Steps To Migrate ASM Diskgroups To Another SAN Without Downtime. (Doc ID 837308.1)
but i am thinking if i simply done a cpio command and move the oracle binaries to the new SAN, will my oracle properly?
a) currently oracle is running on asm
b) asm diks and oracle binaries are on hp msa storage
c)oracle binaries are imported using zfs pools
d) we are planning to migrate the data from asm using the metalink doc : Procedure – (Exact Steps To Migrate ASM Diskgroups To Another SAN Without Downtime. (Doc ID 837308.1)
but i am thinking if i simply done a cpio command and move the oracle binaries to the new SAN, will my oracle properly?
If you are using ASM you will have to do a block by block copy, or rebuild then backup and restore.
Using RMAN is prefered method to migrate ASM files.
See this article:
http://www.idevelopment.info/data/Oracle/DBA_tips/Automatic_Storage_Management/ASM_36.shtml
Definitely can't use cpio....
See this article:
http://www.idevelopment.info/data/Oracle/DBA_tips/Automatic_Storage_Management/ASM_36.shtml
Definitely can't use cpio....
You can try Open Migrator from EMC for Solaris:
http://www.emc.com/collateral/software/data-sheet/h1710-open-migrator-lm.pdf
http://www.emc.com/collateral/software/data-sheet/h1710-open-migrator-lm.pdf
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If not you can have the storage admin present storage from the new array. Then use os tools (dd, cp) to move the data.