1.查看当前保护模式(最大保护改为最大可用)
sys@ORCL>select protection_mode,protection_level from v$database;
PROTECTION_MODE PROTECTION_LEVEL
-------------------- --------------------
MAXIMUM PROTECTION MAXIMUM PROTECTION
----当前保护模式为最大保护，先修改为最高可用
sys@ORCL>alter system set log_archive_dest_2='service=orclps1 sync affirm net_timeout=10 valid_for=(online_logfile,primary_role) db_unique_name=orclps1';
System altered.
sys@ORCL>alter system set log_archive_dest_3='service=orclps2 sync affirm net_timeout=10 valid_for=(online_logfile,primary_role) db_unique_name=orclps2';
System altered.
sys@ORCL>alter database set standby database to maximize availability;
Database altered.
sys@ORCL>select protection_mode,protection_level from v$database;
PROTECTION_MODE PROTECTION_LEVEL
-------------------- --------------------
MAXIMUM AVAILABILITY MAXIMUM AVAILABILITY
2.备库orclps1改为ADG模式
----查看备库状态
idle>select database_role,open_mode,name,db_unique_name from v$database;
DATABASE_ROLE OPEN_MODE NAME DB_UNIQUE_NAME
---------------- -------------------- -------- ------------------------------
PHYSICAL STANDBY MOUNTED ORCL orclps1
----取消日志应用
idle>recover managed standby database cancel;
Media recovery complete.
----此时主库只传日志到备库，不应用
idle>select sequence#, applied from v$archived_log;
----或者alter database recover managed standby database cancel;
SEQUENCE# APPLIED
---------- ---------
29 YES
30 NO
31 NO
----打开数据库
idle>alter database open;
Database altered.
idle>select database_role,open_mode,name,db_unique_name from v$database;
DATABASE_ROLE OPEN_MODE NAME DB_UNIQUE_NAME
---------------- -------------------- -------- ------------------------------
PHYSICAL STANDBY READ ONLY ORCL orclps1
----开启日志应用
sys@ORCL>alter database recover managed standby database using current logfile disconnect;
Database altered.
----此时日志开始应用
sys@ORCL>select sequence#, applied from v$archived_log;
SEQUENCE# APPLIED
---------- ---------
29 YES
30 YES
31 IN-MEMORY
同理orclps2改为ADG一样的方法