{"id":5809,"date":"2021-07-14T23:40:54","date_gmt":"2021-07-14T23:40:54","guid":{"rendered":"https:\/\/swiv.com.br\/using-rman-for-managing-oci-database-backups\/"},"modified":"2026-05-27T20:02:30","modified_gmt":"2026-05-27T19:02:30","slug":"using-rman-for-managing-oci-database-backups","status":"publish","type":"post","link":"https:\/\/swiv.com.br\/index.php\/2021\/07\/14\/using-rman-for-managing-oci-database-backups\/","title":{"rendered":"Using RMAN for managing OCI Database Backups"},"content":{"rendered":"\n

O objetivo de hoje \u00e9 realizar o backup de um DB System do OCI utilizando apenas o RMAN, enviando os backup pieces para um bucket no Object Storage.<\/p>\n\n\n\n

Na console inicial, vamos no Menu principal, clicamos em Storage -> Object Storage:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Clicando em Create Bucket:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Definindo o nome do Bucket e clicando em Create:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Clicando em nosso Bucket:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Coletando o valor do campo “Namespace”, pois o usaremos nas opera\u00e7\u00f5es seguintes:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Agora vamos configurar a parte de “Authentication Token”. Acessando o Menu Principal -> Identity & Security -> Users:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Clicando no link que corresponde ao meu e-mail da cria\u00e7\u00e3o da conta:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Em Resource, vamos na tela de “Auth Tokens” -> Generate Token:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Colocando uma descri\u00e7\u00e3o e gerando o Token:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Copiando o Token para us\u00e1-lo em breve:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Em nosso DB System, precisaremos instalar o Backup Module para que o RMAN consiga gerar os backup pieces em nosso bucket. Para isso, vamos executar o processo abaixo, substituindo os par\u00e2metros conforme abaixo:<\/p>\n\n\n\n

  • <user_id> = recebe o valor do e-mail da conta do OCI<\/li>
  • <auth_token> = recebe o valor do Token que geramos nos passos deste artigo<\/li>
  • <region_name> = recebe o valor do campo “regionIdentifier” coletado com o comando “curl -s http:\/\/SEU_IP\/opc\/v1\/instance\/ | grep region”<\/li>
  • <os-ns> = recebe o valor do Namespace do nosso bucket.<\/li><\/ul>\n\n\n
    \nmkdir ~\/lib\/ \ncd \/opt\/oracle\/oak\/pkgrepos\/oss\/odbcs \njava -jar opc_install.jar -opcId &lt;user_id> -opcPass '&lt;auth_token>' -container backupb -walletDir ~\/hsbtwallet\/ -libDir ~\/lib\/ -configfile ~\/config -host https:\/\/swiftobjectstorage.&lt;region_name>.oraclecloud.com\/v1\/&lt;os-ns>\n<\/pre><\/div>\n\n\n
    Log do processo:<\/p>\n\n\n
    \n[oracle@luxor ~]$ mkdir ~\/lib\/\n[oracle@luxor ~]$ cd \/opt\/oracle\/oak\/pkgrepos\/oss\/odbcs\n[oracle@luxor odbcs]$ java -jar opc_install.jar -opcId meuemail@gmail.com -opcPass 'koYU;l4+1DosJR(T-_Bl' -container backupb -walletDir ~\/hsbtwallet\/ -libDir ~\/lib\/ -configfile ~\/config -host https:\/\/swiftobjectstorage.us-phoenix-1.oraclecloud.com\/v1\/axdmf59nkyfq\nOracle Database Cloud Backup Module Install Tool, build 12.2.0.1.0DBBKPCSBP_2018-06-12\nOracle Database Cloud Backup Module credentials are valid.\nBackups would be sent to container backupb.\nOracle Database Cloud Backup Module wallet created in directory \/home\/oracle\/hsbtwallet.\nOracle Database Cloud Backup Module initialization file \/home\/oracle\/config created.\nDownloading Oracle Database Cloud Backup Module Software Library from file opc_linux64.zip.\nDownload complete.\n[oracle@luxor odbcs]$\n<\/pre><\/div>\n\n\n
    Agora podemos alterar alguns par\u00e2metros persistentes do RMAN para que o mesmo possa jogar nossos backups para o bucket. O legal \u00e9 que o device configurado deve ser do tipo \\”SBT_TYPE\\”, com os par\u00e2metro do exemplo abaixo:<\/p>\n\n\n
    \n[oracle@luxor odbcs]$ rman target \/\n \nRecovery Manager: Release 19.0.0.0.0 - Production on Wed Jul 14 23:24:54 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> CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=\/home\/oracle\/lib\/libopc.so, SBT_PARMS=(OPC_PFILE=\/home\/oracle\/co             nfig)';\n \nusing target database control file instead of recovery catalog\nnew RMAN configuration parameters:\nCONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS  'SBT_LIBRARY=\/home\/oracle\/lib\/libopc.so, SBT_PARMS=(OPC_PFILE=\/home\/oracle\/config)             ';\nnew RMAN configuration parameters are successfully stored\n \nRMAN> CONFIGURE DEFAULT DEVICE TYPE TO SBT_TAPE;\n \nnew RMAN configuration parameters:\nCONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';\nnew RMAN configuration parameters are successfully stored\n \nRMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;\n \nold RMAN configuration parameters:\nCONFIGURE CONTROLFILE AUTOBACKUP ON;\nnew RMAN configuration parameters:\nCONFIGURE CONTROLFILE AUTOBACKUP ON;\nnew RMAN configuration parameters are successfully stored\n \nRMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;\n \nold RMAN configuration parameters:\nCONFIGURE ENCRYPTION FOR DATABASE ON;\nnew RMAN configuration parameters:\nCONFIGURE ENCRYPTION FOR DATABASE ON;\nnew RMAN configuration parameters are successfully stored\n \nRMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F';\n \nnew RMAN configuration parameters:\nCONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO '%F';\nnew RMAN configuration parameters are successfully stored\n<\/pre><\/div>\n\n\n
    Realizando um teste de backup:<\/p>\n\n\n
    \nhost 'date'; \nSET ENCRYPTION IDENTIFIED BY "BSS" ONLY; \nBACKUP FULL SECTION SIZE 512M DATABASE TAG DB_SBT; \nhost 'date';\n<\/pre><\/div>\n\n\n
    Log da execu\u00e7\u00e3o, com in\u00edcio \u00e0s 23:27:33 e t\u00e9rmino 23:30:48 para ser conclu\u00eddo:<\/p>\n\n\n
    \nRMAN> host 'date';\nSET ENCRYPTION IDENTIFIED BY "BSS" ONLY;\nBACKUP FULL SECTION SIZE 512M DATABASE TAG DB_SBT;\nhost 'date';\nWed Jul 14 23:27:33 UTC 2021\nhost command complete\n \nRMAN>\nexecuting command: SET encryption\n \nRMAN>\nStarting backup at 14-JUL-21\nallocated channel: ORA_SBT_TAPE_1\nchannel ORA_SBT_TAPE_1: SID=288 device type=SBT_TAPE\nchannel ORA_SBT_TAPE_1: Oracle Database Backup Service Library VER=19.0.0.1\nchannel ORA_SBT_TAPE_1: starting full datafile backup set\nchannel ORA_SBT_TAPE_1: specifying datafile(s) in backup set\ninput datafile file number=00001 name=+DATA\/CORTEX_PHX1HB\/DATAFILE\/system.261.1071999329\nbacking up blocks 1 through 65536\nchannel ORA_SBT_TAPE_1: starting piece 1 at 14-JUL-21\nchannel ORA_SBT_TAPE_1: finished piece 1 at 14-JUL-21\npiece handle=0k03vkj7_20_1_1 tag=DB_SBT comment=API Version 2.0,MMS Version 19.0.0.1\nchannel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25\nchannel ORA_SBT_TAPE_1: starting full datafile backup set\nchannel ORA_SBT_TAPE_1: specifying datafile(s) in backup set\ninput datafile file number=00001 name=+DATA\/CORTEX_PHX1HB\/DATAFILE\/system.261.1071999329\nbacking up blocks 65537 through 131072\nchannel ORA_SBT_TAPE_1: starting piece 2 at 14-JUL-21\nchannel ORA_SBT_TAPE_1: finished piece 2 at 14-JUL-21\npiece handle=0k03vkj7_20_2_1 tag=DB_SBT comment=API Version 2.0,MMS Version 19.0.0.1\nchannel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25\nchannel ORA_SBT_TAPE_1: starting full datafile backup set\nchannel ORA_SBT_TAPE_1: specifying datafile(s) in backup set\ninput datafile file number=00001 name=+DATA\/CORTEX_PHX1HB\/DATAFILE\/system.261.1071999329\nbacking up blocks 131073 through 140800\nchannel ORA_SBT_TAPE_1: starting piece 3 at 14-JUL-21\nchannel ORA_SBT_TAPE_1: finished piece 3 at 14-JUL-21\npiece handle=0k03vkj7_20_3_1 tag=DB_SBT comment=API Version 2.0,MMS Version 19.0.0.1\nchannel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:07\nchannel ORA_SBT_TAPE_1: starting full datafile backup set\nchannel ORA_SBT_TAPE_1: specifying datafile(s) in backup set\ninput datafile file number=00009 name=+DATA\/CORTEX_PHX1HB\/C1CF6DCEA12F134DE0539501000A20C1\/DATAFILE\/sysaux.272.1072000035\ninput datafile file number=00008 name=+DATA\/CORTEX_PHX1HB\/C1CF6DCEA12F134DE0539501000A20C1\/DATAFILE\/system.271.1072000035\ninput datafile file number=00010 name=+DATA\/CORTEX_PHX1HB\/C1CF6DCEA12F134DE0539501000A20C1\/DATAFILE\/undotbs1.270.1072000035\ninput datafile file number=00012 name=+DATA\/CORTEX_PHX1HB\/C1CF6DCEA12F134DE0539501000A20C1\/DATAFILE\/users.275.1072000383\nchannel ORA_SBT_TAPE_1: starting piece 1 at 14-JUL-21\nchannel ORA_SBT_TAPE_1: finished piece 1 at 14-JUL-21\npiece handle=0n03vkl2_23_1_1 tag=DB_SBT comment=API Version 2.0,MMS Version 19.0.0.1\nchannel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25\nchannel ORA_SBT_TAPE_1: starting full datafile backup set\nchannel ORA_SBT_TAPE_1: specifying datafile(s) in backup set\ninput datafile file number=00006 name=+DATA\/CORTEX_PHX1HB\/B2084748142A4638E053C003F40A65C0\/DATAFILE\/sysaux.265.1071999505\ninput datafile file number=00005 name=+DATA\/CORTEX_PHX1HB\/B2084748142A4638E053C003F40A65C0\/DATAFILE\/system.266.1071999505\ninput datafile file number=00007 name=+DATA\/CORTEX_PHX1HB\/B2084748142A4638E053C003F40A65C0\/DATAFILE\/undotbs1.267.1071999505\nchannel ORA_SBT_TAPE_1: starting piece 1 at 14-JUL-21\nchannel ORA_SBT_TAPE_1: finished piece 1 at 14-JUL-21\npiece handle=0o03vklr_24_1_1 tag=DB_SBT comment=API Version 2.0,MMS Version 19.0.0.1\nchannel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:35\nchannel ORA_SBT_TAPE_1: starting full datafile backup set\nchannel ORA_SBT_TAPE_1: specifying datafile(s) in backup set\ninput datafile file number=00003 name=+DATA\/CORTEX_PHX1HB\/DATAFILE\/sysaux.262.1071999373\nbacking up blocks 1 through 65536\nchannel ORA_SBT_TAPE_1: starting piece 1 at 14-JUL-21\nchannel ORA_SBT_TAPE_1: finished piece 1 at 14-JUL-21\npiece handle=0p03vkmu_25_1_1 tag=DB_SBT comment=API Version 2.0,MMS Version 19.0.0.1\nchannel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25\nchannel ORA_SBT_TAPE_1: starting full datafile backup set\nchannel ORA_SBT_TAPE_1: specifying datafile(s) in backup set\ninput datafile file number=00003 name=+DATA\/CORTEX_PHX1HB\/DATAFILE\/sysaux.262.1071999373\nbacking up blocks 65537 through 103680\nchannel ORA_SBT_TAPE_1: starting piece 2 at 14-JUL-21\nchannel ORA_SBT_TAPE_1: finished piece 2 at 14-JUL-21\npiece handle=0p03vkmu_25_2_1 tag=DB_SBT comment=API Version 2.0,MMS Version 19.0.0.1\nchannel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:16\nchannel ORA_SBT_TAPE_1: starting full datafile backup set\nchannel ORA_SBT_TAPE_1: specifying datafile(s) in backup set\ninput datafile file number=00004 name=+DATA\/CORTEX_PHX1HB\/DATAFILE\/undotbs1.263.1071999399\nbacking up blocks 1 through 65536\nchannel ORA_SBT_TAPE_1: starting piece 1 at 14-JUL-21\nchannel ORA_SBT_TAPE_1: finished piece 1 at 14-JUL-21\npiece handle=0r03vko7_27_1_1 tag=DB_SBT comment=API Version 2.0,MMS Version 19.0.0.1\nchannel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:07\nchannel ORA_SBT_TAPE_1: starting full datafile backup set\nchannel ORA_SBT_TAPE_1: specifying datafile(s) in backup set\ninput datafile file number=00004 name=+DATA\/CORTEX_PHX1HB\/DATAFILE\/undotbs1.263.1071999399\nbacking up blocks 65537 through 85120\nchannel ORA_SBT_TAPE_1: starting piece 2 at 14-JUL-21\nchannel ORA_SBT_TAPE_1: finished piece 2 at 14-JUL-21\npiece handle=0r03vko7_27_2_1 tag=DB_SBT comment=API Version 2.0,MMS Version 19.0.0.1\nchannel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:03\nchannel ORA_SBT_TAPE_1: starting full datafile backup set\nchannel ORA_SBT_TAPE_1: specifying datafile(s) in backup set\ninput datafile file number=00011 name=+DATA\/CORTEX_PHX1HB\/DATAFILE\/users.274.1072000383\nchannel ORA_SBT_TAPE_1: starting piece 1 at 14-JUL-21\nchannel ORA_SBT_TAPE_1: finished piece 1 at 14-JUL-21\npiece handle=0t03vkoh_29_1_1 tag=DB_SBT comment=API Version 2.0,MMS Version 19.0.0.1\nchannel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:03\nFinished backup at 14-JUL-21\n \nStarting Control File and SPFILE Autobackup at 14-JUL-21\npiece handle=c-581933924-20210714-00 comment=API Version 2.0,MMS Version 19.0.0.1\nFinished Control File and SPFILE Autobackup at 14-JUL-21\n \nRMAN>\n \nWed Jul 14 23:30:48 UTC 2021\nhost command complete\n<\/pre><\/div>\n\n\n
    Apenas para termos a experi\u00eancia, vamos rodar o mesmo backup para disco. Obviamente o tempo \u00e9 muito menor:<\/p>\n\n\n
    \nhost 'date'; \nSET ENCRYPTION ON ; \nrun \n { \n    ALLOCATE CHANNEL c DEVICE TYPE DISK; \n    BACKUP FULL DATABASE FORMAT '+RECO\/db%U' TAG DB_DSK; \n } \nhost 'date';\n<\/pre><\/div>\n\n\n
    Log:<\/p>\n\n\n
    \nRMAN> host 'date';\nSET ENCRYPTION ON ;\nrun\n {\n        ALLOCATE CHANNEL c DEVICE TYPE DISK;\n        BACKUP FULL DATABASE FORMAT '+RECO\/db%U' TAG DB_DSK;\n }\nhost 'date';\nWed Jul 14 23:34:09 UTC 2021\nhost command complete\n \nRMAN>\nexecuting command: SET encryption\n \nRMAN> 2> 3> 4> 5>\nreleased channel: ORA_SBT_TAPE_1\nallocated channel: c\nchannel c: SID=288 device type=DISK\n \nStarting backup at 14-JUL-21\nchannel c: starting compressed full datafile backup set\nchannel c: specifying datafile(s) in backup set\ninput datafile file number=00001 name=+DATA\/CORTEX_PHX1HB\/DATAFILE\/system.261.1071999329\ninput datafile file number=00003 name=+DATA\/CORTEX_PHX1HB\/DATAFILE\/sysaux.262.1071999373\ninput datafile file number=00004 name=+DATA\/CORTEX_PHX1HB\/DATAFILE\/undotbs1.263.1071999399\ninput datafile file number=00011 name=+DATA\/CORTEX_PHX1HB\/DATAFILE\/users.274.1072000383\nchannel c: starting piece 1 at 14-JUL-21\nchannel c: finished piece 1 at 14-JUL-21\npiece handle=+RECO\/db0v03vkvi_31_1_1 tag=DB_DSK comment=NONE\nchannel c: backup set complete, elapsed time: 00:00:35\nchannel c: starting compressed full datafile backup set\nchannel c: specifying datafile(s) in backup set\ninput datafile file number=00009 name=+DATA\/CORTEX_PHX1HB\/C1CF6DCEA12F134DE0539501000A20C1\/DATAFILE\/sysaux.272.1072000035\ninput datafile file number=00008 name=+DATA\/CORTEX_PHX1HB\/C1CF6DCEA12F134DE0539501000A20C1\/DATAFILE\/system.271.1072000035\ninput datafile file number=00010 name=+DATA\/CORTEX_PHX1HB\/C1CF6DCEA12F134DE0539501000A20C1\/DATAFILE\/undotbs1.270.1072000035\ninput datafile file number=00012 name=+DATA\/CORTEX_PHX1HB\/C1CF6DCEA12F134DE0539501000A20C1\/DATAFILE\/users.275.1072000383\nchannel c: starting piece 1 at 14-JUL-21\nchannel c: finished piece 1 at 14-JUL-21\npiece handle=+RECO\/db1003vl0l_32_1_1 tag=DB_DSK comment=NONE\nchannel c: backup set complete, elapsed time: 00:00:15\nchannel c: starting compressed full datafile backup set\nchannel c: specifying datafile(s) in backup set\ninput datafile file number=00006 name=+DATA\/CORTEX_PHX1HB\/B2084748142A4638E053C003F40A65C0\/DATAFILE\/sysaux.265.1071999505\ninput datafile file number=00005 name=+DATA\/CORTEX_PHX1HB\/B2084748142A4638E053C003F40A65C0\/DATAFILE\/system.266.1071999505\ninput datafile file number=00007 name=+DATA\/CORTEX_PHX1HB\/B2084748142A4638E053C003F40A65C0\/DATAFILE\/undotbs1.267.1071999505\nchannel c: starting piece 1 at 14-JUL-21\nchannel c: finished piece 1 at 14-JUL-21\npiece handle=+RECO\/db1103vl14_33_1_1 tag=DB_DSK comment=NONE\nchannel c: backup set complete, elapsed time: 00:00:15\nFinished backup at 14-JUL-21\n \nStarting Control File and SPFILE Autobackup at 14-JUL-21\npiece handle=+RECO\/CORTEX_PHX1HB\/AUTOBACKUP\/2021_07_14\/s_1077924916.304.1077924917 comment=NONE\nFinished Control File and SPFILE Autobackup at 14-JUL-21\nreleased channel: c\n \nRMAN>\n \nWed Jul 14 23:35:21 UTC 2021\nhost command complete\n<\/pre><\/div>\n\n\n
    O nosso primeiro backup desencadeou a cria\u00e7\u00e3o do bucket abaixo:<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    Com as seguintes pastas:<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    E a\u00ed est\u00e3o os nossos backup pieces:<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    Deletando os backups produzidos:<\/p>\n\n\n
    \nRMAN> DELETE BACKUPSET TAG DB_SBT;\n \nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=288 device type=DISK\nallocated channel: ORA_SBT_TAPE_1\nchannel ORA_SBT_TAPE_1: SID=290 device type=SBT_TAPE\nchannel ORA_SBT_TAPE_1: Oracle Database Backup Service Library VER=19.0.0.1\n \nList of Backup Pieces\nBP Key  BS Key  Pc# Cp# Status      Device Type Piece Name\n------- ------- --- --- ----------- ----------- ----------\n20      20      1   1   AVAILABLE   SBT_TAPE    0k03vkj7_20_1_1\n21      20      2   1   AVAILABLE   SBT_TAPE    0k03vkj7_20_2_1\n22      20      3   1   AVAILABLE   SBT_TAPE    0k03vkj7_20_3_1\n23      21      1   1   AVAILABLE   SBT_TAPE    0n03vkl2_23_1_1\n24      22      1   1   AVAILABLE   SBT_TAPE    0o03vklr_24_1_1\n25      23      1   1   AVAILABLE   SBT_TAPE    0p03vkmu_25_1_1\n26      23      2   1   AVAILABLE   SBT_TAPE    0p03vkmu_25_2_1\n27      24      1   1   AVAILABLE   SBT_TAPE    0r03vko7_27_1_1\n28      24      2   1   AVAILABLE   SBT_TAPE    0r03vko7_27_2_1\n29      25      1   1   AVAILABLE   SBT_TAPE    0t03vkoh_29_1_1\n \nDo you really want to delete the above objects (enter YES or NO)? Y\ndeleted backup piece\nbackup piece handle=0k03vkj7_20_1_1 RECID=20 STAMP=1077924458\ndeleted backup piece\nbackup piece handle=0k03vkj7_20_2_1 RECID=21 STAMP=1077924490\ndeleted backup piece\nbackup piece handle=0k03vkj7_20_3_1 RECID=22 STAMP=1077924508\ndeleted backup piece\nbackup piece handle=0n03vkl2_23_1_1 RECID=23 STAMP=1077924515\ndeleted backup piece\nbackup piece handle=0o03vklr_24_1_1 RECID=24 STAMP=1077924541\ndeleted backup piece\nbackup piece handle=0p03vkmu_25_1_1 RECID=25 STAMP=1077924576\ndeleted backup piece\nbackup piece handle=0p03vkmu_25_2_1 RECID=26 STAMP=1077924601\ndeleted backup piece\nbackup piece handle=0r03vko7_27_1_1 RECID=27 STAMP=1077924616\ndeleted backup piece\nbackup piece handle=0r03vko7_27_2_1 RECID=28 STAMP=1077924624\ndeleted backup piece\nbackup piece handle=0t03vkoh_29_1_1 RECID=29 STAMP=1077924627\nDeleted 10 objects\n \n \nRMAN> DELETE BACKUPSET TAG DB_DSK;\n \nusing channel ORA_DISK_1\nusing channel ORA_SBT_TAPE_1\n \nList of Backup Pieces\nBP Key  BS Key  Pc# Cp# Status      Device Type Piece Name\n------- ------- --- --- ----------- ----------- ----------\n31      27      1   1   AVAILABLE   DISK        +RECO\/db0v03vkvi_31_1_1\n32      28      1   1   AVAILABLE   DISK        +RECO\/db1003vl0l_32_1_1\n33      29      1   1   AVAILABLE   DISK        +RECO\/db1103vl14_33_1_1\n \nDo you really want to delete the above objects (enter YES or NO)? y\ndeleted backup piece\nbackup piece handle=+RECO\/db0v03vkvi_31_1_1 RECID=31 STAMP=1077924852\ndeleted backup piece\nbackup piece handle=+RECO\/db1003vl0l_32_1_1 RECID=32 STAMP=1077924887\ndeleted backup piece\nbackup piece handle=+RECO\/db1103vl14_33_1_1 RECID=33 STAMP=1077924902\nDeleted 3 objects\n<\/pre><\/div>\n\n\n
    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":"
    O objetivo de hoje \u00e9 realizar o backup de um DB System do OCI utilizando apenas o RMAN, enviando os backup pieces para um bucket no Object Storage. Na console inicial, vamos no Menu principal, clicamos em Storage -> Object Storage: Clicando em Create Bucket: Definindo o nome do Bucket e clicando em Create: Clicando […]<\/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-5809","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\/5809","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=5809"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/5809\/revisions"}],"predecessor-version":[{"id":9079,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/5809\/revisions\/9079"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=5809"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=5809"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=5809"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}