12c rac开闪回

一、步骤
1.关闭节点二
2.配置相关参数
3.关闭节点1
4.启用闪回
5.打开节点二

二、操作过程

[root@rac01 ~]# su - oracleLast login: Thu Jan  4 10:33:31 CST 2018 on pts/2$sqlplus / as sysdbaSQL*Plus: Release 12.1.0.2.0 Production on Fri Jan 5 18:52:55 2018Copyright (c) 1982, 2014, Oracle.  All rights reserved.Connected to:Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,Advanced Analytics and Real Application Testing optionsSYS@orcl1> SYS@orcl1> SYS@orcl1> SYS@orcl1> show parameter recoveryNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------db_recovery_file_dest                stringdb_recovery_file_dest_size           big integer 0recovery_parallelism                 integer     0SYS@orcl1> show parameter flashbackNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------db_flashback_retention_target        integer     1440SYS@orcl1> alter system set db_recovery_file_dest_size=1g;System altered.SYS@orcl1> archive log list;Database log mode              Archive ModeAutomatic archival             EnabledArchive destination            +DATADGOldest online log sequence     121Next log sequence to archive   122Current log sequence           122SYS@orcl1> alter system set db_recovery_file_dest='+datadg';System altered.SYS@orcl1> alter system set db_flashback_retention_target=2880;System altered.SYS@orcl1> shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SYS@orcl1> startup mount;ORACLE instance started.Total System Global Area 1241513984 bytesFixed Size                  2923872 bytesVariable Size             620757664 bytesDatabase Buffers          603979776 bytesRedo Buffers               13852672 bytesDatabase mounted.SYS@orcl1> alter database flashback on;Database altered.SYS@orcl1> alter database open;Database altered.SYS@orcl1> select flashback_on from v$database;FLASHBACK_ON------------------YESSYS@orcl1> show parameter recoveryNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------db_recovery_file_dest                string      +datadgdb_recovery_file_dest_size           big integer 1Grecovery_parallelism                 integer     0SYS@orcl1> show parameter flashbackNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------db_flashback_retention_target        integer     2880SYS@orcl1> 

小结：
生产环境ADG备库开闪回解决逻辑错误。未来再添加一个备库，做灾备，一主两备哈