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 In this post i'm sharing how to unlock database accounts  - even when the password is not known.

EnglishVersion Neste post parilho como copiar dados entre bases de dados em diferentes plataformas. Como nao tenho uma maquina HP-UX .. vou ter que criar datafile para HP-UX, e depois o inverso

Versao Portuguesa In this post i'm sharing how to copy data /tablespaces between databases in different platforms as I've no HP-UX here at home .. I will have to convert a tablespace to HP-UX, then to convert the datafile back to Linux

EnglishVersion A Oracle disponibiliza uma forma interessante de copiar aplicacoes / dados entre as bases de dados, chama-se TTS ( Transportable Tablespace). Basicamente exporta-se um dump com metadata do tablespace. Com esse dump + data file (s) e possivel carregar os dados noutra base de dados.

EnglishVersion Oracle allows a nice way to copy aplication / data between databases, is known as TTS ( Transportable Tablespace). Basically is to export a dump with tablespace's metadata and copy the datafile(s). With that dump + data file (s) associated to the tablespace is possible to attach the tablespace to another database.

EnglishVersion Neste post escrevo como restaurar contas "lockadas" - mesmo quando nao se sabe a password do utilizador.

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...

PT :   Brincar com ARCHIVED LOGs EN :  Play with ARCHIVED LOGs