HOW TO ENABLE FRA IN RAC

SQL> show parameter db_recovery_;

NAME                                 TYPE        VALUE
------------------------------------ ----------- -------------           -----------------
db_recovery_file_dest                string
db_recovery_file_dest_size           big integer 0

FROM ANY NODE

SQL> alter system set db_recovery_file_dest_size=20g scope=spfile sid='*';

System altered.

SQL> alter system set db_recovery_file_dest='+FRA' scope=spfile sid='*';

System altered.

SQL>

[oracle@rac1pub111 u01]$ srvctl stop database -d DEV
[oracle@rac1pub111 u01]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sat Aug 12 22:27:59 2017

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

Connected to an idle instance.

SQL> startup mount;
ORACLE instance started.

Total System Global Area 1653518336 bytes
Fixed Size                  2253784 bytes
Variable Size            1040190504 bytes
Database Buffers          603979776 bytes
Redo Buffers                7094272 bytes
Database mounted.
SQL> alter database flashback on;

Database altered.

SQL> select flashback_on from v$database;

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

SQL>

[oracle@rac1pub111 u01]$ srvctl stop database -d DEV
[oracle@rac1pub111 u01]$ srvctl start database -d DEV
[oracle@rac1pub111 u01]$ srvctl status database -d DEV
Instance DEV1 is running on node rac1pub111
Instance DEV2 is running on node rac2pub112
[oracle@rac1pub111 u01]$


[oracle@rac2pub112 admin]$ !sq
sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sat Aug 12 22:33:51 2017

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


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

SQL>  select flashback_on from v$database;

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

SQL>