Buenas! 🙂

Vendo inúmeras perguntas sobre o tema no grupo, e tendo uma atividade do tipo para executar, resolvi documentar passo-a-passo e transformar em um post.

Todo DBA já precisou replicar um banco. Seja ele um banco de PRD para atualizar ambiente de HLG, ou apenas duplicar um banco para executar um teste de aplicação de patch, enfim.

Irei compartilhar aqui minha forma favorita de executar essa tarefa! 🙂

– É necessário que o banco esteja em modo ARCHIVE.

1) Identificar a lista de datafiles do banco de origem:

[et_pb_dmb_code_snippet code=”MTc6MDc6NDEgbm9tZWRiPlNFTEVDVCBuYW1lIEZST00gdiRkYXRhZmlsZTsKCk5BTUUKLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0KL3UwMS9vcmFkYXRhL25vbWVkYi9zeXN0ZW0wMS5vcmEKL3UwMS9vcmFkYXRhL25vbWVkYi91bmRvdGJzMDEuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvZm9ycG9udG9fZGF0YTAxLmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL2Ryc3lzMDEuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvbXhoaXN0b3JpY29fZGF0YS5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9teHJocHJjX2RhdGEub3JhCi91MDEvb3JhZGF0YS9ub21lZGIvbXhyaHByY19pbmRleC5vcmEKL3UwMS9vcmFkYXRhL25vbWVkYi9teHJoX2RhdGEub3JhCi91MDEvb3JhZGF0YS9ub21lZGIvbXhyaF9pbmRleC5vcmEKL3UwMS9vcmFkYXRhL25vbWVkYi9wZXJmc3RhdF9kYXRhMDEub3JhCi91MDEvb3JhZGF0YS9ub21lZGIvc2VwYXRfZGFkb3Mub3JhCi91MDEvb3JhZGF0YS9ub21lZGIvc2VwYXRfaW5kZXgub3JhCi91MDEvb3JhZGF0YS9ub21lZGIvdXNlcnMwMS5vcmEKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhMDEub3JhCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9faW5kZXgwMS5vcmEKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19oaXN0X2RhdGEwMS5vcmEKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19oaXN0X2luZGV4MDEuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YTAyLm9yYQovdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2luZGV4MDIub3JhCi91MDEvb3JhZGF0YS9ub21lZGIvdXNlcnMwMi5vcmEKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhMDMub3JhCi91MDEvb3JhZGF0YS9ub21lZGIvdGVsZW1hdF9pbmRleDAxLmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL3BleHhpX2RhdGEwMS5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wZXh4aV9kYXRhMDIuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvbXhyaF9kYXRhMDIub3JhCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9faW5kZXgwMy5vcmEKL3UwMS9vcmFkYXRhL25vbWVkYi9teHJoX2RhdGEwMy5vcmEKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19pbmRleDA0Lm9yYQovdTAxL29yYWRhdGEvbm9tZWRiL2ltcG9ydF9yaF9kYXRhMDEuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvaW1wb3J0X3JoX2luZGV4MDEuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YTA0Lm9yYQovdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2RhdGEwNS5vcmEKL3UwMS9vcmFkYXRhL25vbWVkYi90ZWxlbWF0X2RhdGEyMDEuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvbXhyaHByY19pbmRleF8wMi5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19pbmRleDA1Lm9yYQovdTAxL29yYWRhdGEvbm9tZWRiL3VuZG90YnMwMi5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9teHJoX2RhdGEwNC5vcmEKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhMDYuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YV83LmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL3RlbGVtYXRfZGF0YTJfMi5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9zeXNhdXgwMS5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9zeXN0ZW1fMi5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi90ZWxlbWF0X2luZGV4MV8wMS5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi90ZWxlbWF0X2RhdGEyXzMuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YV84LmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL3RlbGVtYXRfZGF0YTJfNC5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhXzkuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvbXhyaF9kYXRhXzUuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fYXVkaXQyXzE2LmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL214cmhwcmNfaW5kZXhfMy5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19hdWRpdDJfMTguZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9faW5kZXhfNi5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhXzEwLmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2F1ZGl0Ml8xNy5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wcm9kaWdlb19kYXRhMDEuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fYXVkaXQyXzAxLmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2F1ZGl0Ml8wMi5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19hdWRpdDJfMDMuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fYXVkaXQyXzA0LmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2F1ZGl0Ml8wNS5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19hdWRpdDJfMDYuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fYXVkaXQyXzA3LmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2F1ZGl0Ml8wOC5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19hdWRpdDJfMDkuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fYXVkaXQyXzEwLmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2F1ZGl0Ml8xMS5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19hdWRpdDJfMTIuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fYXVkaXQyXzEzLmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2F1ZGl0Ml8xNC5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19hdWRpdDJfMTUuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YV8xMS5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhXzEyLmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2luZGV4XzcuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YV8xMy5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhXzE0LmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2RhdGFfMTUuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YV8xNi5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhXzE3LmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2luZGV4XzguZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fYXVkaXQyXzE5LmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL214cmhfZGF0YV82LmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2RhdGFfMTguZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YV8xOS5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhXzIwLmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2RhdGFfMjEuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YV8yMi5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19pbmRleF85LmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2RhdGFfMjMuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YV8yNC5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhXzI1LmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2RhdGFfMjYuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YV8yNy5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19pbmRleF8xMC5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhXzI4LmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2RhdGFfMjkuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YV8zMC5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19pbmRleF8xMS5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhXzMxLmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2RhdGFfMzIuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YV8zMy5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhXzM0LmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2RhdGFfMzUuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fYXVkaXQyXzIwLmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2F1ZGl0Ml8yMS5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19pbmRleF8xMi5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19hdWRpdDJfMjIuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fYXVkaXQyXzIzLmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL2RhdGFfREJTTk1QXzAxLmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2F1ZGl0Ml8yNC5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9teHJocHJjX2RhdGFfMDIub3JhCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fYXVkaXQyXzI1LmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2F1ZGl0Ml8yNi5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19pbmRleF8xMy5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19hdWRpdDJfMjcuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9faW5kZXhfMTQuZGJmCgoxMTUgbGluaGFzIHNlbGVjaW9uYWRhcy4KCkRlY29ycmlkbzogMDA6MDA6MDAuNzYKMTc6MDc6NDMgbm9tZWRiPg==” _builder_version=”4.0.6″]MTc6MDc6NDEgbm9tZWRiPlNFTEVDVCBuYW1lIEZST00gdiRkYXRhZmlsZTsKCk5BTUUKLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0KL3UwMS9vcmFkYXRhL25vbWVkYi9zeXN0ZW0wMS5vcmEKL3UwMS9vcmFkYXRhL25vbWVkYi91bmRvdGJzMDEuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvZm9ycG9udG9fZGF0YTAxLmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL2Ryc3lzMDEuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvbXhoaXN0b3JpY29fZGF0YS5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9teHJocHJjX2RhdGEub3JhCi91MDEvb3JhZGF0YS9ub21lZGIvbXhyaHByY19pbmRleC5vcmEKL3UwMS9vcmFkYXRhL25vbWVkYi9teHJoX2RhdGEub3JhCi91MDEvb3JhZGF0YS9ub21lZGIvbXhyaF9pbmRleC5vcmEKL3UwMS9vcmFkYXRhL25vbWVkYi9wZXJmc3RhdF9kYXRhMDEub3JhCi91MDEvb3JhZGF0YS9ub21lZGIvc2VwYXRfZGFkb3Mub3JhCi91MDEvb3JhZGF0YS9ub21lZGIvc2VwYXRfaW5kZXgub3JhCi91MDEvb3JhZGF0YS9ub21lZGIvdXNlcnMwMS5vcmEKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhMDEub3JhCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9faW5kZXgwMS5vcmEKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19oaXN0X2RhdGEwMS5vcmEKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19oaXN0X2luZGV4MDEuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YTAyLm9yYQovdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2luZGV4MDIub3JhCi91MDEvb3JhZGF0YS9ub21lZGIvdXNlcnMwMi5vcmEKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhMDMub3JhCi91MDEvb3JhZGF0YS9ub21lZGIvdGVsZW1hdF9pbmRleDAxLmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL3BleHhpX2RhdGEwMS5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wZXh4aV9kYXRhMDIuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvbXhyaF9kYXRhMDIub3JhCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9faW5kZXgwMy5vcmEKL3UwMS9vcmFkYXRhL25vbWVkYi9teHJoX2RhdGEwMy5vcmEKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19pbmRleDA0Lm9yYQovdTAxL29yYWRhdGEvbm9tZWRiL2ltcG9ydF9yaF9kYXRhMDEuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvaW1wb3J0X3JoX2luZGV4MDEuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YTA0Lm9yYQovdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2RhdGEwNS5vcmEKL3UwMS9vcmFkYXRhL25vbWVkYi90ZWxlbWF0X2RhdGEyMDEuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvbXhyaHByY19pbmRleF8wMi5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19pbmRleDA1Lm9yYQovdTAxL29yYWRhdGEvbm9tZWRiL3VuZG90YnMwMi5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9teHJoX2RhdGEwNC5vcmEKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhMDYuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YV83LmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL3RlbGVtYXRfZGF0YTJfMi5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9zeXNhdXgwMS5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9zeXN0ZW1fMi5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi90ZWxlbWF0X2luZGV4MV8wMS5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi90ZWxlbWF0X2RhdGEyXzMuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YV84LmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL3RlbGVtYXRfZGF0YTJfNC5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhXzkuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvbXhyaF9kYXRhXzUuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fYXVkaXQyXzE2LmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL214cmhwcmNfaW5kZXhfMy5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19hdWRpdDJfMTguZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9faW5kZXhfNi5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhXzEwLmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2F1ZGl0Ml8xNy5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wcm9kaWdlb19kYXRhMDEuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fYXVkaXQyXzAxLmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2F1ZGl0Ml8wMi5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19hdWRpdDJfMDMuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fYXVkaXQyXzA0LmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2F1ZGl0Ml8wNS5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19hdWRpdDJfMDYuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fYXVkaXQyXzA3LmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2F1ZGl0Ml8wOC5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19hdWRpdDJfMDkuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fYXVkaXQyXzEwLmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2F1ZGl0Ml8xMS5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19hdWRpdDJfMTIuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fYXVkaXQyXzEzLmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2F1ZGl0Ml8xNC5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19hdWRpdDJfMTUuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YV8xMS5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhXzEyLmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2luZGV4XzcuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YV8xMy5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhXzE0LmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2RhdGFfMTUuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YV8xNi5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhXzE3LmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2luZGV4XzguZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fYXVkaXQyXzE5LmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL214cmhfZGF0YV82LmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2RhdGFfMTguZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YV8xOS5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhXzIwLmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2RhdGFfMjEuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YV8yMi5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19pbmRleF85LmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2RhdGFfMjMuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YV8yNC5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhXzI1LmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2RhdGFfMjYuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YV8yNy5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19pbmRleF8xMC5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhXzI4LmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2RhdGFfMjkuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YV8zMC5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19pbmRleF8xMS5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhXzMxLmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2RhdGFfMzIuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YV8zMy5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhXzM0LmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2RhdGFfMzUuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fYXVkaXQyXzIwLmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2F1ZGl0Ml8yMS5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19pbmRleF8xMi5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19hdWRpdDJfMjIuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fYXVkaXQyXzIzLmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL2RhdGFfREJTTk1QXzAxLmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2F1ZGl0Ml8yNC5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9teHJocHJjX2RhdGFfMDIub3JhCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fYXVkaXQyXzI1LmRiZgovdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2F1ZGl0Ml8yNi5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19pbmRleF8xMy5kYmYKL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19hdWRpdDJfMjcuZGJmCi91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9faW5kZXhfMTQuZGJmCgoxMTUgbGluaGFzIHNlbGVjaW9uYWRhcy4KCkRlY29ycmlkbzogMDA6MDA6MDAuNzYKMTc6MDc6NDMgbm9tZWRiPg==[/et_pb_dmb_code_snippet]

