oracle 11gr2 單實(shí)例單實(shí)例dataguard實(shí)施部署方案racdg_v1.0

1、1ACLEACLE11Gr211Gr2單實(shí)例單實(shí)例單實(shí)例單實(shí)例DataGuardDataGuard實(shí)施部署方案實(shí)施部署方案V1.0V1.0數(shù)據(jù)運(yùn)維部數(shù)據(jù)運(yùn)維部31參考集群規(guī)劃..............................................................................................................................41.11.1

2、硬件環(huán)境硬件環(huán)境......................................................................................................................41.21.2軟件環(huán)境軟件環(huán)境...............................................................................

3、.......................................42安裝實(shí)施..................................................................................................................................42.1主機(jī)環(huán)境準(zhǔn)備...................................

4、...............................................................................42.1.1操作系統(tǒng)..............................................................................................................42.1.2服務(wù)器內(nèi)存要求........

5、...........................................................................................42.2網(wǎng)絡(luò)配置.........................................................................................................................

6、.52.2.1配置IP.................................................................................................................52.2.2配置主機(jī)名.....................................................................................

7、.....................62.2.3配置etchosts...................................................................................................62.3安裝依賴包...........................................................................

8、...........................................62.4修改內(nèi)核參數(shù)...................................................................................................................82.5修改acle用戶限制......................................

9、..............................................................82.6修改etcpam.dlogin....................................................................................................92.7關(guān)閉防火墻..............................

10、.........................................................................................92.8更改安裝所有者的ulimit設(shè)置......................................................................................92.9添加用戶及創(chuàng)建安裝目錄..........

11、....................................................................................102.10設(shè)置acle用戶環(huán)境變量.........................................................................................102.11安裝acle數(shù)據(jù)庫(kù)軟件............

12、.................................................................................112.12配置監(jiān)聽及本地網(wǎng)絡(luò)服務(wù)...........................................................................................113.搭建DG在主庫(kù)做一些操作...............

13、................................................................................113.1強(qiáng)制fcelogging...............................................................................................113.2開啟主庫(kù)的歸檔模式..............

14、................................................................................123.3創(chuàng)建stbyredolog.........................................................................................123.4創(chuàng)建pfile.....................

15、.........................................................................................133.5修改主庫(kù)的監(jiān)聽和tnsname.a文件.................................................................133.6修改備庫(kù)的監(jiān)聽和tnsname.a文件..................

16、...............................................143.7修改主庫(kù)pfile文件..............................................................................................153.8用pfile啟動(dòng)主庫(kù)，并創(chuàng)建spfile......................................

17、...............................173.9將口令驗(yàn)證文件和pfile發(fā)送到備庫(kù).................................................................174.搭建DG在備庫(kù)做一些操作.....................................................................................

18、..........174.1在備庫(kù)修改從主庫(kù)拷貝來的pfile.......................................................................174.2啟動(dòng)備庫(kù)到nomount...............................................................................................184.3

19、開始使用RMAN進(jìn)行DG...........................................................................................194.3打開備庫(kù)并開啟applyservice...........................................................................195.測(cè)試結(jié)果..........

20、..................................................................................................................206.其他相關(guān)查詢和切換使用...........................................................................................

21、......206.1查看DG是否是實(shí)時(shí)應(yīng)用.......................................................................................206.2備庫(kù)關(guān)閉日志延時(shí)應(yīng)用，恢復(fù)到日志實(shí)時(shí)應(yīng)用.................................................216.3在備庫(kù)上面，關(guān)閉日志實(shí)時(shí)應(yīng)用。.................