oracle 12c开启闪回,ORACLE 12C ADG 之十三 (ADG CDB级闪回（Flashback CDB）)

#CDB级闪回(Flashback CDB)

#主庫發佈前創建快照備份(發佈回退使用)

#停快速故障轉移功能

DGMGRL> stop observer

DGMGRL> disable fast_start failover;

#检查

[oracle@DB196 log]$sqlplus / as sysdba

SQL>select flashback_on from v$database;

YES

#主库停止日志传到从库

SQL> alter system set log_archive_dest_state_2=defer scope=both;

#创建担保还原点

SQL>CREATE RESTORE POINT guar_restore1 GUARANTEE FLASHBACK DATABASE;

#查询flashback模式

SQL> select flashback_on from v$database;

YES

# 开始CDB 及PDB变更，成功则删除担保还原点，反之失敗则回退，CDB及PDB都将恢复到快照担保还原点

SQL>shutdown immediate

SQL> startup mount;

SQL> select flashback_on from v$database;

YES

SQL> FLASHBACK database TO RESTORE POINT guar_restore1;

SQL> SHUTDOWN IMMEDIATE;

ORA-01109: database not open

SQL> startup

Database mounted.

ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> alter database open resetlogs;

#检查主库 数据库恢复到快照备份那刻状态，符合预期

SQL> alter system set log_archive_dest_state_2=enable scope=both;

#检查主备一致后删除还原点

SQL> drop RESTORE POINT guar_restore1;

#啟動快速故障轉移功能

DGMGRL> enable fast_start failover;

DGMGRL> start observer