2) Identificar no banco de origem os últimos archives gerados. Os archives gerados após o ‘begin backup’ são os necessários para aplicar no banco destino e será necessário a cópia dos mesmos. Tome nota da sequence a partir da qual será necessário enviar para o banco destino:

[et_pb_dmb_code_snippet code=”U0VMRUNUIHNlcXVlbmNlIywKVG9fY2hhcihuZXh0X3RpbWUsICdERC1NT04tWVlZWSBISDI0Ok1JOlNTJykKRlJPTSAoU0VMRUNUIHNlcXVlbmNlIywKbmV4dF90aW1lCkZST00gdiRhcmNoaXZlZF9sb2cKT1JERVIgQlkgbmV4dF90aW1lIERFU0MpCldIRVJFIFJPV05VTSA8IDIKLwoKMTk6MTM6MDIgbm9tZWRiPlNFTEVDVCBzZXF1ZW5jZSMsCjE5OjEzOjAyIDIgVG9fY2hhcihuZXh0X3RpbWUsICdERC1NT04tWVlZWSBISDI0Ok1JOlNTJykKMTk6MTM6MDIgMyBGUk9NIChTRUxFQ1Qgc2VxdWVuY2UjLAoxOToxMzowMyA0IG5leHRfdGltZQoxOToxMzowMyA1IEZST00gdiRhcmNoaXZlZF9sb2cKMTk6MTM6MDQgNiBPUkRFUiBCWSBuZXh0X3RpbWUgREVTQykKMTk6MTM6MDQgNyBXSEVSRSBST1dOVU0gPCAyCjE5OjEzOjA1IDggLwoKU0VRVUVOQ0UjIFRPX0NIQVIoTkVYVF9USU1FLCdECi0tLS0tLS0tLS0gLS0tLS0tLS0tLS0tLS0tLS0tLS0KMTgwNzM1IDA3LU5PVi0yMDEyIDE5OjEzOjE0″ _builder_version=”4.0.6″]U0VMRUNUIHNlcXVlbmNlIywKVG9fY2hhcihuZXh0X3RpbWUsICdERC1NT04tWVlZWSBISDI0Ok1JOlNTJykKRlJPTSAoU0VMRUNUIHNlcXVlbmNlIywKbmV4dF90aW1lCkZST00gdiRhcmNoaXZlZF9sb2cKT1JERVIgQlkgbmV4dF90aW1lIERFU0MpCldIRVJFIFJPV05VTSA8IDIKLwoKMTk6MTM6MDIgbm9tZWRiPlNFTEVDVCBzZXF1ZW5jZSMsCjE5OjEzOjAyIDIgVG9fY2hhcihuZXh0X3RpbWUsICdERC1NT04tWVlZWSBISDI0Ok1JOlNTJykKMTk6MTM6MDIgMyBGUk9NIChTRUxFQ1Qgc2VxdWVuY2UjLAoxOToxMzowMyA0IG5leHRfdGltZQoxOToxMzowMyA1IEZST00gdiRhcmNoaXZlZF9sb2cKMTk6MTM6MDQgNiBPUkRFUiBCWSBuZXh0X3RpbWUgREVTQykKMTk6MTM6MDQgNyBXSEVSRSBST1dOVU0gPCAyCjE5OjEzOjA1IDggLwoKU0VRVUVOQ0UjIFRPX0NIQVIoTkVYVF9USU1FLCdECi0tLS0tLS0tLS0gLS0tLS0tLS0tLS0tLS0tLS0tLS0KMTgwNzM1IDA3LU5PVi0yMDEyIDE5OjEzOjE0[/et_pb_dmb_code_snippet]

