Full Database Caching Mode

Enable Force Full Database Caching Mode
 
[oracle@localhost~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Thu Jul 31 05:09:01 2014
Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select force_full_db_caching from v$database;
FOR
—
NO

SQL> alter database force full database caching;
alter database force full database caching
*
ERROR at line 1:
ORA-01126: database must be mounted in this instance and not open in any
instance

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 1644167168 bytes
Fixed Size                  2925024 bytes
Variable Size            1375735328 bytes
Database Buffers          251658240 bytes
Redo Buffers               13848576 bytes
Database mounted.
SQL> alter database force full database caching;
Database altered.
SQL> alter database open;
Database altered.
SQL> select force_full_db_caching from v$database;
FOR
—
YES
 
Disable Force Full Database Caching Mode
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 1644167168 bytes
Fixed Size                  2925024 bytes
Variable Size            1375735328 bytes
Database Buffers          251658240 bytes
Redo Buffers               13848576 bytes
Database mounted.
SQL> alter database no force full database caching;
Database altered.
SQL> alter database open;
Database altered.
SQL> select force_full_db_caching from v$database;
FOR
—
NO