(1)查看數(shù)據(jù)庫當前保護模式:最高性能模式
select
database_role,protection_mode,protection_level from v$database;
主庫 Primary :
創(chuàng)新互聯(lián)專注于河西網(wǎng)站建設服務及定制,我們擁有豐富的企業(yè)做網(wǎng)站經(jīng)驗。 熱誠為您提供河西營銷型網(wǎng)站建設,河西網(wǎng)站制作、河西網(wǎng)頁設計、河西網(wǎng)站官網(wǎng)定制、微信小程序開發(fā)服務,打造河西網(wǎng)絡公司原創(chuàng)品牌,更為您提供河西網(wǎng)站排名全網(wǎng)營銷落地服務。
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;
查看當前主、備庫數(shù)據(jù)保護模式,已經(jīng)是最高可用模式。
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;
查看數(shù)據(jù)庫當前保護模式,已經(jīng)升級成功:最大保護模式
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;
正常關(guān)庫,把庫起到mount狀態(tài)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;
本文題目:【DataGuard】OracleDataGuard數(shù)據(jù)保護模式切換
文章出自:http://www.muchs.cn/article42/jsodhc.html
成都網(wǎng)站建設公司_創(chuàng)新互聯(lián),為您提供定制開發(fā)、手機網(wǎng)站建設、App開發(fā)、響應式網(wǎng)站、小程序開發(fā)、品牌網(wǎng)站建設
聲明:本網(wǎng)站發(fā)布的內(nèi)容(圖片、視頻和文字)以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主,如果涉及侵權(quán)請盡快告知,我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場,如需處理請聯(lián)系客服。電話:028-86922220;郵箱:631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載,或轉(zhuǎn)載時需注明來源: 創(chuàng)新互聯(lián)