3) Execute o seguinte comando para colocar o banco em modo backup: (em bancos 9i é necessário realizar o comando por tablespace – “ALTER TABLESPACE nome BEGIN BACKUP;”)

[et_pb_dmb_code_snippet code=”MTk6MTQ6MDUgbm9tZWRiPkFMVEVSIERBVEFCQVNFIEJFR0lOIEJBQ0tVUDsKCkJhbmNvIGRlIGRhZG9zIGFsdGVyYWRvLgoKRGVjb3JyaWRvOiAwMDowMDowMC45OAoxOToxNDoxMCBub21lZGI+” _builder_version=”4.0.6″]MTk6MTQ6MDUgbm9tZWRiPkFMVEVSIERBVEFCQVNFIEJFR0lOIEJBQ0tVUDsKCkJhbmNvIGRlIGRhZG9zIGFsdGVyYWRvLgoKRGVjb3JyaWRvOiAwMDowMDowMC45OAoxOToxNDoxMCBub21lZGI+[/et_pb_dmb_code_snippet]

4) Agora os datafiles podem ser copiados para o banco destino:

[et_pb_dmb_code_snippet code=”W3Jvb3RAaG9zdG5hbWUgfl0jIHJzeW5jIC1hdiAtLXByb2dyZXNzIC91MDEvb3JhZGF0YS9ub21lZGIvKiByb290QDE3Mi4xNy4xLjg5Oi91MDEvb3JhZGF0YS9ub21lZGIvCnJvb3RAMTcyLjE3LjEuODkncyBwYXNzd29yZDoKYXJjaF9ub21lZGJfMTY3MjNfMV83MTY1MTU0NDIuYXJjIDEwMCUgNjNNQiAyMS4wTUIvcyAwMDowMwphcmNoX25vbWVkYl8xODA3MDFfMV83MzI3NjE3OTMuYXJjIDEwMCUgNjFNQiAyMC4yTUIvcyAwMDowMwphcmNoX25vbWVkYl8xODA3MDJfMV83MzI3NjE3OTMuYXJjIDEwMCUgNjFNQiAyMC4yTUIvcyAwMDowMwphcmNoX25vbWVkYl8xODA3MDNfMV83MzI3NjE3OTMuYXJjIDEwMCUgNjFNQiAyMC4yTUIvcyAwMDowMwouLi4=” _builder_version=”4.0.6″]W3Jvb3RAaG9zdG5hbWUgfl0jIHJzeW5jIC1hdiAtLXByb2dyZXNzIC91MDEvb3JhZGF0YS9ub21lZGIvKiByb290QDE3Mi4xNy4xLjg5Oi91MDEvb3JhZGF0YS9ub21lZGIvCnJvb3RAMTcyLjE3LjEuODkncyBwYXNzd29yZDoKYXJjaF9ub21lZGJfMTY3MjNfMV83MTY1MTU0NDIuYXJjIDEwMCUgNjNNQiAyMS4wTUIvcyAwMDowMwphcmNoX25vbWVkYl8xODA3MDFfMV83MzI3NjE3OTMuYXJjIDEwMCUgNjFNQiAyMC4yTUIvcyAwMDowMwphcmNoX25vbWVkYl8xODA3MDJfMV83MzI3NjE3OTMuYXJjIDEwMCUgNjFNQiAyMC4yTUIvcyAwMDowMwphcmNoX25vbWVkYl8xODA3MDNfMV83MzI3NjE3OTMuYXJjIDEwMCUgNjFNQiAyMC4yTUIvcyAwMDowMwouLi4=[/et_pb_dmb_code_snippet]

Duas horas depois… 😀

5) Após a cópia, execute o comando para geração de alguns archives no banco origem:

