(1)查看数据库当前保护模式:最高性能模式
select
database_role,protection_mode,protection_level from v$database;
主库 Primary :
vim $ORACLE_HOME/dbs/initBJ.ora
shutdown immediate;
startup;
select sequence#,group#,bytes/1024/1024 MB from v$log;
select member from v$logfile;
备库要添加4个standby 日志组,比普通日志组多一个。
alter database add standby logfile group 4 '/u02/oradata/sh/redo04.std' size 50m;
alter database add standby logfile group 5 '/u02/oradata/sh/redo05.std' size 50m;
alter database add standby logfile group 6 '/u02/oradata/sh/redo06.std' size 50m;
alter database add standby logfile group 7 '/u02/oradata/sh/redo07.std' size 50m;
alter database set standby database
to maximize availability;
查看当前主、备库数据保护模式,已经是最高可用模式。
select database_role,protection_mode,protection_level from v$database;
select database_role,protection_mode,protection_level from v$database;
alter database set standby database
to maximize protection;
查看数据库当前保护模式,已经升级成功:最大保护模式
select database_role,protection_mode,protection_level from v$database;
select database_role,open_mode,protection_mode,protection_level from v$database;
alter database set standby database to maximize availability;
select database_role,open_mode,protection_mode,protection_level from v$database;
select database_role,protection_mode,protection_level from v$database;
alter database set standby database to maximize performance;
select database_role,protection_mode,protection_level from v$database;
select database_role,open_mode,protection_mode,protection_level from v$database;
alter database set standby database to maximize protection;
正常关库,把库起到mount状态
shutdown immediate;
startup mount;
select database_role,protection_mode,protection_level from v$database;
alter database
open;
select database_role,protection_mode,protection_level from v$database;
alter database set standby database to maximize performance;
select database_role,protection_mode,protection_level from v$database;
免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。