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

Reiniciamos la base en modo MOUNT.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup mount
ORACLE instance started.
Total System Global Area  464519168 bytes
Fixed Size		    1337240 bytes
Variable Size		  260049000 bytes
Database Buffers	  197132288 bytes
Redo Buffers		    6000640 bytes
Database mounted.

Activamos el flashback.

SQL> ALTER DATABASE FLASHBACK ON;

Database altered.

Abrimos la base

SQL> ALTER DATABASE OPEN ;

Database altered.

Consultamos la base para ver que se haya impactado el cambio.

SQL> select flashback_on from v$database ;

FLASHBACK_ON
------------------
YES

Ya estamos con la base en modoFLASHBACK ON y podemos comenzar a utilizar como mejor se adapte a nuestra necesidad.