[et_pb_dmb_code_snippet code=”MjE6MTU6MDUgbm9tZWRiPkFMVEVSIFNZU1RFTSBBUkNISVZFIExPRyBDVVJSRU5UOwoKU2lzdGVtYSBhbHRlcmFkby4KCkRlY29ycmlkbzogMDA6MDA6MDEuNjAKMjE6MTU6MTAgbm9tZWRiPkFMVEVSIFNZU1RFTSBBUkNISVZFIExPRyBDVVJSRU5UOwoKU2lzdGVtYSBhbHRlcmFkby4KCkRlY29ycmlkbzogMDA6MDA6MDAuMjkKMjE6MTU6MTEgbm9tZWRiPkFMVEVSIFNZU1RFTSBBUkNISVZFIExPRyBDVVJSRU5UOwoKU2lzdGVtYSBhbHRlcmFkby4KCkRlY29ycmlkbzogMDA6MDA6MDAuMjgKMjE6MTU6MTIgbm9tZWRiPkFMVEVSIERBVEFCQVNFIEVORCBCQUNLVVA7CgpTaXN0ZW1hIGFsdGVyYWRvLgoKRGVjb3JyaWRvOiAwMDowMDowMC40Mg==” _builder_version=”4.0.6″]MjE6MTU6MDUgbm9tZWRiPkFMVEVSIFNZU1RFTSBBUkNISVZFIExPRyBDVVJSRU5UOwoKU2lzdGVtYSBhbHRlcmFkby4KCkRlY29ycmlkbzogMDA6MDA6MDEuNjAKMjE6MTU6MTAgbm9tZWRiPkFMVEVSIFNZU1RFTSBBUkNISVZFIExPRyBDVVJSRU5UOwoKU2lzdGVtYSBhbHRlcmFkby4KCkRlY29ycmlkbzogMDA6MDA6MDAuMjkKMjE6MTU6MTEgbm9tZWRiPkFMVEVSIFNZU1RFTSBBUkNISVZFIExPRyBDVVJSRU5UOwoKU2lzdGVtYSBhbHRlcmFkby4KCkRlY29ycmlkbzogMDA6MDA6MDAuMjgKMjE6MTU6MTIgbm9tZWRiPkFMVEVSIERBVEFCQVNFIEVORCBCQUNLVVA7CgpTaXN0ZW1hIGFsdGVyYWRvLgoKRGVjb3JyaWRvOiAwMDowMDowMC40Mg==[/et_pb_dmb_code_snippet]

6) Execute novamente no banco origem o select do passo 2 para verificar a sequence de archives atual. Os archives gerados entre a sequence do passo 2 e a sequence atual devem ser copiados para o banco destino. Nesse exemplo entre a sequence 180735 e a sequence 180750 conforme exemplo abaixo:

[et_pb_dmb_code_snippet code=”MjE6MTU6MTMgbm9tZWRiPlNFTEVDVCBzZXF1ZW5jZSMsCjIxOjE1OjMzIDIgVG9fY2hhcihuZXh0X3RpbWUsICdERC1NT04tWVlZWSBISDI0Ok1JOlNTJykKMjE6MTU6MzMgMyBGUk9NIChTRUxFQ1Qgc2VxdWVuY2UjLAoyMToxNTozMyA0IG5leHRfdGltZQoyMToxNTozMyA1IEZST00gdiRhcmNoaXZlZF9sb2cKMjE6MTU6MzMgNiBPUkRFUiBCWSBuZXh0X3RpbWUgREVTQykKMjE6MTU6MzMgNyBXSEVSRSBST1dOVU0gPCAyCjIxOjE1OjMzIDggLwoKU0VRVUVOQ0UjIFRPX0NIQVIoTkVYVF9USU1FLCdECi0tLS0tLS0tLS0gLS0tLS0tLS0tLS0tLS0tLS0tLS0KMTgwNzUwIDA3LU5PVi0yMDEyIDIxOjE0OjU4″ _builder_version=”4.0.6″]MjE6MTU6MTMgbm9tZWRiPlNFTEVDVCBzZXF1ZW5jZSMsCjIxOjE1OjMzIDIgVG9fY2hhcihuZXh0X3RpbWUsICdERC1NT04tWVlZWSBISDI0Ok1JOlNTJykKMjE6MTU6MzMgMyBGUk9NIChTRUxFQ1Qgc2VxdWVuY2UjLAoyMToxNTozMyA0IG5leHRfdGltZQoyMToxNTozMyA1IEZST00gdiRhcmNoaXZlZF9sb2cKMjE6MTU6MzMgNiBPUkRFUiBCWSBuZXh0X3RpbWUgREVTQykKMjE6MTU6MzMgNyBXSEVSRSBST1dOVU0gPCAyCjIxOjE1OjMzIDggLwoKU0VRVUVOQ0UjIFRPX0NIQVIoTkVYVF9USU1FLCdECi0tLS0tLS0tLS0gLS0tLS0tLS0tLS0tLS0tLS0tLS0KMTgwNzUwIDA3LU5PVi0yMDEyIDIxOjE0OjU4[/et_pb_dmb_code_snippet]

7) Faça uma cópia do pfile/spfile do banco origem para um pfile no banco destino. Utilizaremos pfile pro caso de ser necessário efetuar alguma alteração, como por exemplo, parâmetros de memória, caminho dos diretórios *dump, o nome do DB, etc…

8) No banco origem criamos um backup do controlfile para um trace com o seguinte comando:

[et_pb_dmb_code_snippet code=”U1FMPiBBTFRFUiBEQVRBQkFTRSBCQUNLVVAgQ09OVFJPTEZJTEUgVE8gVFJBQ0U7CgpEYXRhYmFzZSBhbHRlcmVkLgoKU1FMPg==” _builder_version=”4.0.6″]U1FMPiBBTFRFUiBEQVRBQkFTRSBCQUNLVVAgQ09OVFJPTEZJTEUgVE8gVFJBQ0U7CgpEYXRhYmFzZSBhbHRlcmVkLgoKU1FMPg==[/et_pb_dmb_code_snippet]

O arquivo será gerado no udump (geralmente o último arquivo gerado, verifique com um editor de texto).
Na seção ‘RESETLOGS’ altere a opção ‘REUSE’ para ‘SET’. Caso seja necessário altere o nome do banco, caminho dos redos, datafiles, o que for necessário. Salve esse arquivo como create_control.sql

