Thursday, July 25, 2013

ORACLE - Database/Server Migration

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.

No comments:

Post a Comment