Buenas pra todos que acompanham nossas postagens aqui!
Vou explicar aqui, brevemente, a estratégia utilizada para a migração do ambiente de um cliente.

Cenário antigo:
O.S. 64bit
Oracle 9i 32bit enterprise (banco 32 em o.s. 64...)
Tamanho inicial do banco:
[et_pb_dmb_code_snippet _builder_version=”4.0.6″ code=”VGFtYW5obyBkbyBCYW5jIEVzcGFjbyBVdGlsaXphZCBFc3BhY28gTGl2cmUKLS0tLS0tLS0tLS0tLS0tIC0tLS0tLS0tLS0tLS0tLSAtLS0tLS0tLS0tLS0tLS0KNjk0NzgyIE1CICAgICAgIDU2NzIzNSBNQiAgICAgICAxMjc1NDcgTUIKCmZyZWUgLW0KICAgICAgICAgICAgIHRvdGFsICAgICAgIHVzZWQgICAgICAgZnJlZSAgICAgc2hhcmVkICAgIGJ1ZmZlcnMgICAgIGNhY2hlZApNZW06ICAgICAgICAgNjQ0MjIgICAgICA2NDIxMSAgICAgICAgMjExICAgICAgICAgIDAgICAgICAgIDMxMSAgICAgIDU2ODg5Ci0vKyBidWZmZXJzL2NhY2hlOiAgICAgICA3MDEwICAgICAgNTc0MTIKU3dhcDogICAgICAgIDE3NDA2ICAgICAgICAxMjcgICAgICAxNzI3OAo=” hover_enabled=”0″]VGFtYW5obyBkbyBCYW5jIEVzcGFjbyBVdGlsaXphZCBFc3BhY28gTGl2cmUKLS0tLS0tLS0tLS0tLS0tIC0tLS0tLS0tLS0tLS0tLSAtLS0tLS0tLS0tLS0tLS0KNjk0NzgyIE1CICAgICAgIDU2NzIzNSBNQiAgICAgICAxMjc1NDcgTUIKCmZyZWUgLW0KICAgICAgICAgICAgIHRvdGFsICAgICAgIHVzZWQgICAgICAgZnJlZSAgICAgc2hhcmVkICAgIGJ1ZmZlcnMgICAgIGNhY2hlZApNZW06ICAgICAgICAgNjQ0MjIgICAgICA2NDIxMSAgICAgICAgMjExICAgICAgICAgIDAgICAgICAgIDMxMSAgICAgIDU2ODg5Ci0vKyBidWZmZXJzL2NhY2hlOiAgICAgICA3MDEwICAgICAgNTc0MTIKU3dhcDogICAgICAgIDE3NDA2ICAgICAgICAxMjcgICAgICAxNzI3OAo=[/et_pb_dmb_code_snippet]
Dois Intel(R) Xeon(R) CPU X5570  @ 2.93GHz quad-core, com HT,
atuando como 16 cores
Cenário desejado:
O.S. 64bit
Oracle 11g 64bit enterprise (em matriz suportada pela Oracle...)
Tamanho final do banco:
[et_pb_dmb_code_snippet _builder_version=”4.0.6″ code=”VGFtYW5obyBkbyBCYW5jIEVzcGFjbyBVdGlsaXphZCBFc3BhY28gTGl2cmUKLS0tLS0tLS0tLS0tLS0tIC0tLS0tLS0tLS0tLS0tLSAtLS0tLS0tLS0tLS0KNDAwMzg2IE1CICAgICAgIDM3MDY1OCBNQiAgICAgICAyOTcyOCBNQgoKZnJlZSAtbQogICAgICAgICAgICAgdG90YWwgICAgICAgdXNlZCAgICAgICBmcmVlICAgICBzaGFyZWQgICAgYnVmZmVycyAgICAgY2FjaGVkCk1lbTogICAgICAgIDEyOTA2MCAgICAgMTI4NjcwICAgICAgICAzODkgICAgICAgICAgMCAgICAgICAgMzIzICAgICAgMjUyNTAKLS8rIGJ1ZmZlcnMvY2FjaGU6ICAgICAxMDMwOTcgICAgICAyNTk2MgpTd2FwOiAgICAgICAgMTYzNzggICAgICAgICA2MyAgICAgIDE2MzE1″ hover_enabled=”0″]VGFtYW5obyBkbyBCYW5jIEVzcGFjbyBVdGlsaXphZCBFc3BhY28gTGl2cmUKLS0tLS0tLS0tLS0tLS0tIC0tLS0tLS0tLS0tLS0tLSAtLS0tLS0tLS0tLS0KNDAwMzg2IE1CICAgICAgIDM3MDY1OCBNQiAgICAgICAyOTcyOCBNQgoKZnJlZSAtbQogICAgICAgICAgICAgdG90YWwgICAgICAgdXNlZCAgICAgICBmcmVlICAgICBzaGFyZWQgICAgYnVmZmVycyAgICAgY2FjaGVkCk1lbTogICAgICAgIDEyOTA2MCAgICAgMTI4NjcwICAgICAgICAzODkgICAgICAgICAgMCAgICAgICAgMzIzICAgICAgMjUyNTAKLS8rIGJ1ZmZlcnMvY2FjaGU6ICAgICAxMDMwOTcgICAgICAyNTk2MgpTd2FwOiAgICAgICAgMTYzNzggICAgICAgICA2MyAgICAgIDE2MzE1[/et_pb_dmb_code_snippet]
Dois Intel(R) Xeon(R) CPU X5670  @ 2.93GHz six-core, com HT,
atuando como 24 cores