[et_pb_dmb_code_snippet code=”LS1DUkVBVEUgQ09OVFJPTEZJTEUgUkVVU0UgREFUQUJBU0UgIm5vbWVkYiIgTk9SRVNFVExPR1MgIEFSQ0hJVkVMT0cKIENSRUFURSBDT05UUk9MRklMRSBTRVQgREFUQUJBU0UgIm5vbWVkYiIgUkVTRVRMT0dTIEFSQ0hJVkVMT0cKTUFYTE9HRklMRVMgMzIKTUFYTE9HTUVNQkVSUyAyCk1BWERBVEFGSUxFUyAyNTQKTUFYSU5TVEFOQ0VTIDgKTUFYTE9HSElTVE9SWSAxMTY4NApMT0dGSUxFCkdST1VQIDEgKAonL3UwMS9vcmFkYXRhL25vbWVkYi9yZWRvMDFhLmxvZycsCicvdTAxL29yYWRhdGEvbm9tZWRiL3JlZG8wMWIubG9nJwopIFNJWkUgNjRNLApHUk9VUCAyICgKJy91MDEvb3JhZGF0YS9ub21lZGIvcmVkbzAyYS5sb2cnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9yZWRvMDJiLmxvZycKKSBTSVpFIDY0TSwKR1JPVVAgMyAoCicvdTAxL29yYWRhdGEvbm9tZWRiL3JlZG8wM2EubG9nJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcmVkbzAzYi5sb2cnCikgU0laRSA2NE0sCkdST1VQIDQgKAonL3UwMS9vcmFkYXRhL25vbWVkYi9yZWRvMDRhLmxvZycsCicvdTAxL29yYWRhdGEvbm9tZWRiL3JlZG8wNGIubG9nJwopIFNJWkUgNjRNCi0tIFNUQU5EQlkgTE9HRklMRQpEQVRBRklMRQonL3UwMS9vcmFkYXRhL25vbWVkYi9zeXN0ZW0wMS5vcmEnLAonL3UwMS9vcmFkYXRhL25vbWVkYi91bmRvdGJzMDEuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvZm9ycG9udG9fZGF0YTAxLmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL2Ryc3lzMDEuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvbXhoaXN0b3JpY29fZGF0YS5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9teHJocHJjX2RhdGEub3JhJywKJy91MDEvb3JhZGF0YS9ub21lZGIvbXhyaHByY19pbmRleC5vcmEnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9teHJoX2RhdGEub3JhJywKJy91MDEvb3JhZGF0YS9ub21lZGIvbXhyaF9pbmRleC5vcmEnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wZXJmc3RhdF9kYXRhMDEub3JhJywKJy91MDEvb3JhZGF0YS9ub21lZGIvc2VwYXRfZGFkb3Mub3JhJywKJy91MDEvb3JhZGF0YS9ub21lZGIvc2VwYXRfaW5kZXgub3JhJywKJy91MDEvb3JhZGF0YS9ub21lZGIvdXNlcnMwMS5vcmEnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhMDEub3JhJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9faW5kZXgwMS5vcmEnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19oaXN0X2RhdGEwMS5vcmEnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19oaXN0X2luZGV4MDEuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YTAyLm9yYScsCicvdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2luZGV4MDIub3JhJywKJy91MDEvb3JhZGF0YS9ub21lZGIvdXNlcnMwMi5vcmEnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhMDMub3JhJywKJy91MDEvb3JhZGF0YS9ub21lZGIvdGVsZW1hdF9pbmRleDAxLmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL3BleHhpX2RhdGEwMS5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wZXh4aV9kYXRhMDIuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvbXhyaF9kYXRhMDIub3JhJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9faW5kZXgwMy5vcmEnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9teHJoX2RhdGEwMy5vcmEnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19pbmRleDA0Lm9yYScsCicvdTAxL29yYWRhdGEvbm9tZWRiL2ltcG9ydF9yaF9kYXRhMDEuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvaW1wb3J0X3JoX2luZGV4MDEuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YTA0Lm9yYScsCicvdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2RhdGEwNS5vcmEnLAonL3UwMS9vcmFkYXRhL25vbWVkYi90ZWxlbWF0X2RhdGEyMDEuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvbXhyaHByY19pbmRleF8wMi5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19pbmRleDA1Lm9yYScsCicvdTAxL29yYWRhdGEvbm9tZWRiL3VuZG90YnMwMi5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9teHJoX2RhdGEwNC5vcmEnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhMDYuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YV83LmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL3RlbGVtYXRfZGF0YTJfMi5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9zeXNhdXgwMS5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9zeXN0ZW1fMi5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi90ZWxlbWF0X2luZGV4MV8wMS5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi90ZWxlbWF0X2RhdGEyXzMuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YV84LmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL3RlbGVtYXRfZGF0YTJfNC5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhXzkuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvbXhyaF9kYXRhXzUuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fYXVkaXQyXzE2LmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL214cmhwcmNfaW5kZXhfMy5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19hdWRpdDJfMTguZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9faW5kZXhfNi5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhXzEwLmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2F1ZGl0Ml8xNy5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wcm9kaWdlb19kYXRhMDEuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fYXVkaXQyXzAxLmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2F1ZGl0Ml8wMi5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19hdWRpdDJfMDMuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fYXVkaXQyXzA0LmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2F1ZGl0Ml8wNS5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19hdWRpdDJfMDYuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fYXVkaXQyXzA3LmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2F1ZGl0Ml8wOC5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19hdWRpdDJfMDkuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fYXVkaXQyXzEwLmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2F1ZGl0Ml8xMS5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19hdWRpdDJfMTIuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fYXVkaXQyXzEzLmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2F1ZGl0Ml8xNC5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19hdWRpdDJfMTUuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YV8xMS5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhXzEyLmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2luZGV4XzcuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YV8xMy5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhXzE0LmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2RhdGFfMTUuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YV8xNi5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhXzE3LmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2luZGV4XzguZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fYXVkaXQyXzE5LmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL214cmhfZGF0YV82LmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2RhdGFfMTguZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YV8xOS5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhXzIwLmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2RhdGFfMjEuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YV8yMi5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19pbmRleF85LmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2RhdGFfMjMuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YV8yNC5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhXzI1LmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2RhdGFfMjYuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YV8yNy5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19pbmRleF8xMC5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhXzI4LmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2RhdGFfMjkuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YV8zMC5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19pbmRleF8xMS5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhXzMxLmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2RhdGFfMzIuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YV8zMy5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhXzM0LmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2RhdGFfMzUuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fYXVkaXQyXzIwLmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2F1ZGl0Ml8yMS5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19pbmRleF8xMi5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19hdWRpdDJfMjIuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fYXVkaXQyXzIzLmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL2RhdGFfREJTTk1QXzAxLmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2F1ZGl0Ml8yNC5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9teHJocHJjX2RhdGFfMDIub3JhJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fYXVkaXQyXzI1LmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2F1ZGl0Ml8yNi5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19pbmRleF8xMy5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19hdWRpdDJfMjcuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9faW5kZXhfMTQuZGJmJwpDSEFSQUNURVIgU0VUIFdFOElTTzg4NTlQMQo7″ _builder_version=”4.0.6″]LS1DUkVBVEUgQ09OVFJPTEZJTEUgUkVVU0UgREFUQUJBU0UgIm5vbWVkYiIgTk9SRVNFVExPR1MgIEFSQ0hJVkVMT0cKIENSRUFURSBDT05UUk9MRklMRSBTRVQgREFUQUJBU0UgIm5vbWVkYiIgUkVTRVRMT0dTIEFSQ0hJVkVMT0cKTUFYTE9HRklMRVMgMzIKTUFYTE9HTUVNQkVSUyAyCk1BWERBVEFGSUxFUyAyNTQKTUFYSU5TVEFOQ0VTIDgKTUFYTE9HSElTVE9SWSAxMTY4NApMT0dGSUxFCkdST1VQIDEgKAonL3UwMS9vcmFkYXRhL25vbWVkYi9yZWRvMDFhLmxvZycsCicvdTAxL29yYWRhdGEvbm9tZWRiL3JlZG8wMWIubG9nJwopIFNJWkUgNjRNLApHUk9VUCAyICgKJy91MDEvb3JhZGF0YS9ub21lZGIvcmVkbzAyYS5sb2cnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9yZWRvMDJiLmxvZycKKSBTSVpFIDY0TSwKR1JPVVAgMyAoCicvdTAxL29yYWRhdGEvbm9tZWRiL3JlZG8wM2EubG9nJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcmVkbzAzYi5sb2cnCikgU0laRSA2NE0sCkdST1VQIDQgKAonL3UwMS9vcmFkYXRhL25vbWVkYi9yZWRvMDRhLmxvZycsCicvdTAxL29yYWRhdGEvbm9tZWRiL3JlZG8wNGIubG9nJwopIFNJWkUgNjRNCi0tIFNUQU5EQlkgTE9HRklMRQpEQVRBRklMRQonL3UwMS9vcmFkYXRhL25vbWVkYi9zeXN0ZW0wMS5vcmEnLAonL3UwMS9vcmFkYXRhL25vbWVkYi91bmRvdGJzMDEuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvZm9ycG9udG9fZGF0YTAxLmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL2Ryc3lzMDEuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvbXhoaXN0b3JpY29fZGF0YS5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9teHJocHJjX2RhdGEub3JhJywKJy91MDEvb3JhZGF0YS9ub21lZGIvbXhyaHByY19pbmRleC5vcmEnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9teHJoX2RhdGEub3JhJywKJy91MDEvb3JhZGF0YS9ub21lZGIvbXhyaF9pbmRleC5vcmEnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wZXJmc3RhdF9kYXRhMDEub3JhJywKJy91MDEvb3JhZGF0YS9ub21lZGIvc2VwYXRfZGFkb3Mub3JhJywKJy91MDEvb3JhZGF0YS9ub21lZGIvc2VwYXRfaW5kZXgub3JhJywKJy91MDEvb3JhZGF0YS9ub21lZGIvdXNlcnMwMS5vcmEnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhMDEub3JhJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9faW5kZXgwMS5vcmEnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19oaXN0X2RhdGEwMS5vcmEnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19oaXN0X2luZGV4MDEuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YTAyLm9yYScsCicvdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2luZGV4MDIub3JhJywKJy91MDEvb3JhZGF0YS9ub21lZGIvdXNlcnMwMi5vcmEnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhMDMub3JhJywKJy91MDEvb3JhZGF0YS9ub21lZGIvdGVsZW1hdF9pbmRleDAxLmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL3BleHhpX2RhdGEwMS5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wZXh4aV9kYXRhMDIuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvbXhyaF9kYXRhMDIub3JhJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9faW5kZXgwMy5vcmEnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9teHJoX2RhdGEwMy5vcmEnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19pbmRleDA0Lm9yYScsCicvdTAxL29yYWRhdGEvbm9tZWRiL2ltcG9ydF9yaF9kYXRhMDEuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvaW1wb3J0X3JoX2luZGV4MDEuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YTA0Lm9yYScsCicvdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2RhdGEwNS5vcmEnLAonL3UwMS9vcmFkYXRhL25vbWVkYi90ZWxlbWF0X2RhdGEyMDEuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvbXhyaHByY19pbmRleF8wMi5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19pbmRleDA1Lm9yYScsCicvdTAxL29yYWRhdGEvbm9tZWRiL3VuZG90YnMwMi5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9teHJoX2RhdGEwNC5vcmEnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhMDYuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YV83LmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL3RlbGVtYXRfZGF0YTJfMi5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9zeXNhdXgwMS5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9zeXN0ZW1fMi5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi90ZWxlbWF0X2luZGV4MV8wMS5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi90ZWxlbWF0X2RhdGEyXzMuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YV84LmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL3RlbGVtYXRfZGF0YTJfNC5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhXzkuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvbXhyaF9kYXRhXzUuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fYXVkaXQyXzE2LmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL214cmhwcmNfaW5kZXhfMy5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19hdWRpdDJfMTguZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9faW5kZXhfNi5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhXzEwLmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2F1ZGl0Ml8xNy5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wcm9kaWdlb19kYXRhMDEuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fYXVkaXQyXzAxLmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2F1ZGl0Ml8wMi5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19hdWRpdDJfMDMuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fYXVkaXQyXzA0LmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2F1ZGl0Ml8wNS5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19hdWRpdDJfMDYuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fYXVkaXQyXzA3LmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2F1ZGl0Ml8wOC5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19hdWRpdDJfMDkuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fYXVkaXQyXzEwLmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2F1ZGl0Ml8xMS5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19hdWRpdDJfMTIuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fYXVkaXQyXzEzLmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2F1ZGl0Ml8xNC5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19hdWRpdDJfMTUuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YV8xMS5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhXzEyLmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2luZGV4XzcuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YV8xMy5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhXzE0LmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2RhdGFfMTUuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YV8xNi5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhXzE3LmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2luZGV4XzguZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fYXVkaXQyXzE5LmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL214cmhfZGF0YV82LmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2RhdGFfMTguZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YV8xOS5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhXzIwLmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2RhdGFfMjEuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YV8yMi5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19pbmRleF85LmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2RhdGFfMjMuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YV8yNC5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhXzI1LmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2RhdGFfMjYuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YV8yNy5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19pbmRleF8xMC5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhXzI4LmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2RhdGFfMjkuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YV8zMC5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19pbmRleF8xMS5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhXzMxLmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2RhdGFfMzIuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fZGF0YV8zMy5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19kYXRhXzM0LmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2RhdGFfMzUuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fYXVkaXQyXzIwLmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2F1ZGl0Ml8yMS5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19pbmRleF8xMi5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19hdWRpdDJfMjIuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fYXVkaXQyXzIzLmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL2RhdGFfREJTTk1QXzAxLmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2F1ZGl0Ml8yNC5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9teHJocHJjX2RhdGFfMDIub3JhJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9fYXVkaXQyXzI1LmRiZicsCicvdTAxL29yYWRhdGEvbm9tZWRiL3BvbnRvX2F1ZGl0Ml8yNi5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19pbmRleF8xMy5kYmYnLAonL3UwMS9vcmFkYXRhL25vbWVkYi9wb250b19hdWRpdDJfMjcuZGJmJywKJy91MDEvb3JhZGF0YS9ub21lZGIvcG9udG9faW5kZXhfMTQuZGJmJwpDSEFSQUNURVIgU0VUIFdFOElTTzg4NTlQMQo7[/et_pb_dmb_code_snippet]

