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.
One thought on “FlashBack Database On”
Comments are closed.