ADG-备库快照模式转换

转换物理备库为快照备库 

1.打开physical standby闪回区 

SQL> alter system set db_recovery_file_dest_size=100G;

 SQL> alter system set db_recovery_file_dest='/oradata/snapshot'; 

 2.停止活动状态的日志应用 

SQL> recover managed standby database cancel; 

 3.启动数据库到mount节点 

SQL> shutdown immediate; SQL> startup mount; 

 4.装换physical standby为snapshot standby 

SQL> alter database convert to snapshot standby; 

 5.打开数据库 如果在转换的工程中，物理备库被dismount,则重启物理备库。 

 SQL> alter database open; 

 SQL> select open_mode,database_role from v$database; OPEN_MODE DATABASE_ROLE -------------------- ---------------- READ WRITE SNAPSHOT STANDBY 

 转换快照备库为物理备库 

1.打开数据库至mount状态 

SQL> shutdown immediate SQL> startup mount; 

 2.转换snapshot standby为physical standby 

SQL> alter database convert to physical standby; 

 3.restart数据库,开启日志应用 

SQL> shutdown immediate；

 SQL> startup mount; 

SQL> alter database open read only; 

SQL> select open_mode,database_role from v$database; OPEN_MODE DATABASE_ROLE -------------------- ---------------- READ ONLY PHYSICAL STANDBY 

 4.开启日志应用 

SQL> recover managed standby database using current logfile disconnect from session;