9) No banco destino, sete o SID e execute um ‘STARTUP NOMOUNT;’

[et_pb_dmb_code_snippet code=”W29yYXAwMUBob3N0bmFtZU5ldyB+XSQgZXhwb3J0IE9SQUNMRV9TSUQ9bm9tZWRiCltvcmFwMDFAaG9zdG5hbWVOZXcgfl0kIHNxbHBsdXMgIi8gYXMgc3lzZGJhIgoKU1FMKlBsdXM6IFJlbGVhc2UgMTAuMi4wLjQuMCAtIFByb2R1Y3Rpb24gb24gV2VkIE5vdiA3IDIxOjE4OjM1IDIwMTIKCkNvcHlyaWdodCAoYykgMTk4MiwgMjAwNywgT3JhY2xlLiBBbGwgUmlnaHRzIFJlc2VydmVkLgoKQ29ubmVjdGVkIHRvIGFuIGlkbGUgaW5zdGFuY2UuCgpTUUw+IHN0YXJ0dXAgbm9tb3VudDsKT1JBQ0xFIGluc3RhbmNlIHN0YXJ0ZWQuCgpUb3RhbCBTeXN0ZW0gR2xvYmFsIEFyZWEgOTY2MzY3NjQxNiBieXRlcwpGaXhlZCBTaXplIDIwOTk3NTIgYnl0ZXMKVmFyaWFibGUgU2l6ZSA4Mzg4NjIyOTYgYnl0ZXMKRGF0YWJhc2UgQnVmZmVycyA4ODA4MDM4NDAwIGJ5dGVzClJlZG8gQnVmZmVycyAxNDY3NTk2OCBieXRlcw==” _builder_version=”4.0.6″]W29yYXAwMUBob3N0bmFtZU5ldyB+XSQgZXhwb3J0IE9SQUNMRV9TSUQ9bm9tZWRiCltvcmFwMDFAaG9zdG5hbWVOZXcgfl0kIHNxbHBsdXMgIi8gYXMgc3lzZGJhIgoKU1FMKlBsdXM6IFJlbGVhc2UgMTAuMi4wLjQuMCAtIFByb2R1Y3Rpb24gb24gV2VkIE5vdiA3IDIxOjE4OjM1IDIwMTIKCkNvcHlyaWdodCAoYykgMTk4MiwgMjAwNywgT3JhY2xlLiBBbGwgUmlnaHRzIFJlc2VydmVkLgoKQ29ubmVjdGVkIHRvIGFuIGlkbGUgaW5zdGFuY2UuCgpTUUw+IHN0YXJ0dXAgbm9tb3VudDsKT1JBQ0xFIGluc3RhbmNlIHN0YXJ0ZWQuCgpUb3RhbCBTeXN0ZW0gR2xvYmFsIEFyZWEgOTY2MzY3NjQxNiBieXRlcwpGaXhlZCBTaXplIDIwOTk3NTIgYnl0ZXMKVmFyaWFibGUgU2l6ZSA4Mzg4NjIyOTYgYnl0ZXMKRGF0YWJhc2UgQnVmZmVycyA4ODA4MDM4NDAwIGJ5dGVzClJlZG8gQnVmZmVycyAxNDY3NTk2OCBieXRlcw==[/et_pb_dmb_code_snippet]

