ADG快照切换实施方案

1开启快照实施步骤

1.1 准备工作

1.1.1闪回数据库是否开启

su - oracle

sqlplus / as sysdba

set linesize 20

select flashback_on from v$database;

1.1.2未开启闪回，执行该步骤，开启闪回

su - oracle

sqlplus / as sysdba

--设置闪回区大小和路径

alter system set db_recovery_file_dest_size=20G;   --尽量稍微大些

alter system set db_recovery_file_dest='/tmp';

shutdown immediate

startup mount

alter database flashback on;

alter database open;

1.2 关闭备库，启动到mount状态

su - oracle

sqlplus / as sysdba

set linesize 150 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');

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

shutdown immediate

1.3 启动数据库到mount状态

sqlplus / as sysdba

startup mount

1.4 开启ADG快照

sqlplus / as sysdba

ALTER DATABASE CONVERT TO SNAPSHOT STANDBY;

alter database open;

1.5 验证是否成功，开启成功

select open_mode,database_role from v$database;

OPEN_MODE        DATABASE_ROLE

-------------------- ----------------

READ WRITE         SNAPSHOT STANDBY

1.6 开启service服务

su - grid

crsctl status res -t

srvctl start service -d re_adg -s test

crsctl status res -t

2恢复物理备库步骤

2.1 关闭service服务

su - grid

crsctl status res -t

srvctl stop service -d re_adg -s test

crsctl status res -t

2.2 关闭数据库，并启动数据库到mount状态

sqlplus / as sysdba

shutdown immediate

startup mount

2.3 切换为物理备库

set linesize 100

select open_mode,database_role from v$database;

ALTER DATABASE CONVERT TO PHYSICAL STANDBY;

shutdown immediate

startup

2.4 验证是否成功

select open_mode,database_role from v$database;

OPEN_MODE        DATABASE_ROLE

-------------------- ----------------

READ ONLY           PHYSICAL STANDBY

2.5 启动数据库，开启归档应用进程

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;

2.6 查看日志应用

set linesize 150 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');