{"id":5847,"date":"2021-07-15T22:36:34","date_gmt":"2021-07-15T22:36:34","guid":{"rendered":"https:\/\/swiv.com.br\/using-oci-console-for-managing-database-backups\/"},"modified":"2026-05-27T20:02:30","modified_gmt":"2026-05-27T19:02:30","slug":"using-oci-console-for-managing-database-backups","status":"publish","type":"post","link":"https:\/\/swiv.com.br\/index.php\/2021\/07\/15\/using-oci-console-for-managing-database-backups\/","title":{"rendered":"Using OCI Console for Managing Database Backups"},"content":{"rendered":"\n<p>Neste artigo, vamos utilizar o OCI Console (com o recurso autobackup) para realizar o backup de nosso DB System.<\/p>\n\n\n\n<p>Acessando a p\u00e1gina do nosso database pelo Menu Principal -&gt; Oracle Database -&gt; Bare Metal, VM, and Exadata:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-15-1-1024x341.png\" alt=\"\" class=\"wp-image-7492\"\/><\/figure>\n\n\n\n<p>Acessando nosso DB System:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-16-1.png\" alt=\"\" class=\"wp-image-7494\"\/><\/figure>\n\n\n\n<p>Databases:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-17-1.png\" alt=\"\" class=\"wp-image-7495\"\/><\/figure>\n\n\n\n<p>Na tela principal do nosso Database, clicamos em &#8220;Configure Automatic Backups&#8221;:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-19-1.png\" alt=\"\" class=\"wp-image-7497\"\/><\/figure>\n\n\n\n<p>Podemos selecionar a op\u00e7\u00e3o &#8220;Enable automatic backup&#8221; e escolher a op\u00e7\u00e3o de backup retention:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-20-1.png\" alt=\"\" class=\"wp-image-7498\"\/><\/figure>\n\n\n\n<p>Diferente do DBCLI ou RMAN, onde conseguimos definir precisamente em qual hor\u00e1rio podemos rodar nosso backup, no OCI Console temos uma faixa que escolhemos para que o backup seja realizado:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-21-1.png\" alt=\"\" class=\"wp-image-7499\"\/><\/figure>\n\n\n\n<p>Ap\u00f3s salvar a configura\u00e7\u00e3o, vemos que a p\u00e1gina do database j\u00e1 reflete o que foi feito:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-22-1.png\" alt=\"\" class=\"wp-image-7500\"\/><\/figure>\n\n\n\n<p>Pouco tempo depois que defini a janela de backup, meu banco de dados j\u00e1 come\u00e7ou a ser &#8220;backupeado&#8221;, exibindo o seguinte status na Console:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-23-1.png\" alt=\"\" class=\"wp-image-7501\"\/><\/figure>\n\n\n\n<p>Os detalhes da evolu\u00e7\u00e3o do processo podem ser vistos na parte de Backups da sess\u00e3o Resources:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-24-1-1024x211.png\" alt=\"\" class=\"wp-image-7502\"\/><\/figure>\n\n\n\n<p>Ap\u00f3s bons minutos, o backup (level 0) \u00e9 conclu\u00eddo:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-27-2.png\" alt=\"\" class=\"wp-image-7506\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-26-2.png\" alt=\"\" class=\"wp-image-7508\"\/><\/figure>\n\n\n\n<p>E o status do banco volta a ser exibido como Dispon\u00edvel:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-29-1.png\" alt=\"\" class=\"wp-image-7509\"\/><\/figure>\n\n\n\n<p>O interessante para observarmos \u00e9 que nossa configura\u00e7\u00e3o via Console modificou o par\u00e2metro persistente no RMAN, conforme abaixo:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n&#x5B;opc@luxor ~]$ sudo su - oracle\nLast login: Thu Jul 15 22:03:11 UTC 2021\n&#x5B;oracle@luxor ~]$ rman target \/\n\nRecovery Manager: Release 19.0.0.0.0 - Production on Thu Jul 15 22:12:05 2021\nVersion 19.11.0.0.0\n\nCopyright (c) 1982, 2019, Oracle and\/or its affiliates.  All rights reserved.\n\nconnected to target database: CORTEX (DBID=581933924)\n\nRMAN&gt; SHOW RETENTION POLICY;\n\nusing target database control file instead of recovery catalog\nRMAN configuration parameters for database with db_unique_name CORTEX_PHX1HB are:\nCONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;\n<\/pre><\/div>\n\n\n<p>Atrav\u00e9s do OCI Console, conseguimos agendar os backups, mas tamb\u00e9m conseguimos fazer o disparo manualmente. Clicando no banco Create Backup:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-30-1.png\" alt=\"\" class=\"wp-image-7510\"\/><\/figure>\n\n\n\n<p>Gerando um nome e clicando em Create Backup:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-31-1.png\" alt=\"\" class=\"wp-image-7511\"\/><\/figure>\n\n\n\n<p>Backup em execu\u00e7\u00e3o:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-32-1.png\" alt=\"\" class=\"wp-image-7512\"\/><\/figure>\n\n\n\n<p>Backup conclu\u00eddo com sucesso:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-33-1.png\" alt=\"\" class=\"wp-image-7513\"\/><\/figure>\n\n\n\n<p>No RMAN, podemos ver as informa\u00e7\u00f5es dos backups:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nRMAN&gt; LIST BACKUP OF DATABASE;\n\n\nList of Backup Sets\n===================\n\n\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ ---------------\n34      Incr 0  517.75M    SBT_TAPE    00:00:33     15-JUL-21\n        BP Key: 38   Status: AVAILABLE  Compressed: YES  Tag: DBTREGULAR-L01626384618783OGJ\n        Handle: DBTRegular-L01626384618783oGj_df_CORTEX_581933924_16042419_38_1_1_20210715_1078005801_set38   Media: swiftobjectstorage.u..ud.com\/v1\/dbbackupphx\/bavjfvGGcVWO7V1HGWEW\n  List of Datafiles in backup set 34\n  File LV Type Ckp SCN    Ckp Time  Abs Fuz SCN Sparse Name\n  ---- -- ---- ---------- --------- ----------- ------ ----\n  1    0  Incr 6412879    15-JUL-21              NO    +DATA\/CORTEX_PHX1HB\/DATAFILE\/system.261.1071999329\n  3    0  Incr 6412879    15-JUL-21              NO    +DATA\/CORTEX_PHX1HB\/DATAFILE\/sysaux.262.1071999373\n  4    0  Incr 6412879    15-JUL-21              NO    +DATA\/CORTEX_PHX1HB\/DATAFILE\/undotbs1.263.1071999399\n  11   0  Incr 6412879    15-JUL-21              NO    +DATA\/CORTEX_PHX1HB\/DATAFILE\/users.274.1072000383\n\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ ---------------\n40      Incr 0  253.00M    SBT_TAPE    00:00:14     15-JUL-21\n        BP Key: 44   Status: AVAILABLE  Compressed: YES  Tag: DBTREGULAR-L01626384618783OGJ\n        Handle: DBTRegular-L01626384618783oGj_df_CORTEX_581933924_1904242n_41_1_1_20210715_1078005847_set41   Media: swiftobjectstorage.u..ud.com\/v1\/dbbackupphx\/bavjfvGGcVWO7V1HGWEW\n  List of Datafiles in backup set 40\n  Container ID: 3, PDB Name: HIPOFISE1\n  File LV Type Ckp SCN    Ckp Time  Abs Fuz SCN Sparse Name\n  ---- -- ---- ---------- --------- ----------- ------ ----\n  8    0  Incr 6414034    15-JUL-21              NO    +DATA\/CORTEX_PHX1HB\/C1CF6DCEA12F134DE0539501000A20C1\/DATAFILE\/system.271.1072000035\n  9    0  Incr 6414034    15-JUL-21              NO    +DATA\/CORTEX_PHX1HB\/C1CF6DCEA12F134DE0539501000A20C1\/DATAFILE\/sysaux.272.1072000035\n  10   0  Incr 6414034    15-JUL-21              NO    +DATA\/CORTEX_PHX1HB\/C1CF6DCEA12F134DE0539501000A20C1\/DATAFILE\/undotbs1.270.1072000035\n  12   0  Incr 6414034    15-JUL-21              NO    +DATA\/CORTEX_PHX1HB\/C1CF6DCEA12F134DE0539501000A20C1\/DATAFILE\/users.275.1072000383\n\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ ---------------\n41      Incr 0  313.00M    SBT_TAPE    00:00:18     15-JUL-21\n        BP Key: 45   Status: AVAILABLE  Compressed: YES  Tag: DBTREGULAR-L01626384618783OGJ\n        Handle: DBTRegular-L01626384618783oGj_df_CORTEX_581933924_1d04243g_45_1_1_20210715_1078005872_set45   Media: swiftobjectstorage.u..ud.com\/v1\/dbbackupphx\/bavjfvGGcVWO7V1HGWEW\n  List of Datafiles in backup set 41\n  Container ID: 2, PDB Name: PDB$SEED\n  File LV Type Ckp SCN    Ckp Time  Abs Fuz SCN Sparse Name\n  ---- -- ---- ---------- --------- ----------- ------ ----\n  5    0  Incr 5899769    05-JUN-21              NO    +DATA\/CORTEX_PHX1HB\/B2084748142A4638E053C003F40A65C0\/DATAFILE\/system.266.1071999505\n  6    0  Incr 5899769    05-JUN-21              NO    +DATA\/CORTEX_PHX1HB\/B2084748142A4638E053C003F40A65C0\/DATAFILE\/sysaux.265.1071999505\n  7    0  Incr 5899769    05-JUN-21              NO    +DATA\/CORTEX_PHX1HB\/B2084748142A4638E053C003F40A65C0\/DATAFILE\/undotbs1.267.1071999505\n\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ ---------------\n47      Full    515.00M    SBT_TAPE    00:00:29     15-JUL-21\n        BP Key: 51   Status: AVAILABLE  Compressed: YES  Tag: DBTLONGTERM1626387318752YR3\n        Handle: DBTLongterm1626387318752yR3__CORTEX_581933924_1j042559_51_1_1_20210715_1078006953_set51   Media: swiftobjectstorage.u..ud.com\/v1\/dbbackupphx\/bavjfvGGcVWO7V1HGWEW\n        Keep: BACKUP_LOGS        Until: 08-DEC-00\n  List of Datafiles in backup set 47\n  File LV Type Ckp SCN    Ckp Time  Abs Fuz SCN Sparse Name\n  ---- -- ---- ---------- --------- ----------- ------ ----\n  1       Full 6415182    15-JUL-21              NO    +DATA\/CORTEX_PHX1HB\/DATAFILE\/system.261.1071999329\n  3       Full 6415182    15-JUL-21              NO    +DATA\/CORTEX_PHX1HB\/DATAFILE\/sysaux.262.1071999373\n  4       Full 6415182    15-JUL-21              NO    +DATA\/CORTEX_PHX1HB\/DATAFILE\/undotbs1.263.1071999399\n  11      Full 6415182    15-JUL-21              NO    +DATA\/CORTEX_PHX1HB\/DATAFILE\/users.274.1072000383\n\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ ---------------\n48      Full    251.25M    SBT_TAPE    00:00:12     15-JUL-21\n        BP Key: 52   Status: AVAILABLE  Compressed: YES  Tag: DBTLONGTERM1626387318752YR3\n        Handle: DBTLongterm1626387318752yR3__CORTEX_581933924_1k04256d_52_1_1_20210715_1078006989_set52   Media: swiftobjectstorage.u..ud.com\/v1\/dbbackupphx\/bavjfvGGcVWO7V1HGWEW\n        Keep: BACKUP_LOGS        Until: 08-DEC-00\n  List of Datafiles in backup set 48\n  Container ID: 3, PDB Name: HIPOFISE1\n  File LV Type Ckp SCN    Ckp Time  Abs Fuz SCN Sparse Name\n  ---- -- ---- ---------- --------- ----------- ------ ----\n  8       Full 6415196    15-JUL-21              NO    +DATA\/CORTEX_PHX1HB\/C1CF6DCEA12F134DE0539501000A20C1\/DATAFILE\/system.271.1072000035\n  9       Full 6415196    15-JUL-21              NO    +DATA\/CORTEX_PHX1HB\/C1CF6DCEA12F134DE0539501000A20C1\/DATAFILE\/sysaux.272.1072000035\n  10      Full 6415196    15-JUL-21              NO    +DATA\/CORTEX_PHX1HB\/C1CF6DCEA12F134DE0539501000A20C1\/DATAFILE\/undotbs1.270.1072000035\n  12      Full 6415196    15-JUL-21              NO    +DATA\/CORTEX_PHX1HB\/C1CF6DCEA12F134DE0539501000A20C1\/DATAFILE\/users.275.1072000383\n\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ ---------------\n49      Full    313.00M    SBT_TAPE    00:00:11     15-JUL-21\n        BP Key: 53   Status: AVAILABLE  Compressed: YES  Tag: DBTLONGTERM1626387318752YR3\n        Handle: DBTLongterm1626387318752yR3__CORTEX_581933924_1l04256t_53_1_1_20210715_1078007005_set53   Media: swiftobjectstorage.u..ud.com\/v1\/dbbackupphx\/bavjfvGGcVWO7V1HGWEW\n        Keep: BACKUP_LOGS        Until: 08-DEC-00\n  List of Datafiles in backup set 49\n  Container ID: 2, PDB Name: PDB$SEED\n  File LV Type Ckp SCN    Ckp Time  Abs Fuz SCN Sparse Name\n  ---- -- ---- ---------- --------- ----------- ------ ----\n  5       Full 5899769    05-JUN-21              NO    +DATA\/CORTEX_PHX1HB\/B2084748142A4638E053C003F40A65C0\/DATAFILE\/system.266.1071999505\n  6       Full 5899769    05-JUN-21              NO    +DATA\/CORTEX_PHX1HB\/B2084748142A4638E053C003F40A65C0\/DATAFILE\/sysaux.265.1071999505\n  7       Full 5899769    05-JUN-21              NO    +DATA\/CORTEX_PHX1HB\/B2084748142A4638E053C003F40A65C0\/DATAFILE\/undotbs1.267.1071999505\n<\/pre><\/div>\n\n\n<p>Obs: Este procedimento foi criado pelo senhor Ahmed Baraka (www.ahmedbaraka.com) e foi apenas reproduzido por mim em um laborat\u00f3rio pessoal para fins de aprendizado.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Neste artigo, vamos utilizar o OCI Console (com o recurso autobackup) para realizar o backup de nosso DB System. Acessando a p\u00e1gina do nosso database pelo Menu Principal -&gt; Oracle Database -&gt; Bare Metal, VM, and Exadata: Acessando nosso DB System: Databases: Na tela principal do nosso Database, clicamos em &#8220;Configure Automatic Backups&#8221;: Podemos selecionar [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,9],"tags":[],"class_list":["post-5847","post","type-post","status-publish","format-standard","hentry","category-backup-recovery","category-oci"],"_links":{"self":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/5847","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=5847"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/5847\/revisions"}],"predecessor-version":[{"id":9078,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/5847\/revisions\/9078"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=5847"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=5847"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=5847"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}