10g DataGuard 物理备库临时启动到读写模式进行应用测试

10g DataGuard 物理备库临时启动到读写模式进行应用测试

1、确保物理备库开启闪回数据库功能

select flashback_on from v$database;

2、打开备库闪回数据库功能
--取消备库的自动恢复状态

alter database recover managed standby database cancel;

--设置闪回恢复区

alter system set db_recovery_dest_size=40g;
alter system set db_recovery_file_dest='+DATA';
alter database flashback on;

3、创建一个还原点

create restore point before_app;

4、在主库归档当前日志,确保前一步创建还原点的scn的归档日志已经传到备库

alter system archive log current;

5、将主库到备库的归档目的地状态设置为defer

alter system set log_archive_dest_state_2=defer;

6、激活备库到read/write状态

alter database activate standby database;
shutdown immediate;
startup;
select open_mode from v$database;

7、将数据库flashback回原来保存的还原点

startup mount force;
flashback database to restore point before_app;

8、转换成备库

alter database convert to physical standby;

9、将备库至于自动恢复状态

startup mount force;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT;

10、将主库到备库的归档目的地状设置为enable

alter system set log_archive_dest_state_2=enable;

11、检查同步情况

set linesize 150;
set pagesize 20;
column name format a13;
column value format a20;
column unit format a30;
column TIME_COMPUTED format a30;
select name,value,unit,time_computed from v$dataguard_stats where name in ('transport lag','apply lag');