Juan Andres Mercado Oracle Blog – IT Buenos Aires

Troubleshooting daily on Oracle Systems, Linux & more !

Monthly Archives: March 2011

FlashBack Database On

Vamos a configurar la base en modo flashback .

Primero ejecutamos una consulta para conocer si el flashback esta activo o no.

[oracle@sdat0808lx ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Apr 14 14:50:10 2011

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options

SQL> select flashback_on from v$database ;

FLASHBACK_ON
------------------
NO

Read more of this post

%d bloggers like this: