12c rac開閃回

一、步驟
1.關(guān)閉節(jié)點二
2.配置相關(guān)參數(shù)
3.關(guān)閉節(jié)點1
4.啟用閃回
5.打開節(jié)點二

二、操作過程

[root@rac01 ~]# su - oracle
Last login: Thu Jan  4 10:33:31 CST 2018 on pts/2
<rac01:orcl1:/home/oracle>$sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Fri Jan 5 18:52:55 2018

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, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options

SYS@orcl1> 
SYS@orcl1> 
SYS@orcl1> 
SYS@orcl1> show parameter recovery

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string
db_recovery_file_dest_size           big integer 0
recovery_parallelism                 integer     0
SYS@orcl1> show parameter flashback

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_flashback_retention_target        integer     1440
SYS@orcl1> alter system set db_recovery_file_dest_size=1g;

System altered.

SYS@orcl1> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            +DATADG
Oldest online log sequence     121
Next log sequence to archive   122
Current log sequence           122
SYS@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 bytes
Fixed Size                  2923872 bytes
Variable Size             620757664 bytes
Database Buffers          603979776 bytes
Redo Buffers               13852672 bytes
Database 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
------------------
YES

SYS@orcl1> show parameter recovery

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      +datadg
db_recovery_file_dest_size           big integer 1G
recovery_parallelism                 integer     0
SYS@orcl1> show parameter flashback

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_flashback_retention_target        integer     2880
SYS@orcl1> 

小結(jié)：
生產(chǎn)環(huán)境ADG備庫開閃回解決邏輯錯誤。未來再添加一個備庫，做災(zāi)備，一主兩備哈