1 / 80

… to Oracle 11.2 on Linux

From Oracle 11.1 on Solaris …. … to Oracle 11.2 on Linux. About Scale Abilities. Full-stack consultancy and engineering for Oracle and Big Data Focus on depth , whilst grasping the big picture We can (and do, frequently) fix broken stuff, but…

johnda
Download Presentation

… to Oracle 11.2 on Linux

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. From Oracle 11.1 on Solaris … … to Oracle 11.2 on Linux

  2. About Scale Abilities • Full-stack consultancy and engineering for Oracle and Big Data • Focus on depth, whilst grasping the big picture • We can (and do, frequently) fix broken stuff, but… • We would rather help you build a high quality solution in the first place

  3. Fix the Storage Problem • 2 * NetApp FAS3250 • 3 shelves: 24 * 450GB 15k SAS disks • 2 controllers: • 2 dual port 10Gbps NICs • 512GB flash card

  4. 2 * NetApp FAS3250 • 3 shelves: 24 * 450GB 15k SAS disks • 2 controllers: • 2 dual port 10Gbps NICs • 512GB flash card

  5. And while we’re at it… • 2 * NetApp FAS3250 • 3 shelves: 24 * 450GB 15k SAS disks • 2 controllers: • 2 dual port 10Gbps NICs • 512GB flash card • 4 * HP DL380 servers (200GB RAM) • Oracle Linux 6 • Oracle Database 11.2

  6. The Target • 2 * NetApp FAS3250 • 3 shelves: 24 * 450GB 15k SAS disks • 2 controllers: • 2 dual port 10Gbps NICs • 512GB flash card • 4 * HP DL380 servers (200GB RAM) • Oracle Linux 6 • Oracle Database 11.2

  7. What are we changing? • Storage • SAN (fibre)  NetApp NAS (IP) • Hardware • SPARC  Intel • Database • Oracle 11.1  Oracle 11.2 • Operating System • Solaris  Linux

  8. What are we changing? • Storage • SAN (fibre)  NetApp NAS (IP) • Hardware • SPARC  Intel • Database • Oracle 11.1  Oracle 11.2 • Operating System • Solaris  Linux

  9. The Requirement • No Downtime • Switch back if there is a problem

  10. and to make it a bit harder….

  11. Database Structure • 460 tables • 1,000 indexes • 5,400 segments • 2,100 tablespaces • 2,200 data files

  12. Database Structure • 460 tables • 1,000 indexes • 5,400 segments • 2,100 tablespaces • 2,200 data files

  13. Database Structure • 460 tables • 1,000 indexes • 5,400 segments • 2,100 tablespaces • 2,200 data files

  14. Database Size • Total Space Usage • 2,300GB • 3 Largest Tables • 430GB • 340GB • 320GB

  15. Database Size • Total Space Usage • 2,300GB • 3 Largest Tables • 430GB • 340GB • 320GB

  16. New Database Structure • Each schema  1 tablespace • 1 tablespace for LOBs • 3 largest tables  tablespace each • Bigfile Tablespaces • 2,000  20 tablespaces/data files • Partition 2 largest tables

  17. The Requirement • SPARC  Intel (endianness) • Oracle 11.1  Oracle 11.2 • No Downtime • Switch Back if there is a Problem • Reduce Tablespaces and Data Files • Partition 2 Largest Tables

  18. Migration Solution • Data Pump • + • Oracle Streams

  19. Migration Overview • Start Streams Capture on Old Database • Data Pump at SCN from Old to New Database • Start Streams Apply from SCN on New Database

  20. Objects to Precreate • Tablespaces • Segment-owning users • 2 largest tables (partitioned) • Roles (Applications and Users) • Directories

  21. Index and Constraints SQL • impdp username parfile=indx_cons.par • index_cons.par: • directory=exports • logfile=imp_indx_cons.log • parallel=4 • network_link=solarisdb • include=constraint,ref_constraint,index • sqlfile=cr_indx_cons.sql • schemas=apollo,hera,pallas • ………… continued on next slide

  22. Index and Constraints SQL • impdp username parfile=indx_cons.par • index_cons.par: • directory=exports • logfile=imp_indx_cons.log • parallel=4 • network_link=solarisdb • include=constraint,ref_constraint,index • sqlfile=cr_indx_cons.sql • schemas=apollo,hera,pallas • ………… continued on next slide

  23. Index and Constraints SQL • impdp username parfile=indx_cons.par • index_cons.par: • directory=exports • logfile=imp_indx_cons.log • parallel=4 • network_link=solarisdb • include=constraint,ref_constraint,index • sqlfile=cr_indx_cons.sql • schemas=apollo,hera,pallas • ………… continued on next slide

  24. Index and Constraints SQL • impdp username parfile=indx_cons.par • index_cons.par: • directory=exports • logfile=imp_indx_cons.log • parallel=4 • network_link=solarisdb • include=constraint,ref_constraint,index • sqlfile=cr_indx_cons.sql • schemas=apollo,hera,pallas • ………… continued on next slide

  25. Index and Constraints SQL • remap_tablespace= • A_HGU_DATA_APR_2006:APOLLO_TS,\ • A_HGU_DATA_MAY_2006:APOLLO_TS,\ • ………… • A_JUR_INDX_AUG_2011:APOLLO_TS,\ • A_JUR_INDX_SEP_2011:APOLLO_TS,\ • ………… • A_TRK_DATA_MAY_2005:APOLLO_TRACK_TS,\ • A_TRK_DATA_JUN_2005:APOLLO_TRACK_TS,\ • ………… • P_WKP_DATA_SEP_2010:PALLAS_TS,\ • P_WKP_DATA_OCT_2010:PALLAS_TS,\

  26. Index and Constraints SQL • remap_tablespace= • A_HGU_DATA_APR_2006:APOLLO_TS,\ • A_HGU_DATA_MAY_2006:APOLLO_TS,\ • ………… • A_JUR_INDX_AUG_2011:APOLLO_TS,\ • A_JUR_INDX_SEP_2011:APOLLO_TS,\ • ………… • A_TRK_DATA_MAY_2005:APOLLO_TRACK_TS,\ • A_TRK_DATA_JUN_2005:APOLLO_TRACK_TS,\ • ………… • P_WKP_DATA_SEP_2010:PALLAS_TS,\ • P_WKP_DATA_OCT_2010:PALLAS_TS,\

  27. Index and Constraints SQL • remap_tablespace= • A_HGU_DATA_APR_2006:APOLLO_TS,\ • A_HGU_DATA_MAY_2006:APOLLO_TS,\ • ………… • A_JUR_INDX_AUG_2011:APOLLO_TS,\ • A_JUR_INDX_SEP_2011:APOLLO_TS,\ • ………… • A_TRK_DATA_MAY_2005:APOLLO_TRACK_TS,\ • A_TRK_DATA_JUN_2005:APOLLO_TRACK_TS,\ • ………… • P_WKP_DATA_SEP_2010:PALLAS_TS,\ • P_WKP_DATA_OCT_2010:PALLAS_TS,\

  28. Index and Constraints SQL • remap_tablespace= • A_HGU_DATA_APR_2006:APOLLO_TS,\ • A_HGU_DATA_MAY_2006:APOLLO_TS,\ • ………… • A_JUR_INDX_AUG_2011:APOLLO_TS,\ • A_JUR_INDX_SEP_2011:APOLLO_TS,\ • ………… • A_TRK_DATA_MAY_2005:APOLLO_TRACK_TS,\ • A_TRK_DATA_JUN_2005:APOLLO_TRACK_TS,\ • ………… • P_WKP_DATA_SEP_2010:PALLAS_TS,\ • P_WKP_DATA_OCT_2010:PALLAS_TS,\

  29. Data Pump Import • undo_retention • Start Streams Capture on Old Database

  30. Data Pump Import • impdp username parfile=table_data.par • table_data.par: • directory=exports • logfile=imp_table_data.log • parallel=4 • network_link=solarisdb • flashback_scn=195203110042 • table_exists_action=APPEND • exclude=statistics,constraint,\ • ref_constraint,index,index_statistics • schemas=apollo,hera,pallas,\ • dbell,jknowles,staylor,glloyd,\ • ………… continued on next slide

  31. Data Pump Import • impdp username parfile=table_data.par • table_data.par: • directory=exports • logfile=imp_table_data.log • parallel=4 • network_link=solarisdb • flashback_scn=195203110042 • table_exists_action=APPEND • exclude=statistics,constraint,\ • ref_constraint,index,index_statistics • schemas=apollo,hera,pallas,\ • dbell,jknowles,staylor,glloyd,\ • ………… continued on next slide

  32. Data Pump Import • impdp username parfile=table_data.par • table_data.par: • directory=exports • logfile=imp_table_data.log • parallel=4 • network_link=solarisdb • flashback_scn=195203110042 • table_exists_action=APPEND • exclude=statistics,constraint,\ • ref_constraint,index,index_statistics • schemas=apollo,hera,pallas,\ • dbell,jknowles,staylor,glloyd,\ • ………… continued on next slide

  33. Data Pump Import • impdp username parfile=table_data.par • table_data.par: • directory=exports • logfile=imp_table_data.log • parallel=4 • network_link=solarisdb • flashback_scn=195203110042 • table_exists_action=APPEND • exclude=statistics,constraint,\ • ref_constraint,index,index_statistics • schemas=apollo,hera,pallas,\ • dbell,jknowles,staylor,glloyd,\ • ………… continued on next slide

  34. Data Pump Import • impdp username parfile=table_data.par • table_data.par: • directory=exports • logfile=imp_table_data.log • parallel=4 • network_link=solarisdb • flashback_scn=195203110042 • table_exists_action=APPEND • exclude=statistics,constraint,\ • ref_constraint,index,index_statistics • schemas=apollo,hera,pallas,\ • dbell,jknowles,staylor,glloyd,\ • ………… continued on next slide

  35. Data Pump Import • remap_tablespace= • A_HGU_DATA_APR_2006:APOLLO_TS,\ • A_HGU_DATA_MAY_2006:APOLLO_TS,\ • ………… • A_JUR_INDX_AUG_2011:APOLLO_TS,\ • A_JUR_INDX_SEP_2011:APOLLO_TS,\ • ………… • A_TRK_DATA_MAY_2005:APOLLO_TRACK_TS,\ • A_TRK_DATA_JUN_2005:APOLLO_TRACK_TS,\ • ………… • P_WKP_DATA_SEP_2010:PALLAS_TS,\ • P_WKP_DATA_OCT_2010:PALLAS_TS,\

  36. Post Import Tasks • Create triggers for 2 precreated tables • Run sqlfile created by first import (indexes and constraints) • Copy sequences from Solaris DR Database

  37. Oracle Streams • Define Streams Apply Processes • Set Schema Instantiation SCN • Start Streams Apply Processes • Set Up Streams from New Database to Old Database

  38. Solaris Production Solaris DR

  39. Solaris Production Solaris DR Linux Production

  40. Solaris Production Solaris DR Linux Production

  41. Solaris Production Solaris DR Linux Production

  42. Solaris Production Solaris DR Linux Production Linux DR

  43. Solaris Production Solaris DR Linux Production Linux DR

  44. Solaris Production Solaris DR Linux Production Linux DR

  45. Solaris Production Solaris DR Linux Production Linux DR

  46. Solaris Production Solaris DR Linux Production Linux DR

More Related