Diffrent method/tools to migrate Oracle Database:
1) DataGuard Physical Standby :
2) Data Pump :
3) Trasportable Tablespace :
4) Golden Gate :
5) Stream :
6) Trasportable Database :
7) Cross Plateform incremental backup (w/TTS) :
8) SRDF :
9) Upgrade and Migrate database from 10gR2 to 11gR2 and from NetAPP to EMC SAN:
1) Old server (oldtest):
Storage : EMC SAN
Existing installed Oracle 10gR2
Existing ASM Diskgroup : +DGTEST1
Existsing Database: +ASM and TEST1
2) New server (newtest):
Storage : NetAPP (slow storage)
Installed the Oracle 11gR2 software
Create diskgroup : +DGTEST1 (same name)
Create the database : +ASM and TEST1 (same name)
Shutdown the database (both)
SA Team: UNMOUNT the EMC SAN and remove all existing data
SA Team: Mount the EMC SAN at NEW server (newtest)
DBA:
1) Create a new disk DISK2 (Note: At old server DISK1 exists):
sudo /etc/init.d/oracleasm createdisk DISK2 /dev/dm-01 (EMC SAN)
Marking disk "DISK2" as an ASM disk: [ OK ]
2) Add EMC disk grup to newserver:
alter diskgroup +DGTEST1 add disk 'ORCL:DISK2' rebalance power 11;
3) Drop the NetAPP (slow) device from the diskgroup:
alter diskgroup +DGTEST1 drop disk DISK1:
After rebalance, newtest server is ready with EMC SAN storage.
1) DataGuard Physical Standby :
2) Data Pump :
3) Trasportable Tablespace :
4) Golden Gate :
5) Stream :
6) Trasportable Database :
7) Cross Plateform incremental backup (w/TTS) :
8) SRDF :
9) Upgrade and Migrate database from 10gR2 to 11gR2 and from NetAPP to EMC SAN:
1) Old server (oldtest):
Storage : EMC SAN
Existing installed Oracle 10gR2
Existing ASM Diskgroup : +DGTEST1
Existsing Database: +ASM and TEST1
2) New server (newtest):
Storage : NetAPP (slow storage)
Installed the Oracle 11gR2 software
Create diskgroup : +DGTEST1 (same name)
Create the database : +ASM and TEST1 (same name)
Shutdown the database (both)
SA Team: UNMOUNT the EMC SAN and remove all existing data
SA Team: Mount the EMC SAN at NEW server (newtest)
DBA:
1) Create a new disk DISK2 (Note: At old server DISK1 exists):
sudo /etc/init.d/oracleasm createdisk DISK2 /dev/dm-01 (EMC SAN)
Marking disk "DISK2" as an ASM disk: [ OK ]
2) Add EMC disk grup to newserver:
alter diskgroup +DGTEST1 add disk 'ORCL:DISK2' rebalance power 11;
3) Drop the NetAPP (slow) device from the diskgroup:
alter diskgroup +DGTEST1 drop disk DISK1:
After rebalance, newtest server is ready with EMC SAN storage.
No comments:
Post a Comment