dataguard 保护模式降级切换(maximum protection to maximize performance)
查看现有的保护模式
set linesize 200
select name, database_role, open_mode, protection_mode, protection_level from v$database;
set linesize 200
select name, database_role, open_mode, protection_mode, protection_level from v$database;
备库:
alter database recover managed standby database cancel;
主库:
alter database set standby database to maximize PERFORMANCE;
alter database set standby database to maximize PERFORMANCE;
调整log_archive_dest_2 通过归档日志传输
alter system set log_archive_dest_2='service=zhf valid_for=(online_logfiles, primary_role) db_unique_name=zhf';
alter system set log_archive_dest_2='service=zhf valid_for=(online_logfiles, primary_role) db_unique_name=zhf';
alter system switch logfile;
备库启动redo应用:
alter database recover managed standby database disconnect from session;
alter database recover managed standby database disconnect from session;
检查:
DG运行模式:
set linesize 200
select database_role, open_mode, protection_mode, protection_level, switchover_status from v$database;
备库日志应用情况:
set pagesize 2000
col name for a50
select name,thread#,sequence#,applied from v$archived_log order by thread#,sequence#;
set pagesize 2000
col name for a50
select name,thread#,sequence#,applied from v$archived_log order by thread#,sequence#;
查看主库归档目的地信息:
set linesize 200
col dest_name for a30
col error for a50
select dest_id, dest_name, status, error from v$archive_dest order by dest_id;
set linesize 200
col dest_name for a30
col error for a50
select dest_id, dest_name, status, error from v$archive_dest order by dest_id;
查看备库进程状态:
select process,status from v$managed_standby;
select process,status from v$managed_standby;
查看主/备库的alert log
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10173379/viewspace-715075/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10173379/viewspace-715075/