Dica rápida para copiar múltiplos dumpfiles para um bucket no OCI Object Storage.

Requisito: Ter o OCI CLI instalado e configurado no servidor. Neste exemplo, os arquivos foram copiados via scp do servidor de banco de dados para uma VM com o OCI CLI configurado, o que seria mais rápido do que copiar para a máquina local e fazer upload via browser.

No diretório /tmp/marte_dump tenho 4 arquivos de dump gerados com Data Pump para importar no Autonomous Database:

$ ls -l /tmp/marte_dump/
total 916388
-rwxrwxrwx 1 root root     61440 Sep 12 09:39 marte_SOE01.dmp
-rwxrwxrwx 1 root root 307073024 Sep 12 09:39 marte_SOE02.dmp
-rwxrwxrwx 1 root root 428269568 Sep 12 09:39 marte_SOE03.dmp
-rwxrwxrwx 1 root root 202977280 Sep 12 09:39 marte_SOE04.dmp

O comando abaixo faz upload de todos os arquivos neste diretório para um bucket chamado “datapump”:

oci os object bulk-upload --bucket-name datapump --src-dir /tmp/marte_dump/

O resultado do comando:

$ oci os object bulk-upload --bucket-name datapump --src-dir /tmp/marte_dump/
Uploaded marte_SOE01.dmp  [####################################]  100%
Uploaded marte_SOE03.dmp  [####################################]  100%                     
Uploaded marte_SOE02.dmp  [####################################]  100%                     
Uploaded marte_SOE04.dmp  [####################################]  100%                     

{
  "skipped-objects": [],
  "upload-failures": {},
  "uploaded-objects": {
    "marte_SOE01.dmp": {
      "etag": "05fcf39d-a833-4acf-b915-38b14edb3606",
      "last-modified": "Sun, 12 Sep 2021 15:33:24 GMT",
      "opc-content-md5": "30zpfBIe5Db5Tjmre6Cslw=="
    },
    "marte_SOE02.dmp": {
      "etag": "5802dbf2-0b8c-400f-9ad2-f298e08035e8",
      "last-modified": "Sun, 12 Sep 2021 15:36:21 GMT",
      "opc-multipart-md5": "NWeBVrnS+MWkBGsb7E3spg==-3"
    },
    "marte_SOE03.dmp": {
      "etag": "4ca251aa-c654-42b5-a8f9-b16e9e38315d",
      "last-modified": "Sun, 12 Sep 2021 15:35:06 GMT",
      "opc-multipart-md5": "S03wUSeAdE8gYp0R5M/wQw==-4"
    },
    "marte_SOE04.dmp": {
      "etag": "b2d009ec-3a6d-42fe-a9bf-744eb7d62f1a",
      "last-modified": "Sun, 12 Sep 2021 15:36:25 GMT",
      "opc-multipart-md5": "arJu+5IVCRRpBFqil+MTUg==-2"
    }
  }
}

Arquivos carregados com sucesso para o bucket:

One thought on “Dica Rápida: Copiando Múltiplos Dumpfiles para um Bucket no OCI Object Storage via OCI Command Line”

Leave a Reply

Discover more from Blog do Dibiei

Subscribe now to keep reading and get access to the full archive.

Continue reading