We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Migrating a 2 TB database from 9 i to 10 G Rac ASM

happylife1234
on
Medium Priority
965 Views
Last Modified: 2013-12-19
 we   have an oracle database in oracle 9i  sizing up to nearly 2 Terra Bytes in OLTP environment.  we would like to implement Oracle 10g RAC with Storage as ASM  on  a SAN raid 5 and 10.

a) What is the best method to migrate this database to Oracle 10g RAC with minimum
     down time.

b) Can you please also tell me the avg time taken to migrate a 2 TB Size database to 10
    RAC

c) How are the  administratative  tasks  different  with 2 TB database and small databases
     below 200 GB

d) What should be the method for backups. Does RMAN support such big database or  do we need to go for third party tools .if yes which ones

e) What are the problems that we usually encounter in such big databases

Thanks
Comment
Watch Question

Top Expert 2009
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Top Expert 2009
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
CERTIFIED EXPERT
Top Expert 2008
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
Hi Mrjoltcola,

Can you please also tell me the avg time taken to migrate a 2 TB Size database to 10    RAC ASM  with procedure  mentioned by you ie from standered database to ASM. What will be the down time  for this method is the database is 2 TB .Does ASM support moving from lower versions to 10G .Can the Mirror snapshots provided by SANs (EMC, NetApp) be used for an upgrade ie from 9 i to 10g ASM.

Thanks
Top Expert 2009
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
Hi

Thanks for the information and your  advice  on experience RAC/ASM/SAN .I did get a chance to work on these  though I am not an expert in this field. The database  I worked was about only 200 gb in size but now  I need to work on migrating   2 TB database from 9 i to 10 ASM RAC. I used export and imports and datapump for migrating databases which were relatively small in size .This being 2 Tb data  I  did not have the correct approach for the migration
Top Expert 2009
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
What are the problems that we usually encounter in such big databases and  How are the  administratative  tasks  different  with 2 TB from that of small databases  below 200 GB .



CERTIFIED EXPERT
Top Expert 2008
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Top Expert 2009
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Top Expert 2009

Commented:
I recommend all suggestions by myself and schwertner as valid answers in the discussion.

Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.