Alguns comandos emitidos no banco de dados podem, de forma premeditada, n\u00e3o gerar os vetores de mudan\u00e7as nos redo logs (talvez por buscarem mais “performance” na opera\u00e7\u00e3o), e desse modo, n\u00e3o permitem a recupera\u00e7\u00e3o de um datafile (ou mais) em caso de desastre. Para precaver os administradores do banco de dados, o comando REPORT possui uma m\u00e9todo de consulta para nos reportar os datafiles que se encontram nessa situa\u00e7\u00e3o. Geralmente, ap\u00f3s isso \u00e9 necess\u00e1rio realizar um backup do mesmo para garantirmos a prote\u00e7\u00e3o total dos dados. Neste artigo vamos mostrar um exemplo simples desse mecanismo.<\/p>\n\n\n\n
Criando uma tabela com a op\u00e7\u00e3o NOLOGGING:<\/p>\n\n\n
\n[oracle@oel8 ~]$ sqlplus \/ as sysdba\n \nSQL*Plus: Release 18.0.0.0.0 - Production on Fri Apr 9 21:00:39 2021\nVersion 18.13.0.0.0\n \nCopyright (c) 1982, 2018, Oracle. All rights reserved.\n \n \nConnected to:\nOracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production\nVersion 18.13.0.0.0\n \nSQL> CREATE TABLE TESTE.BSS NOLOGGING TABLESPACE USERS AS SELECT * FROM DBA_OBJECTS;\n \nTable created.\n<\/pre><\/div>\n\n\nEmitindo o comando abaixo no RMAN para vermos o datafile reportado:<\/p>\n\n\n
\n[oracle@oel8 ~]$ rman target \/\n \nRecovery Manager: Release 18.0.0.0.0 - Production on Fri Apr 9 21:01:34 2021\nVersion 18.13.0.0.0\n \nCopyright (c) 1982, 2018, Oracle and\/or its affiliates. All rights reserved.\n \nconnected to target database: RMANDB (DBID=3825250984)\n \nRMAN> REPORT UNRECOVERABLE;\n \nusing target database control file instead of recovery catalog\nReport of files that need backup due to unrecoverable operations\nFile Type of Backup Required Name\n---- ----------------------- -----------------------------------\n7 full or incremental \/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\n<\/pre><\/div>\n\n\nRealizando backup da tablespace USERS:<\/p>\n\n\n
\nRMAN> BACKUP TABLESPACE USERS;\n \nStarting backup at 2021-04-09:21:02:17\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=81 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=\/oracle\/dados\/RMANDB\/datafile\/o1_mf_users_h8nyrkn7_.dbf\nchannel ORA_DISK_1: starting piece 1 at 2021-04-09:21:02:17\nchannel ORA_DISK_1: finished piece 1 at 2021-04-09:21:02:18\npiece handle=\/oracle\/fra\/RMANDB\/backupset\/2021_04_09\/o1_mf_nnndf_TAG20210409T210217_j71trb3c_.bkp tag=TAG20210409T210217 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 2021-04-09:21:02:18\n \nStarting Control File and SPFILE Autobackup at 2021-04-09:21:02:19\npiece handle=\/oracle\/fra\/RMANDB\/autobackup\/2021_04_09\/o1_mf_s_1069448539_j71trcgz_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 2021-04-09:21:02:22\n<\/pre><\/div>\n\n\nAgora o datafile tem garantias de recuperabilidade:<\/p>\n\n\n
\nRMAN> REPORT UNRECOVERABLE;\n \nReport of files that need backup due to unrecoverable operations\nFile Type of Backup Required Name\n---- ----------------------- -----------------------------------\n \nRMAN>\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":"
Alguns comandos emitidos no banco de dados podem, de forma premeditada, n\u00e3o gerar os vetores de mudan\u00e7as nos redo logs (talvez por buscarem mais “performance” na opera\u00e7\u00e3o), e desse modo, n\u00e3o permitem a recupera\u00e7\u00e3o de um datafile (ou mais) em caso de desastre. Para precaver os administradores do banco de dados, o comando REPORT possui […]<\/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-3674","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\/3674","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=3674"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/3674\/revisions"}],"predecessor-version":[{"id":9180,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/3674\/revisions\/9180"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=3674"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=3674"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=3674"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}