ActiveDataGuard （一主两备）

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一样的方法

 

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30130773/viewspace-2113085/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30130773/viewspace-2113085/