Uma alternativa para os comandos executados manualmente no RMAN, seriam os Stored Scripts, que nada mais s\u00e3o do que estes mesmos comandos encapsulados\/armazenados dentro do pr\u00f3prio RMAN. Este recurso est\u00e1 dispon\u00edvel para qualquer cliente RMAN que possa se conectar em algum target database ou cat\u00e1logo. Al\u00e9m disso, temos 2 categorias de SS: Locais (que \u00e9 associado com o target database usado quando o script foi criado) ou Globais (que pode ser executado em qualquer database registrado no cat\u00e1logo). Neste artigo vamos explorar um pouco esse recurso, usando exemplos de SS locais.<\/p>\n\n\n\n
Criando um Stored Script:<\/p>\n\n\n
\n[oracle@oel7 ~]$ rman target \/ catalog CORTEX_CATALOG\/CORTEX_CATALOG@RMANDB\n \nRecovery Manager: Release 19.0.0.0.0 - Production on Wed Jun 9 05:15:39 2021\nVersion 19.3.0.0.0\n \nCopyright (c) 1982, 2019, Oracle and\/or its affiliates. All rights reserved.\n \nconnected to target database: CORTEX (DBID=548968087)\nconnected to recovery catalog database\n \nRMAN> CREATE SCRIPT FULL_DB_SCRIPT\n{ BACKUP DATABASE PLUS ARCHIVELOG TAG 'FULL_DB'; }2>\n \ncreated script FULL_DB_SCRIPT\n<\/pre><\/div>\n\n\nPodemos validar a sua cria\u00e7\u00e3o com o comando LIST:<\/p>\n\n\n
\nRMAN> LIST SCRIPT NAMES;\n \nList of Stored Scripts in Recovery Catalog\n \n \n Scripts of Target Database CORTEX\n \n Script Name\n Description\n -----------------------------------------------------------------------\n FULL_DB_SCRIPT\n<\/pre><\/div>\n\n\nConseguimos visualizar o conte\u00fado do SS com o comando print:<\/p>\n\n\n
\nRMAN> PRINT SCRIPT FULL_DB_SCRIPT;\n \nprinting stored script: FULL_DB_SCRIPT\n{ BACKUP DATABASE PLUS ARCHIVELOG TAG 'FULL_DB'; }\n<\/pre><\/div>\n\n\nPara execut\u00e1-lo, usamos o comando abaixo:<\/p>\n\n\n
\nRMAN> run { execute script FULL_DB_SCRIPT;}\n \nexecuting script: FULL_DB_SCRIPT\n \n \nStarting backup at 09-JUN-21\ncurrent log archived\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=88 device type=DISK\nchannel ORA_DISK_1: starting archived log backup set\nchannel ORA_DISK_1: specifying archived log(s) in backup set\ninput archived log thread=1 sequence=5 RECID=1 STAMP=1039127675\ninput archived log thread=1 sequence=6 RECID=2 STAMP=1039295758\ninput archived log thread=1 sequence=7 RECID=3 STAMP=1039296485\ninput archived log thread=1 sequence=8 RECID=4 STAMP=1039301471\ninput archived log thread=1 sequence=9 RECID=5 STAMP=1039303921\ninput archived log thread=1 sequence=10 RECID=6 STAMP=1039304261\ninput archived log thread=1 sequence=11 RECID=7 STAMP=1039369019\ninput archived log thread=1 sequence=12 RECID=8 STAMP=1039371217\ninput archived log thread=1 sequence=13 RECID=9 STAMP=1039371935\ninput archived log thread=1 sequence=14 RECID=10 STAMP=1039725409\ninput archived log thread=1 sequence=15 RECID=11 STAMP=1039810779\ninput archived log thread=1 sequence=16 RECID=12 STAMP=1041718798\ninput archived log thread=1 sequence=17 RECID=13 STAMP=1060626438\ninput archived log thread=1 sequence=18 RECID=14 STAMP=1060987482\ninput archived log thread=1 sequence=19 RECID=15 STAMP=1061073000\ninput archived log thread=1 sequence=20 RECID=16 STAMP=1065501952\ninput archived log thread=1 sequence=21 RECID=17 STAMP=1065506515\ninput archived log thread=1 sequence=22 RECID=18 STAMP=1065506554\ninput archived log thread=1 sequence=23 RECID=19 STAMP=1071811097\ninput archived log thread=1 sequence=24 RECID=20 STAMP=1071811858\ninput archived log thread=1 sequence=25 RECID=21 STAMP=1071812134\ninput archived log thread=1 sequence=26 RECID=22 STAMP=1073535805\ninput archived log thread=1 sequence=27 RECID=23 STAMP=1073625862\ninput archived log thread=1 sequence=28 RECID=24 STAMP=1074747851\ninput archived log thread=1 sequence=29 RECID=25 STAMP=1074748747\nchannel ORA_DISK_1: starting piece 1 at 09-JUN-21\nchannel ORA_DISK_1: finished piece 1 at 09-JUN-21\npiece handle=+DG_FRA\/CORTEX\/BACKUPSET\/2021_06_09\/annnf0_full_db_0.260.1074748749 tag=FULL_DB comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:45\nFinished backup at 09-JUN-21\n \nStarting backup at 09-JUN-21\nusing channel ORA_DISK_1\nchannel ORA_DISK_1: starting full datafile backup set\nchannel ORA_DISK_1: specifying datafile(s) in backup set\ninput datafile file number=00001 name=+DG_DATA\/CORTEX\/DATAFILE\/system.256.1039033445\ninput datafile file number=00005 name=+DG_DATA\/CORTEX\/DATAFILE\/soe.266.1065506205\ninput datafile file number=00003 name=+DG_DATA\/CORTEX\/DATAFILE\/sysaux.257.1039033519\ninput datafile file number=00004 name=+DG_DATA\/CORTEX\/DATAFILE\/undotbs1.258.1039033555\ninput datafile file number=00007 name=+DG_DATA\/CORTEX\/DATAFILE\/users.259.1039033555\nchannel ORA_DISK_1: starting piece 1 at 09-JUN-21\nchannel ORA_DISK_1: finished piece 1 at 09-JUN-21\npiece handle=+DG_FRA\/CORTEX\/BACKUPSET\/2021_06_09\/nnndf0_tag20210609t051955_0.261.1074748797 tag=TAG20210609T051955 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:02:05\nFinished backup at 09-JUN-21\n \nStarting backup at 09-JUN-21\ncurrent log archived\nusing channel ORA_DISK_1\nchannel ORA_DISK_1: starting archived log backup set\nchannel ORA_DISK_1: specifying archived log(s) in backup set\ninput archived log thread=1 sequence=30 RECID=26 STAMP=1074748921\nchannel ORA_DISK_1: starting piece 1 at 09-JUN-21\nchannel ORA_DISK_1: finished piece 1 at 09-JUN-21\npiece handle=+DG_FRA\/CORTEX\/BACKUPSET\/2021_06_09\/annnf0_full_db_0.262.1074748923 tag=FULL_DB comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 09-JUN-21\n \nStarting Control File and SPFILE Autobackup at 09-JUN-21\npiece handle=+DG_FRA\/CORTEX\/AUTOBACKUP\/2021_06_09\/s_1074748924.263.1074748927 comment=NONE\nFinished Control File and SPFILE Autobackup at 09-JUN-21\n<\/pre><\/div>\n\n\nValidando os elementos de backup criados:<\/p>\n\n\n
\nRMAN> LIST BACKUPSET TAG 'FULL_DB';\n \n \nList of Backup Sets\n===================\n \n \nBS Key Size Device Type Elapsed Time Completion Time\n------- ---------- ----------- ------------ ---------------\n262 948.10M DISK 00:00:41 09-JUN-21\n BP Key: 263 Status: AVAILABLE Compressed: NO Tag: FULL_DB\n Piece Name: +DG_FRA\/CORTEX\/BACKUPSET\/2021_06_09\/annnf0_full_db_0.260.1074748749\n \n List of Archived Logs in backup set 262\n Thrd Seq Low SCN Low Time Next SCN Next Time\n ---- ------- ---------- --------- ---------- ---------\n 1 5 2017317 29-APR-20 2143151 30-APR-20\n 1 6 2143151 30-APR-20 2291543 01-MAY-20\n 1 7 2291543 01-MAY-20 2392920 01-MAY-20\n 1 8 2392920 01-MAY-20 2505442 01-MAY-20\n 1 9 2505442 01-MAY-20 2608402 01-MAY-20\n 1 10 2608402 01-MAY-20 2709343 01-MAY-20\n 1 11 2709343 01-MAY-20 2810234 02-MAY-20\n 1 12 2810234 02-MAY-20 2926273 02-MAY-20\n 1 13 2926273 02-MAY-20 3027319 02-MAY-20\n 1 14 3027319 02-MAY-20 3138045 06-MAY-20\n 1 15 3138045 06-MAY-20 3258948 07-MAY-20\n 1 16 3258948 07-MAY-20 3369054 29-MAY-20\n 1 17 3369054 29-MAY-20 3474226 31-DEC-20\n 1 18 3474226 31-DEC-20 3575887 04-JAN-21\n 1 19 3575887 04-JAN-21 3693929 05-JAN-21\n 1 20 3693929 05-JAN-21 3804163 26-FEB-21\n 1 21 3804163 26-FEB-21 3812081 26-FEB-21\n 1 22 3812081 26-FEB-21 3815548 26-FEB-21\n 1 23 3815548 26-FEB-21 3928583 06-MAY-21\n 1 24 3928583 06-MAY-21 3931358 06-MAY-21\n 1 25 3931358 06-MAY-21 3932493 06-MAY-21\n 1 26 3932493 06-MAY-21 4032810 26-MAY-21\n 1 27 4032810 26-MAY-21 4138313 27-MAY-21\n 1 28 4138313 27-MAY-21 4239416 09-JUN-21\n 1 29 4239416 09-JUN-21 4241913 09-JUN-21\n \nBS Key Size Device Type Elapsed Time Completion Time\n------- ---------- ----------- ------------ ---------------\n334 49.50K DISK 00:00:00 09-JUN-21\n BP Key: 340 Status: AVAILABLE Compressed: NO Tag: FULL_DB\n Piece Name: +DG_FRA\/CORTEX\/BACKUPSET\/2021_06_09\/annnf0_full_db_0.262.1074748923\n \n List of Archived Logs in backup set 334\n Thrd Seq Low SCN Low Time Next SCN Next Time\n ---- ------- ---------- --------- ---------- ---------\n 1 30 4241913 09-JUN-21 4242100 09-JUN-21\n<\/pre><\/div>\n\n\nCaso precisemos alterar o SS, podemos realizar a mudan\u00e7a com o comando REPLACE:<\/p>\n\n\n
\nRMAN> REPLACE SCRIPT FULL_DB_SCRIPT\nCOMMENT 'sem archivelog'\n{ BACKUP DATABASE TAG 'FULL_DB'; }2> 3>\n \nreplaced script FULL_DB_SCRIPT\n \nRMAN> PRINT SCRIPT FULL_DB_SCRIPT;\n \nprinting stored script: FULL_DB_SCRIPT\n{ BACKUP DATABASE TAG 'FULL_DB'; }\n<\/pre><\/div>\n\n\nAl\u00e9m de criar o SS digitando os comandos no prompt do RMAN, tamb\u00e9m podemos cri\u00e1-lo a partir de um arquivo externo. Basta que esse arquivo possua os comandos entre chaves, para que o SS os reconhe\u00e7a corretamente. Vamos simular isso:<\/p>\n\n\n
\n[oracle@oel7 ~]$ cd \/home\/oracle\/\n[oracle@oel7 ~]$ cat SS.txt\n{ BACKUP DATABASE TAG 'FULL_DB'; }\n<\/pre><\/div>\n\n\nCriando o SS a partir do arquivo acima:<\/p>\n\n\n
\n[oracle@oel7 ~]$ rman target \/ catalog CORTEX_CATALOG\/CORTEX_CATALOG@RMANDB\n \nRecovery Manager: Release 19.0.0.0.0 - Production on Wed Jun 9 05:32:43 2021\nVersion 19.3.0.0.0\n \nCopyright (c) 1982, 2019, Oracle and\/or its affiliates. All rights reserved.\n \nconnected to target database: CORTEX (DBID=548968087)\nconnected to recovery catalog database\n \nRMAN> CREATE SCRIPT BSS FROM FILE '\/home\/oracle\/SS.txt';\n \nscript commands will be loaded from file \/home\/oracle\/SS.txt\ncreated script BSS\n \nRMAN> LIST SCRIPT NAMES;\n \nList of Stored Scripts in Recovery Catalog\n \n \n Scripts of Target Database CORTEX\n \n Script Name\n Description\n -----------------------------------------------------------------------\n BSS\n \n FULL_DB_SCRIPT\n sem archivelog\n \nRMAN> PRINT SCRIPT BSS;\n \nprinting stored script: BSS\n{ BACKUP DATABASE TAG 'FULL_DB'; }\n \nRMAN> run { execute script BSS;}\n \nexecuting script: BSS\n \nStarting backup at 09-JUN-21\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=47 device type=DISK\nchannel ORA_DISK_1: starting full datafile backup set\nchannel ORA_DISK_1: specifying datafile(s) in backup set\ninput datafile file number=00001 name=+DG_DATA\/CORTEX\/DATAFILE\/system.256.1039033445\ninput datafile file number=00005 name=+DG_DATA\/CORTEX\/DATAFILE\/soe.266.1065506205\ninput datafile file number=00003 name=+DG_DATA\/CORTEX\/DATAFILE\/sysaux.257.1039033519\ninput datafile file number=00004 name=+DG_DATA\/CORTEX\/DATAFILE\/undotbs1.258.1039033555\ninput datafile file number=00007 name=+DG_DATA\/CORTEX\/DATAFILE\/users.259.1039033555\nchannel ORA_DISK_1: starting piece 1 at 09-JUN-21\nchannel ORA_DISK_1: finished piece 1 at 09-JUN-21\npiece handle=+DG_FRA\/CORTEX\/BACKUPSET\/2021_06_09\/nnndf0_full_db_0.264.1074749701 tag=FULL_DB comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:01:56\nFinished backup at 09-JUN-21\n \nStarting Control File and SPFILE Autobackup at 09-JUN-21\npiece handle=+DG_FRA\/CORTEX\/AUTOBACKUP\/2021_06_09\/s_1074749816.265.1074749819 comment=NONE\nFinished Control File and SPFILE Autobackup at 09-JUN-21\n<\/pre><\/div>\n\n\nUm recurso interessante do SS \u00e9 que o mesmo aceita vari\u00e1veis que podem ser populadas em tempo de execu\u00e7\u00e3o. Vamos criar um novo SS que nos permite testar isso. Importante dizer que, no momento de sua cria\u00e7\u00e3o, o valor das vari\u00e1veis \u00e9 solicitado, mas o script n\u00e3o \u00e9 disparado, e esses valores podem ser definidos depois em execu\u00e7\u00e3o. Ou seja, n\u00e3o precisamos nos preocupar, mesmo que os valores informados sejam aleat\u00f3rios:<\/p>\n\n\n
\nRMAN> CREATE SCRIPT TBS_FULL_SCRIPT\n{ BACKUP TABLESPACE &1 TAG &2 ;}2>\n \nEnter value for 1: USERS\n \nEnter value for 2: BSS\n \ncreated script TBS_FULL_SCRIPT\n<\/pre><\/div>\n\n\nExecutando o SS e passando os valores dos par\u00e2metros:<\/p>\n\n\n
\nRMAN> RUN { EXECUTE SCRIPT TBS_FULL_SCRIPT USING USERS 'SPFC';}\n \nexecuting script: TBS_FULL_SCRIPT\n \nStarting backup at 09-JUN-21\nusing channel ORA_DISK_1\nchannel ORA_DISK_1: starting full datafile backup set\nchannel ORA_DISK_1: specifying datafile(s) in backup set\ninput datafile file number=00007 name=+DG_DATA\/CORTEX\/DATAFILE\/users.259.1039033555\nchannel ORA_DISK_1: starting piece 1 at 09-JUN-21\nchannel ORA_DISK_1: finished piece 1 at 09-JUN-21\npiece handle=+DG_FRA\/CORTEX\/BACKUPSET\/2021_06_09\/nnndf0_spfc_0.266.1074750197 tag=SPFC comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 09-JUN-21\n \nStarting Control File and SPFILE Autobackup at 09-JUN-21\npiece handle=+DG_FRA\/CORTEX\/AUTOBACKUP\/2021_06_09\/s_1074750198.267.1074750199 comment=NONE\nFinished Control File and SPFILE Autobackup at 09-JUN-21\n<\/pre><\/div>\n\n\nListando o backup:<\/p>\n\n\n
\nRMAN> LIST BACKUPSET TAG 'SPFC';\n \n \nList of Backup Sets\n===================\n \n \nBS Key Type LV Size Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ ---------------\n394 Full 2.38M DISK 00:00:01 09-JUN-21\n BP Key: 397 Status: AVAILABLE Compressed: NO Tag: SPFC\n Piece Name: +DG_FRA\/CORTEX\/BACKUPSET\/2021_06_09\/nnndf0_spfc_0.266.1074750197\n List of Datafiles in backup set 394\n File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name\n ---- -- ---- ---------- --------- ----------- ------ ----\n 7 Full 4243110 09-JUN-21 NO +DG_DATA\/CORTEX\/DATAFILE\/users.259.1039033555\n<\/pre><\/div>\n\n\nOutro m\u00e9todo de disparo \u00e9 no momento de invocar o RMAN, conforme exemplo abaixo:<\/p>\n\n\n
\n[oracle@oel7 ~]$ rman target \/ catalog CORTEX_CATALOG\/CORTEX_CATALOG@RMANDB script=TBS_FULL_SCRIPT USING USERS 'SPFC'\n \nRecovery Manager: Release 19.0.0.0.0 - Production on Wed Jun 9 05:45:17 2021\nVersion 19.3.0.0.0\n \nCopyright (c) 1982, 2019, Oracle and\/or its affiliates. All rights reserved.\n \nconnected to target database: CORTEX (DBID=548968087)\nconnected to recovery catalog database\n \nexecuting script: TBS_FULL_SCRIPT\n \nStarting backup at 09-JUN-21\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=46 device type=DISK\nchannel ORA_DISK_1: starting full datafile backup set\nchannel ORA_DISK_1: specifying datafile(s) in backup set\ninput datafile file number=00007 name=+DG_DATA\/CORTEX\/DATAFILE\/users.259.1039033555\nchannel ORA_DISK_1: starting piece 1 at 09-JUN-21\nchannel ORA_DISK_1: finished piece 1 at 09-JUN-21\npiece handle=+DG_FRA\/CORTEX\/BACKUPSET\/2021_06_09\/nnndf0_spfc_0.268.1074750321 tag=SPFC comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 09-JUN-21\n \nStarting Control File and SPFILE Autobackup at 09-JUN-21\npiece handle=+DG_FRA\/CORTEX\/AUTOBACKUP\/2021_06_09\/s_1074750322.269.1074750323 comment=NONE\nFinished Control File and SPFILE Autobackup at 09-JUN-21\n \nRecovery Manager complete.\n[oracle@oel7 ~]$\n<\/pre><\/div>\n\n\nPara deletarmos os SS’s, basta usarmos o comando DELETE, vide abaixo:<\/p>\n\n\n
\nRMAN> DELETE SCRIPT BSS;\n \ndeleted script: BSS\n \nRMAN> DELETE SCRIPT FULL_DB_SCRIPT;\n \ndeleted script: FULL_DB_SCRIPT\n \nRMAN> DELETE SCRIPT TBS_FULL_SCRIPT;\n \ndeleted script: TBS_FULL_SCRIPT\n<\/pre><\/div>\n\n\nObs: 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":"
Uma alternativa para os comandos executados manualmente no RMAN, seriam os Stored Scripts, que nada mais s\u00e3o do que estes mesmos comandos encapsulados\/armazenados dentro do pr\u00f3prio RMAN. Este recurso est\u00e1 dispon\u00edvel para qualquer cliente RMAN que possa se conectar em algum target database ou cat\u00e1logo. Al\u00e9m disso, temos 2 categorias de SS: Locais (que \u00e9 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-5281","post","type-post","status-publish","format-standard","hentry","category-backup-recovery"],"_links":{"self":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/5281","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=5281"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/5281\/revisions"}],"predecessor-version":[{"id":9107,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/5281\/revisions\/9107"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=5281"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=5281"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=5281"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}