在Data Guard环境中可以利用数据库的闪回特性将备库以读写模式打开,用于执行对主数据库的某种测试工作,当测试完毕后,再将数据库闪回到之前的状态,作为备份继续提供保护服务。
1 在备库闪回数据库
1)取消备库托管恢复
SQL> alter database recover managed standby database cancel;
Database altered.
2)设置备库的闪回恢复区
SQL> show parameter db_recover
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /u01/app/oracle/fast_recovery_
area
db_recovery_file_dest_size big integer 4560M
3)启动闪回特性
SQL> startup mount
ORACLE instance started.
Total System Global Area 1644167168 bytes
Fixed Size 2925024 bytes
Variable Size 1073745440 bytes
Database Buffers 553648128 bytes
Redo Buffers 13848576 bytes
Database mounted.
SQL> alter database flashback on;
Database altered.
SQL> select flashback_on from v$database;
FLASHBACK_ON
------------------
YES
4)创建一个保证还原点
SQL> create restore point before_opem_rw guarantee flashback database;
Restore point created.
5)将主库向备库传输日志的目标目的地设置为延迟状态
SQL> show para