* A janela disponível para a migração era de 4hs;
* Não podíamos utilizar o ‘upgrade’ pois o banco 9i já teve vários sinistros e não queríamos corrupções e vícios;
* Um SCHEMA corresponde a praticamente 80% do tamanho final do bd;
* Aproveitando o poderío do hardware (proc + mem + I/O) a chave para otimizar o processo foi… paralelizar ao máximo! 🙂
* Desta forma chegamos a seguinte estratégia de migração:
A- Preparação da base no dia anterior:

[et_pb_dmb_code_snippet _builder_version=”4.0.6″ code=”4oCTIExpbXBlemEgKGRyb3AgZGF0YWJhc2UpIGRhIGJhc2UgdXRpbGl6YWRhIHBhcmEgaW7Dum1lcm9zIHRlc3RlczsK4oCTIExpbXBlemEgZG9zIGxvZ3MgZG9zIHNjcmlwdHMgc2hlbGwgZGVzZW52b2x2aWRvcyBwYXJhIGEgbWlncmHDp8OjbzsK4oCTIENyaWHDp8OjbyBkbyBiYW5jbyBjb25mb3JtZSBhIHByb2R1w6fDo28gOWksIGNvbSBhcyB0YWJsZXNwYWNlcyBqw6EgcHLDqS1hbG9jYWRhcyBubyB0YW1hbmhvIGZpbmFsOwrigJMgRXhwb3J0IGZ1bGwgcm93cz1uIGEgcGFydGlyIGRhIHByb2R1w6fDo28gOWk7CuKAkyBJbXBvcnQgZnVsbCByb3dzPW4gaWdub3JlPXkgaW5kZXhlcz1uIGNvbnN0cmFpbnRzPW4gcGFyYSBhIGNyaWHDp8OjbyBkb3MgdXN1w6FyaW9zIGUgaW1wb3J0IGRvcyBvYmpldG9zIGUgZXN0cnV0dXJhIGRlIHRhYmVsYXM7CuKAkyBDcmlhw6fDo28gZGUgZGJfbGluayBlbnRyZSBhcyBiYXNlcyAxMWcgZSA5aSBlIGFqdXN0ZSBkb3MgZ3JhbnRzIGRvIHN5cyBwYXJhIHVzdcOhcmlvcyAodiRzZXNzaW9uLCB2JGluc3RhbmNl4oCmKQrigJMgQ29tcGlsYcOnw6NvIGRvcyBvYmpldG9zIGludsOhbGlkb3MgKHV0bHJwLnNxbCk7CuKAkyBEaXNhYmxlIGRhcyB0cmlnZ2VycyBlIGRyb3AgZGFzIHNlcXVlbmNlczsK4oCTIEFsdGVyIHRhYmxlIHNldGFuZG8gbyBkZWdyZWUgcGFyYSA2MCBkYXMgMjAgbWFpb3JlcyB0YWJlbGFzIChwYXJhIGhhYmlsaXRhciBjb25zdHJhaW50cyBlbSBwYXJhbGxlbCk7CuKAkyBTY3JpcHQgZGUgY29tcGFyYcOnw6NvIGRlIG9iamV0b3MgZW50cmUgYXMgaW5zdGFuY2VzIDlpIGUgMTFnIChpZ25vcmFuZG8gYSBkaWZlcmVuw6dhIGRhcyBzZXF1ZW5jZXMgZHJvcGFkYXMpLg==” hover_enabled=”0″]4oCTIExpbXBlemEgKGRyb3AgZGF0YWJhc2UpIGRhIGJhc2UgdXRpbGl6YWRhIHBhcmEgaW7Dum1lcm9zIHRlc3RlczsK4oCTIExpbXBlemEgZG9zIGxvZ3MgZG9zIHNjcmlwdHMgc2hlbGwgZGVzZW52b2x2aWRvcyBwYXJhIGEgbWlncmHDp8OjbzsK4oCTIENyaWHDp8OjbyBkbyBiYW5jbyBjb25mb3JtZSBhIHByb2R1w6fDo28gOWksIGNvbSBhcyB0YWJsZXNwYWNlcyBqw6EgcHLDqS1hbG9jYWRhcyBubyB0YW1hbmhvIGZpbmFsOwrigJMgRXhwb3J0IGZ1bGwgcm93cz1uIGEgcGFydGlyIGRhIHByb2R1w6fDo28gOWk7CuKAkyBJbXBvcnQgZnVsbCByb3dzPW4gaWdub3JlPXkgaW5kZXhlcz1uIGNvbnN0cmFpbnRzPW4gcGFyYSBhIGNyaWHDp8OjbyBkb3MgdXN1w6FyaW9zIGUgaW1wb3J0IGRvcyBvYmpldG9zIGUgZXN0cnV0dXJhIGRlIHRhYmVsYXM7CuKAkyBDcmlhw6fDo28gZGUgZGJfbGluayBlbnRyZSBhcyBiYXNlcyAxMWcgZSA5aSBlIGFqdXN0ZSBkb3MgZ3JhbnRzIGRvIHN5cyBwYXJhIHVzdcOhcmlvcyAodiRzZXNzaW9uLCB2JGluc3RhbmNl4oCmKQrigJMgQ29tcGlsYcOnw6NvIGRvcyBvYmpldG9zIGludsOhbGlkb3MgKHV0bHJwLnNxbCk7CuKAkyBEaXNhYmxlIGRhcyB0cmlnZ2VycyBlIGRyb3AgZGFzIHNlcXVlbmNlczsK4oCTIEFsdGVyIHRhYmxlIHNldGFuZG8gbyBkZWdyZWUgcGFyYSA2MCBkYXMgMjAgbWFpb3JlcyB0YWJlbGFzIChwYXJhIGhhYmlsaXRhciBjb25zdHJhaW50cyBlbSBwYXJhbGxlbCk7CuKAkyBTY3JpcHQgZGUgY29tcGFyYcOnw6NvIGRlIG9iamV0b3MgZW50cmUgYXMgaW5zdGFuY2VzIDlpIGUgMTFnIChpZ25vcmFuZG8gYSBkaWZlcmVuw6dhIGRhcyBzZXF1ZW5jZXMgZHJvcGFkYXMpLg==[/et_pb_dmb_code_snippet]

