{"id":2584,"date":"2020-02-19T10:51:00","date_gmt":"2020-02-19T13:51:00","guid":{"rendered":"https:\/\/zmsolution.laraclaud.com.br\/?p=2584"},"modified":"2020-02-19T10:51:00","modified_gmt":"2020-02-19T13:51:00","slug":"criando-um-restore-point","status":"publish","type":"post","link":"http:\/\/zmsolution.com\/criando-um-restore-point\/","title":{"rendered":"Criando um Restore Point"},"content":{"rendered":"<p>Um restore point j\u00e1 existe algum tempo no Oracle, mais muita gente ainda tem bastante duvida na sua utiliza\u00e7\u00e3o, algum tempo atras eu utilizava bastante esse recurso nas minhas bases de homologa\u00e7\u00e3o, Antes de cada nova vers\u00e3o ser aplicada no sistema, existia o habito de criar um restore point, Isso nos ajudava a\u00a0 voltar a base rapidamente se ocorre-se algum problema na aplica\u00e7\u00e3o da vers\u00e3o ou nos testes, Hoje mudamos isso com a cria\u00e7\u00e3o de snapshots de banco de dados, mais esse papo para outro momento&#8230;<\/p>\n<p><strong>Mais agora vamos ver como criar um\u00a0Restore Point ou mais conhecido como\u00a0Flashback Database Restore Point<\/strong><\/p>\n<p>Alter os par\u00e2metros abaixo:<\/p>\n<p>Configurando a area de archivelog<\/p>\n<pre class=\"lang:default decode:true \">log_archive_dest_1='LOCATION=\/u01\/app\/oracle\/oradata\/oca12c\/' scope=spfile;\r\n\r\nalter system set log_archive_dest_state_1='ENABLE' scope=spfile;\r\n\r\nConfigurando a area de Flashback\u00a0\r\nalter system set db_recovery_file_dest = '\/u01\/app\/oracle\/oradata\/oca12c\/' scope=spfile;\r\n\r\nalter system set db_recovery_file_dest_size = 10G scope=spfile;\r\n\r\nalter system set db_flashback_retention_target=240 scope=spfile;\r\n\r\nsqlplus \/ as sysdba\r\n\r\nshutdown immediate\r\nstartup mount;<\/pre>\n<p><strong>Habilitando o Archivelog<\/strong><\/p>\n<pre class=\"lang:default decode:true \">sqlplus \/ as sysdba\r\n\r\nalter database archivelog;<\/pre>\n<p><strong>Habilitando o\u00a0flashback\u00a0<\/strong><\/p>\n<pre class=\"lang:default decode:true \">sqlplus \/ as sysdba\r\n\r\nalter database flashback on;<\/pre>\n<p><strong>Abrindo o banco de dados<\/strong><\/p>\n<pre class=\"lang:default decode:true \">sqlplus \/ as sysdba\r\n\r\nalter database open;<\/pre>\n<p><strong>For\u00e7ando a gera\u00e7\u00e3o de archivelog<\/strong><\/p>\n<pre class=\"lang:default decode:true \">sqlplus \/ as sysdba\r\nalter system switch logfile;\r\nalter system switch logfile;\r\nalter system switch logfile;\r\nalter system switch logfile;<\/pre>\n<p><strong>Crie 3 tabelas novas<\/strong><\/p>\n<pre class=\"lang:default decode:true \">sqlplus \/ as sysdba\r\nalter system switch logfile;\r\nalter system switch logfile;\r\nalter system switch logfile;<\/pre>\n<p><strong>Criei um restore point\u00a0<\/strong><\/p>\n<pre class=\"lang:default decode:true \">sqlplus \/ as sysdba\r\n\r\ncreate restore point VERSION_2_108_1_0 guarantee flashback database;<\/pre>\n<p><strong>Drop as tr\u00eas tabelas<\/strong><\/p>\n<p><strong>Volte o momento antes do drop das tabelas\u00a0<\/strong><\/p>\n<pre class=\"lang:default decode:true\">sqlplus \/ as sysdba\r\nshutdown immediate\r\nstartup mount\r\nflashback database to restore point VERSION_2_108_1_0;\r\nshutdown immediate\r\nstartup mount\r\nalter database open resetlogs;<\/pre>\n<p><strong>Verifique se as tabelas voltaram.<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Um restore point j\u00e1 existe algum tempo no Oracle, mais muita gente ainda tem bastante duvida na sua utiliza\u00e7\u00e3o, algum tempo atras eu utilizava bastante esse recurso nas minhas bases de homologa\u00e7\u00e3o, Antes de cada nova vers\u00e3o ser aplicada no sistema, existia o habito de criar um restore point, Isso nos ajudava a\u00a0 voltar a base rapidamente se ocorre-se algum problema na aplica\u00e7\u00e3o da vers\u00e3o ou nos testes, Hoje mudamos isso com a cria\u00e7\u00e3o de[&#8230;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0},"categories":[21],"tags":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/posts\/2584"}],"collection":[{"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/comments?post=2584"}],"version-history":[{"count":0,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/posts\/2584\/revisions"}],"wp:attachment":[{"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/media?parent=2584"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/categories?post=2584"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/tags?post=2584"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}