您好,登錄后才能下訂單哦!
(1)查看數(shù)據(jù)庫(kù)當(dāng)前保護(hù)模式:最高性能模式
select
database_role,protection_mode,protection_level from v$database;
主庫(kù) 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;
備庫(kù)要添加4個(gè)standby 日志組,比普通日志組多一個(gè)。
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;
查看當(dāng)前主、備庫(kù)數(shù)據(jù)保護(hù)模式,已經(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ù)庫(kù)當(dāng)前保護(hù)模式,已經(jīng)升級(jí)成功:最大保護(hù)模式
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)庫(kù),把庫(kù)起到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;
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。