B- Upgrade day!!! Start 0h e 25m do dia 18/03/2012

[et_pb_dmb_code_snippet _builder_version=”4.0.6″ code=”4oCUIEZvcmFtIHNlcGFyYWRvcyA0IFNDSEVNQVMgZGVub21pbmFkb3Mg4oCYYmlnIG93bmVyc+KAmSBlIG91dHJvIFNDSEVNQSBkZW5vbWluYWRvIOKAmG1hc3RlciBvd25lcuKAmSwgZXN0ZXMgU0NIRU1BUyBuw6NvIHNlcmlhIG1pZ3JhZG9zIHZpYSBleHAvaW1wIGUgc2ltIHZpYSBkYl9saW5rLCByZWR1emluZG8gZHJhc3RpY2FtZW50ZSBvIHRlbXBvIGRlIG1pZ3Jhw6fDo28hCuKAkyBFeHAgaW5kZXhlcz15IGNvbnN0cmFpbnRzPXkgZG8gcmVzdGFudGUgZG9zIFNDSEVNQVM7CuKAkyBQYXJhbGVsbyBhbyBwYXNzbyBhY2ltYSBmb3JhbSBkaXNwYXJhZG9zIG9zIHNlZ3VpbnRlcyBzY3JpcHRzOgrigJQgSW5zZXJ0IHZpYSBkYl9saW5rIChJTlNFUlQgLyorIEFQUEVORCBQYXJhbGxlbChBLDYpICovKSBwYXJhIHRvZGFzIGFzIHRhYmVsYXMgZG9zIOKAmGJpZyBvd25lcnPigJksIGNyZWF0ZSBkb3MgaW5kZXhlcyAocGFyYWxsZWwgNjApIGUgY3JlYXRlIGRhcyBjaGVjayBjb25zdHJhaW50czsK4oCUIFBhcmEgbyDigJhtYXN0ZXIgb3duZXLigJkgZm9pIHV0aWxpemFkbyBvdXRybyBuw612ZWwgYWluZGEgZGUgcGFyYWxlbGlzbW8gZGl2aWRpbmRvIG9zIHByb2Nlc3NvcyBlbSAxMCBzY3JpcHRzIHBhcmEgaW5zZXJ0IHZpYSBkYl9saW5rIGUgY3JlYXRlIGluZGV4IChwYXJhbGxlbCA2MCkgZGFzIG1haW9yZXMgdGFiZWxhcyBlIG91dHJvcyAyIHNjcmlwdHMgb25kZSBmb3JhbSBkaXZpZGlkYXMgbyByZXN0YW50ZSBkYXMgdGFiZWxhcyBkbyDigJhtYXN0ZXIgb3duZXLigJkgKGluc2VydCBkYl9saW5rK2NyZWF0ZSBpbmRleCtjcmVhdGUgY29uc3RyYWludCkK4oCTIEFww7NzIHTDqXJtaW5vIGRvIGV4cCBkb3MgU0NIRU1BUywgZGlzcGFybyBkZSBmb3JtYSBwYXJhbGVsYSBkbyBpbXAgZGUgdG9kb3Mgb3MgZHVtcHMgaW5kZXhlcz15IGNvbnN0cmFpbnRzPW4K4oCTIEFww7NzIHTDqXJtaW5vIGRvcyBpbXBzIGRpc3Bhcm8gZGUgc2NyaXB0IHBhcmEgY3JpYcOnw6NvIGRhcyBjb25zdHJhaW50cyAoUEsgZSBVSykgZGUgdG9kb3Mgb3MgU0NIRU1BUzsK4oCTIEFww7NzIG9zIGluc2VydHMgdmlhIGRiX2xpbmssIGRpc3Bhcm8gZGUgc2NyaXB0IHBhcmEgY3JpYcOnw6NvIGRhcyBjb25zdHJhaW50cyAoUEsgZSBVSykgZG8g4oCYbWFzdGVyIG93bmVy4oCZOwrigJMgRG9pcyBkaXNwYXJvcyBkZSBpbXBzIGRvcyBTQ0hFTUFTIGRlIGZvcm1hIHNlcmlhbGl6YWRhIHBhcmEgZW5hYmxlIGRhcyBjb25zdHJhaW50cyByb3dzPW4gY29uc3RyYWludHN5OwrigJMgw5psdGltbyBpbXBvcnQgZnVsbCBpbmRleGVzPXkgcm93cz1uIGlnbm9yZT15IGNvbnN0cmFpbnRzPXkgcGFyYSBxdWUgZm9zc2VtIGNyaWFkb3MgcXVhaXNxdWVyIGluZGV4ZXMgcXVlIHRpdmVzc2VtIGZhbHRhZG8gZS9vdSBjb25zdHJhaW50czsK4oCTIEFqdXN0ZSBkb3MgcGFyw6JtZXRyb3M6CmFsdGVyIHN5c3RlbSBzZXQgcGFyYWxsZWxfbWF4X3NlcnZlcnM9MTIgc2NvcGU9Ym90aDsKYWx0ZXIgc3lzdGVtIHNldCBvcHRpbWl6ZXJfaW5kZXhfY29zdF9hZGogPSAzMCBzY29wZT1ib3RoOwphbHRlciBzeXN0ZW0gc2V0IG9wdGltaXplcl9pbmRleF9jYWNoaW5nID0gOTAgc2NvcGUgPSBib3RoOwrigJMgRGlzYWJsZSBkbyBkZWdyZWUgcGFyYSBhcyAyMCBtYWlvcmVzIHRhYmVsYXMgZSBwYXJhIG9zIGluZGV4ZXMgY3JpYWRvcyBjb20gcGFyYWxsZWwgNjA7CuKAkyBFbmFibGUgZGFzIHRyaWdnZXJzOwrigJMgSW1wb3J0IGRhcyBlc3RhdMOtc3RpY2FzIGRvIGJhbmNvIDlpOwrigJMgQ29tcGFyYcOnw6NvIGRvcyBvYmpldG9zIGVudHJlIGFzIGluc3RhbmNlcyA5aSBlIDExZywgYWdvcmEgasOhIGxldmFuZG8gZW0gY29udGEgYXMgc2VxdWVuY2VzIGFqdXN0YWRhcyBub3Mgw7psdGltb3MgaW1wb3J0cyByZWFsaXphZG9zOwrigJMgU2NyaXB0IHBhcmEgY29tcGFyYcOnw6NvIGRlIHF1YW50aWRhZGUvc3RhdHVzIGRhcyBjb25zdHJhaW50cyBlbnRyZSBhcyBpbnN0YW5jZXMgOWkgZSAxMWc7CuKAkyBDb21wYXJhw6fDo28gZG9zIGpvYnMgZW50cmUgYXMgaW5zdGFuY2VzIDlpIGUgMTFnOwrigJMgQ29tcGlsYcOnw6NvIGRvcyBvYmpldG9zIGludsOhbGlkb3MgKHV0bHJwLnNxbCk7CuKAkyBTY3JpcHQgZGUgY29tcGFyYcOnw6NvIGRlIGRhZG9zIGVudHJlIGluc3RhbmNlcywgb3Ugc2VqYSwgZmF6aWEgdW0gc2VsZWN0IGNvdW50KCopIGZyb20gdGFiZWxhIHdoZXJlIHJvd251bSA9IDEgbm8gOWkgZSBmYXppYSBvIG1lc21vIG5vIDExZywgY2FzbyBob3V2ZXNzZSBkaWZlcmVuw6dhIGxvZ2F2YSBlbSB1bWEgdGFiZWxhLiBDb20gaXNzbyBwb2RlcsOtYW1vcyB2ZXIgcXVhbHF1ZXIgdGFiZWxhIHF1ZSBuw6NvIHRpdmVzc2Ugc2lkbyBjYXJyZWdhZGEsIHRlbmRvIGRhZG9zIG5hIG9yaWdlbSwgbWFzIG7Do28gbm8gZGVzdGluby4=” hover_enabled=”0″]4oCUIEZvcmFtIHNlcGFyYWRvcyA0IFNDSEVNQVMgZGVub21pbmFkb3Mg4oCYYmlnIG93bmVyc+KAmSBlIG91dHJvIFNDSEVNQSBkZW5vbWluYWRvIOKAmG1hc3RlciBvd25lcuKAmSwgZXN0ZXMgU0NIRU1BUyBuw6NvIHNlcmlhIG1pZ3JhZG9zIHZpYSBleHAvaW1wIGUgc2ltIHZpYSBkYl9saW5rLCByZWR1emluZG8gZHJhc3RpY2FtZW50ZSBvIHRlbXBvIGRlIG1pZ3Jhw6fDo28hCuKAkyBFeHAgaW5kZXhlcz15IGNvbnN0cmFpbnRzPXkgZG8gcmVzdGFudGUgZG9zIFNDSEVNQVM7CuKAkyBQYXJhbGVsbyBhbyBwYXNzbyBhY2ltYSBmb3JhbSBkaXNwYXJhZG9zIG9zIHNlZ3VpbnRlcyBzY3JpcHRzOgrigJQgSW5zZXJ0IHZpYSBkYl9saW5rIChJTlNFUlQgLyorIEFQUEVORCBQYXJhbGxlbChBLDYpICovKSBwYXJhIHRvZGFzIGFzIHRhYmVsYXMgZG9zIOKAmGJpZyBvd25lcnPigJksIGNyZWF0ZSBkb3MgaW5kZXhlcyAocGFyYWxsZWwgNjApIGUgY3JlYXRlIGRhcyBjaGVjayBjb25zdHJhaW50czsK4oCUIFBhcmEgbyDigJhtYXN0ZXIgb3duZXLigJkgZm9pIHV0aWxpemFkbyBvdXRybyBuw612ZWwgYWluZGEgZGUgcGFyYWxlbGlzbW8gZGl2aWRpbmRvIG9zIHByb2Nlc3NvcyBlbSAxMCBzY3JpcHRzIHBhcmEgaW5zZXJ0IHZpYSBkYl9saW5rIGUgY3JlYXRlIGluZGV4IChwYXJhbGxlbCA2MCkgZGFzIG1haW9yZXMgdGFiZWxhcyBlIG91dHJvcyAyIHNjcmlwdHMgb25kZSBmb3JhbSBkaXZpZGlkYXMgbyByZXN0YW50ZSBkYXMgdGFiZWxhcyBkbyDigJhtYXN0ZXIgb3duZXLigJkgKGluc2VydCBkYl9saW5rK2NyZWF0ZSBpbmRleCtjcmVhdGUgY29uc3RyYWludCkK4oCTIEFww7NzIHTDqXJtaW5vIGRvIGV4cCBkb3MgU0NIRU1BUywgZGlzcGFybyBkZSBmb3JtYSBwYXJhbGVsYSBkbyBpbXAgZGUgdG9kb3Mgb3MgZHVtcHMgaW5kZXhlcz15IGNvbnN0cmFpbnRzPW4K4oCTIEFww7NzIHTDqXJtaW5vIGRvcyBpbXBzIGRpc3Bhcm8gZGUgc2NyaXB0IHBhcmEgY3JpYcOnw6NvIGRhcyBjb25zdHJhaW50cyAoUEsgZSBVSykgZGUgdG9kb3Mgb3MgU0NIRU1BUzsK4oCTIEFww7NzIG9zIGluc2VydHMgdmlhIGRiX2xpbmssIGRpc3Bhcm8gZGUgc2NyaXB0IHBhcmEgY3JpYcOnw6NvIGRhcyBjb25zdHJhaW50cyAoUEsgZSBVSykgZG8g4oCYbWFzdGVyIG93bmVy4oCZOwrigJMgRG9pcyBkaXNwYXJvcyBkZSBpbXBzIGRvcyBTQ0hFTUFTIGRlIGZvcm1hIHNlcmlhbGl6YWRhIHBhcmEgZW5hYmxlIGRhcyBjb25zdHJhaW50cyByb3dzPW4gY29uc3RyYWludHN5OwrigJMgw5psdGltbyBpbXBvcnQgZnVsbCBpbmRleGVzPXkgcm93cz1uIGlnbm9yZT15IGNvbnN0cmFpbnRzPXkgcGFyYSBxdWUgZm9zc2VtIGNyaWFkb3MgcXVhaXNxdWVyIGluZGV4ZXMgcXVlIHRpdmVzc2VtIGZhbHRhZG8gZS9vdSBjb25zdHJhaW50czsK4oCTIEFqdXN0ZSBkb3MgcGFyw6JtZXRyb3M6CmFsdGVyIHN5c3RlbSBzZXQgcGFyYWxsZWxfbWF4X3NlcnZlcnM9MTIgc2NvcGU9Ym90aDsKYWx0ZXIgc3lzdGVtIHNldCBvcHRpbWl6ZXJfaW5kZXhfY29zdF9hZGogPSAzMCBzY29wZT1ib3RoOwphbHRlciBzeXN0ZW0gc2V0IG9wdGltaXplcl9pbmRleF9jYWNoaW5nID0gOTAgc2NvcGUgPSBib3RoOwrigJMgRGlzYWJsZSBkbyBkZWdyZWUgcGFyYSBhcyAyMCBtYWlvcmVzIHRhYmVsYXMgZSBwYXJhIG9zIGluZGV4ZXMgY3JpYWRvcyBjb20gcGFyYWxsZWwgNjA7CuKAkyBFbmFibGUgZGFzIHRyaWdnZXJzOwrigJMgSW1wb3J0IGRhcyBlc3RhdMOtc3RpY2FzIGRvIGJhbmNvIDlpOwrigJMgQ29tcGFyYcOnw6NvIGRvcyBvYmpldG9zIGVudHJlIGFzIGluc3RhbmNlcyA5aSBlIDExZywgYWdvcmEgasOhIGxldmFuZG8gZW0gY29udGEgYXMgc2VxdWVuY2VzIGFqdXN0YWRhcyBub3Mgw7psdGltb3MgaW1wb3J0cyByZWFsaXphZG9zOwrigJMgU2NyaXB0IHBhcmEgY29tcGFyYcOnw6NvIGRlIHF1YW50aWRhZGUvc3RhdHVzIGRhcyBjb25zdHJhaW50cyBlbnRyZSBhcyBpbnN0YW5jZXMgOWkgZSAxMWc7CuKAkyBDb21wYXJhw6fDo28gZG9zIGpvYnMgZW50cmUgYXMgaW5zdGFuY2VzIDlpIGUgMTFnOwrigJMgQ29tcGlsYcOnw6NvIGRvcyBvYmpldG9zIGludsOhbGlkb3MgKHV0bHJwLnNxbCk7CuKAkyBTY3JpcHQgZGUgY29tcGFyYcOnw6NvIGRlIGRhZG9zIGVudHJlIGluc3RhbmNlcywgb3Ugc2VqYSwgZmF6aWEgdW0gc2VsZWN0IGNvdW50KCopIGZyb20gdGFiZWxhIHdoZXJlIHJvd251bSA9IDEgbm8gOWkgZSBmYXppYSBvIG1lc21vIG5vIDExZywgY2FzbyBob3V2ZXNzZSBkaWZlcmVuw6dhIGxvZ2F2YSBlbSB1bWEgdGFiZWxhLiBDb20gaXNzbyBwb2RlcsOtYW1vcyB2ZXIgcXVhbHF1ZXIgdGFiZWxhIHF1ZSBuw6NvIHRpdmVzc2Ugc2lkbyBjYXJyZWdhZGEsIHRlbmRvIGRhZG9zIG5hIG9yaWdlbSwgbWFzIG7Do28gbm8gZGVzdGluby4=[/et_pb_dmb_code_snippet]

Ufaaaaa… acreditem se quiser senhores… com esse controle todo, esse paralelismo todo, e tirando todo o proveito do ótimo hardware oferecido, fomos capazes de migrar essa base em 200 minutos.

A máquina em certos momentos atingiu um L.A. de 142… hehehehe, principalmente durante a criação dos indexes com paralell 60 e enable das constraints. Chegavam a existir em certo momento 260 processos slave no banco. (evil… hehehehe)

Então foi isso, gostaria de compartilhar essa experiência com todos… foi um ótimo aprendizado e exigiu muito controle e log de tudo, mas otimizou demais o processo!
Qualquer dúvida, maiores explicações ou até mesmo sugestões de como eu poderia ter melhorado o processo, por favor comentem.
Um grande abraço…

Ps. Amigo Valter, vale uma barra de chocolate se adivinhar qual o cliente e qual a base? 😉

Att,/Regards,

Vitor Jr.
Infraestrutura / Infrastructure Team
Oracle 11g DBA Certified Professional – OCP
Oracle Database 11g Performance Tuning Certified Expert – OCE
Oracle Exadata 11g Certified Implementation Specialist
mail, gtalk e msn: [email protected]
skype: vjunior1981