oracle 11gr2 單實例單實例dataguard實施部署方案racdg_v1.0

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

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

3、.......................................42安裝實施..................................................................................................................................42.1主機環(huán)境準備...................................

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

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

6、.52.2.1配置IP.................................................................................................................52.2.2配置主機名.....................................................................................

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

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

9、..............................................................82.6修改etcpam.dlogin....................................................................................................92.7關閉防火墻..............................

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

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

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

13、................................................................................113.1強制fcelogging...............................................................................................113.2開啟主庫的歸檔模式..............

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

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

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

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

18、..........174.1在備庫修改從主庫拷貝來的pfile.......................................................................174.2啟動備庫到nomount...............................................................................................184.3

19、開始使用RMAN進行DG...........................................................................................194.3打開備庫并開啟applyservice...........................................................................195.測試結果..........

20、..................................................................................................................206.其他相關查詢和切換使用...........................................................................................

21、......206.1查看DG是否是實時應用.......................................................................................206.2備庫關閉日志延時應用，恢復到日志實時應用.................................................216.3在備庫上面，關閉日志實時應用。.................