SNAPSHOT STANDBY

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');