10) Execute o script create_controlfile.sql, criado no passo 8.

[et_pb_dmb_code_snippet code=”U1FMPiBAY3JlYXRlX2NvbnRyb2wuc3FsCgpDb250cm9sIGZpbGUgY3JlYXRlZC4KClNRTD4=” _builder_version=”4.0.6″]U1FMPiBAY3JlYXRlX2NvbnRyb2wuc3FsCgpDb250cm9sIGZpbGUgY3JlYXRlZC4KClNRTD4=[/et_pb_dmb_code_snippet]

11) Agora podemos executar o recover do banco. Nesse momento o banco irá solicitar os archives gerados entre o passo 2 e 6.
(digite AUTO para aplicar todos os archives gerados)

[et_pb_dmb_code_snippet code=”U1FMPiBSRUNPVkVSIERBVEFCQVNFIFVTSU5HIEJBQ0tVUCBDT05UUk9MRklMRSBVTlRJTCBDQU5DRUw7Ck9SQS0wMDI3OTogY2hhbmdlIDEwODcwNjgxOTYwNSBnZW5lcmF0ZWQgYXQgMTEvMDcvMjAxMiAxOToxNDozMSBuZWVkZWQgZm9yCnRocmVhZCAxCk9SQS0wMDI4OTogc3VnZ2VzdGlvbiA6Ci91MDEvb3JhZGF0YS9ub21lZGIvYXJjaGl2ZS9hcmNoX25vbWVkYl8xODA3MzZfMV83MzI3NjE3OTMuYXJjCk9SQS0wMDI4MDogY2hhbmdlIDEwODcwNjgxOTYwNSBmb3IgdGhyZWFkIDEgaXMgaW4gc2VxdWVuY2UgIzE4MDczNgpTcGVjaWZ5IGxvZzogezxSRVQ+PXN1Z2dlc3RlZCB8IGZpbGVuYW1lIHwgQVVUTyB8IENBTkNFTH0KQVVUTwpPUkEtMDAyNzk6IGNoYW5nZSAxMDg3MDY4NDk5MTggZ2VuZXJhdGVkIGF0IDExLzA3LzIwMTIgMTk6Mjg6MjQgbmVlZGVkIGZvcgp0aHJlYWQgMQpPUkEtMDAyODk6IHN1Z2dlc3Rpb24gOgovdTAxL29yYWRhdGEvbm9tZWRiL2FyY2hpdmUvYXJjaF9ub21lZGJfMTgwNzM3XzFfNzMyNzYxNzkzLmFyYwpPUkEtMDAyODA6IGNoYW5nZSAxMDg3MDY4NDk5MTggZm9yIHRocmVhZCAxIGlzIGluIHNlcXVlbmNlICMxODA3MzcKT1JBLTAwMjc4OiBsb2cgZmlsZQonL3UwMS9vcmFkYXRhL25vbWVkYi9hcmNoaXZlL2FyY2hfbm9tZWRiXzE4MDczNl8xXzczMjc2MTc5My5hcmMnIG5vIGxvbmdlcgpuZWVkZWQgZm9yIHRoaXMgcmVjb3Zlcnk=” _builder_version=”4.0.6″]U1FMPiBSRUNPVkVSIERBVEFCQVNFIFVTSU5HIEJBQ0tVUCBDT05UUk9MRklMRSBVTlRJTCBDQU5DRUw7Ck9SQS0wMDI3OTogY2hhbmdlIDEwODcwNjgxOTYwNSBnZW5lcmF0ZWQgYXQgMTEvMDcvMjAxMiAxOToxNDozMSBuZWVkZWQgZm9yCnRocmVhZCAxCk9SQS0wMDI4OTogc3VnZ2VzdGlvbiA6Ci91MDEvb3JhZGF0YS9ub21lZGIvYXJjaGl2ZS9hcmNoX25vbWVkYl8xODA3MzZfMV83MzI3NjE3OTMuYXJjCk9SQS0wMDI4MDogY2hhbmdlIDEwODcwNjgxOTYwNSBmb3IgdGhyZWFkIDEgaXMgaW4gc2VxdWVuY2UgIzE4MDczNgpTcGVjaWZ5IGxvZzogezxSRVQ+PXN1Z2dlc3RlZCB8IGZpbGVuYW1lIHwgQVVUTyB8IENBTkNFTH0KQVVUTwpPUkEtMDAyNzk6IGNoYW5nZSAxMDg3MDY4NDk5MTggZ2VuZXJhdGVkIGF0IDExLzA3LzIwMTIgMTk6Mjg6MjQgbmVlZGVkIGZvcgp0aHJlYWQgMQpPUkEtMDAyODk6IHN1Z2dlc3Rpb24gOgovdTAxL29yYWRhdGEvbm9tZWRiL2FyY2hpdmUvYXJjaF9ub21lZGJfMTgwNzM3XzFfNzMyNzYxNzkzLmFyYwpPUkEtMDAyODA6IGNoYW5nZSAxMDg3MDY4NDk5MTggZm9yIHRocmVhZCAxIGlzIGluIHNlcXVlbmNlICMxODA3MzcKT1JBLTAwMjc4OiBsb2cgZmlsZQonL3UwMS9vcmFkYXRhL25vbWVkYi9hcmNoaXZlL2FyY2hfbm9tZWRiXzE4MDczNl8xXzczMjc2MTc5My5hcmMnIG5vIGxvbmdlcgpuZWVkZWQgZm9yIHRoaXMgcmVjb3Zlcnk=[/et_pb_dmb_code_snippet]

