Operation Steps: (Open archive)
In either node operation:
[[email protected] ~]$ srvctl stop database -d mecbs[[email protected] ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on mon sep 14 23:24:19 2015copyright (c) 1982, 2013, oracle. all rights reserved. Connected to an idle instance. Sql> startup mount;oracle instance started. total system global area 776646656 bytesfixed size 2257272 bytesVariable Size 570429064 bytesDatabase buffers 197132288 bytesredo buffers 6828032 bytesdatabase mounted. sql> alter system set log_archive_dest_1= ' location=+arch ' scope=spfile sid= ' * ‘; System altered. Sql> alter system set cluster_database=false scope=spfile; System altered. Sql> alter database archivelog;database altered. Sql> alter database open;database altered. sql> alter system set cluster_database=true scope=spfile; System altered. Sql> shutdow immediate;database closed. Database dismounted. Oracle instance shut down. Sql> startuporacle instance started. Sql> startuporacle instance started. total system global area 776646656 bytesfixed size 2257272 bytesVariable Size 570429064 bytesDatabase buffers 197132288 bytesredo buffers 6828032 bytesdatabase mounted. database opened. sql> archive log list;database log mode Archive ModeAutomatic archival enabledarchive destination +archoldest online log sequence 4Next log sequence to archive 5current log sequence 5 Open Other nodes ...
Turn on database flashback:
[[Email protected] ~]$ srvctl stop database -d mecbssql> startup mount;oracle instance started. total system global area 776646656 bytesfixed size 2257272 bytesVariable Size 541068936 bytesDatabase buffers 230686720 bytesredo buffers 2633728 bytesdatabase mounted. Sql> alter system set db_recovery_file_dest_size=10g scope=spfile sid= ' * '; System altered. sql> alter system set db_recovery_file_dest= ' +fra ' scope=spfile sid= ' * '; System altered. Sql> shutdown immediate;ora-01109: database not opendatabase dismounted. Oracle instance shut downsql> startup mount;oracle instance started. total system global  area 776646656 bytesfixed size 2257272 bytesvariable size 541068936 bytesdatabase buffers 230686720 bytesredo buffers 2633728 bytesdatabase Mounted. sql> alter database flashback on; Sql> alter database open;database altered. sql> show parameter db_recovery;name type value------------------------------------ ----------- ------------------------ ------Db_recovery_file_dest string +fradb_recovery_file_ Dest_size big integer 10gsql> archive log list ;D atabase log mode archive modeautomatic Archival enabledarchive destination +archoldest online log sequence 5next log sequence to archive 6Current log sequence 6ASMCMD [+ARCH/MECBS/ARCHIVELOG] > du Used_MB Mirror_used_MB 9 9asmcmd [+fra/mecbs/ flashback] > du used_mb mirror_used_mb 204 204
=======end=========
Oracle 11g RAC Open Archive, flash back and set different paths