Rogerio Antonio

EnglishVersion Neste post partilho como como usar tecnologia flashback - neste caso flashback database Como exemplo vou mostar como ajuda num dos piores cenarios - num truncate O Truncate e muito usado para limpar as tabelas, nao so os dados mas os segmentos. para recuperar de um trunncate e necessario restaurar a base de dados. Importante flashback database e necessario para operacoes de failover do data guard. Activar flashback database Requisitos para flashback database - A base de dados em archivelog mode - tradicional archive redo logs - Feature flashback activada - stream the logs / flashback logs Para isso e necessario reiniciar a base de dados de uma forma consistente Vou criar tambem um RESTORE POINT com opcao GUARANTEE FLASHBACK DATABASE -- As '/ as sysdba', SQL> shut immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount; ORACLE instance started. Total System Global Area 849530880 byt...

Versao Portuguesa Have been thinking for awile to post about Data Guard,  more specifically about  to created a physical standby.  So, today is the day, the aim of this post is not to destille  Data Guard, for better undestanding lets recap some Data Guard concepts. Data Guard allows database replication sending  and applying redo log info from a site to another, keeping in that way the data replicated and available  in the case the main site is not available.

EnglishVersion Ha algum tempo que andava para publicar um post sobre a solucao de disaster/recover da Oracle, Data Guard (DG). O objectivo deste post nao e destilar o Data Guard, mas para entender melhor e necessario  rever algums conceitos. Recap,   Data Guard permite enviar a informacao de log de site/data center  – principal para  outro dedicado a recovery, protegendo dessa forma os dados em caso de indisponiblilidade ou perca do site principal.

EnglishVersion This post is about using flashback technology for recover a database, using as example, how to recover a table after truncate. Truncate is used to clean the tables, it also cleans the table segments. To recover trucated data requires to .. recover the database. Important note : flashback database is a must in case of failover in data guard operations. Flashback requirements It have some requirements for flashback database - The DB needs to be in archive log mode -the traditional archive redo logs - Feature flashback ON - it will activate the stream the logs / flashback logs For all this work the database needs to be mounted in a consitant maner To help with demo I will also create a RESTORE POINT with GUARANTEE FLASHBACK DATABASE -- As '/ as sysdba', SQL> shut immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount; ORACLE instance started. Total System Global...