Quinze minutos depois… 🙂

12) Agora o banco pode ser aberto com a opção RESETLOGS:

[et_pb_dmb_code_snippet code=”U1FMPiBBTFRFUiBEQVRBQkFTRSBPUEVOIFJFU0VUTE9HUzsKMTMpIEFkaWNpb25lIHRlbXBmaWxlcyBhIHRhYmxlc3BhY2UgdGVtcG9yw6FyaWEuIEVsZXMgcG9kZW0gc2VyIGRpbWVuc2lvbmFkb3MgY29uZm9ybWUgYSBuZWNlc3NpZGFkZToKClNRTD4gQUxURVIgVEFCTEVTUEFDRSBURU1QIEFERCBURU1QRklMRSAnL3UwMS9vcmFkYXRhL25vbWVkYi90ZW1wMDEuZGJmJyBTSVpFIDEwME0gUkVVU0UgQVVUT0VYVEVORCBPRkY7″ _builder_version=”4.0.6″]U1FMPiBBTFRFUiBEQVRBQkFTRSBPUEVOIFJFU0VUTE9HUzsKMTMpIEFkaWNpb25lIHRlbXBmaWxlcyBhIHRhYmxlc3BhY2UgdGVtcG9yw6FyaWEuIEVsZXMgcG9kZW0gc2VyIGRpbWVuc2lvbmFkb3MgY29uZm9ybWUgYSBuZWNlc3NpZGFkZToKClNRTD4gQUxURVIgVEFCTEVTUEFDRSBURU1QIEFERCBURU1QRklMRSAnL3UwMS9vcmFkYXRhL25vbWVkYi90ZW1wMDEuZGJmJyBTSVpFIDEwME0gUkVVU0UgQVVUT0VYVEVORCBPRkY7[/et_pb_dmb_code_snippet]

14) Caso necessário, altere o nome do banco:

[et_pb_dmb_code_snippet code=”MjE6MzU6MjAgbm9tZWRiPiBBTFRFUiBEQVRBQkFTRSBSRU5BTUUgZ2xvYmFsX25hbWUgVE8gbmV3YmFuY287CjIxOjM1OjIwIG5vbWVkYj4gU0VMRUNUICogRlJPTSBnbG9iYWxfbmFtZTsKCkdMT0JBTF9OQU1FCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tCm5ld2JhbmNv” _builder_version=”4.0.6″]MjE6MzU6MjAgbm9tZWRiPiBBTFRFUiBEQVRBQkFTRSBSRU5BTUUgZ2xvYmFsX25hbWUgVE8gbmV3YmFuY287CjIxOjM1OjIwIG5vbWVkYj4gU0VMRUNUICogRlJPTSBnbG9iYWxfbmFtZTsKCkdMT0JBTF9OQU1FCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tCm5ld2JhbmNv[/et_pb_dmb_code_snippet]

Tudo isso ao som que segue:

É isso aí pessoal… cada um tem um jeito que acha melhor. Pessoalmente, acho esse o mais rápido, por não precisar fazer um restore via RMAN, apenas copiar de uma instance para a outra.

Devemos observar alguns detalhes como aumento do volume de geração de archives no período entre begin/end backup, assim como rotinas de backup de archives que possam limpar os mesmos.

Abraços!