This procedure outlines the steps to disable flashback on an oracle 12c database.

 

 

1. Logon to server as the oracle software owner.

 

[root@orcl-db1 devadmin]# su – oracle

Last login: Mon Jan 19 18:31:43 UTC 2016 on pts/0

mylinux#

 

 

2. Open the oracle database in mount mode.

 

SQL> startup mount

ORACLE instance started.

Total System Global Area 5.1540E+10 bytes

Fixed Size                  2938792 bytes

Variable Size            3.4628E+10 bytes

Database Buffers         1.6777E+10 bytes

Redo Buffers              131276800 bytes

Database mounted.

SQL>

 

3. Disable flashback for database with ALTER DATABASE command.

 

SQL> alter database flashback off;

Database altered.

SQL>

 

4. Open the database.

 

SQL> alter database open;

Database altered.

SQL>

 

 

5. This completes disabling flashback in Oracle 12c database.

 

Larry Catt

OCP