1、data guard 操作指南 oracle 11gr2 windows server 2003平臺下的dataguard的部署 一、環(huán)境： 主庫服務(wù)器地址: 11.0.1.1 sid=whgjj 備庫服務(wù)器地址: 11.0.1.2 二、主庫設(shè)置： 1.設(shè)置主數(shù)據(jù)庫為force logging模式 sqlsqlplus sys/yixinyu sqlalter database force logging; 2.設(shè)置主數(shù)據(jù)庫為歸檔模式 sql shutdown immediate ; sql startup mount ; sql alter database archivelog; 3.添加

2、備用聯(lián)機(jī)日志文件 先查看日志文件位置： sqlselect * from v$logfile; 再添加： sql alter database add standby logfile group 4 (g:appadministratororadatawhgjjredo04.log) size 50m; sql alter database add standby logfile group 5 (g:appadministratororadatawhgjjredo05.log) size 50m; sql alter database add standby logfile group 6

3、(g:appadministratororadatawhgjjredo06.log) size 50m; sql alter database add standby logfile group 7 (g:appadministratororadatawhgjjredo07.log) size 50m; 4.創(chuàng)建主庫的初始化參數(shù)給備庫用 sqlcreate pfile from spfile; 產(chǎn)生的文件名為initwhgjj.ora存放目錄默認(rèn)放在$oracle_home/database下 5. 在主庫創(chuàng)建監(jiān)聽和配置tnsnams.ora listener.ora配置如下: sid_lis

4、t_listener = (sid_list = (sid_desc = (global_dbname = whgjj) (oracle_home =g:appadministratorproduct11.2.0dbhome_1) (sid_name = whgjj) ) (sid_desc = (sid_name = clrextproc) (oracle_home = g:appadministratorproduct11.2.0dbhome_1) (program = extproc) (envs =clr11.dll ) ) listener = (description_list =

5、 (description = (address = (protocol = ipc)(key = extproc1521) (address = (protocol = tcp)(host = 11.0.1.1)(port = 1521) ) ) tnsnames.ora配置如下: whgjj = (description = (address_list = (address = (protocol = tcp)(host = 11.0.1.1)(port = 1521) ) (connect_data = (service_name = whgjj) ) ) standby = (desc

6、ription = (address_list = (address = (protocol = tcp)(host = 11.0.1.2)(port = 1521) ) (connect_data = (service_name = whgjj) ) ) oraclr_connection_data = (description = (address_list = (address = (protocol = ipc)(key = extproc1521) ) (connect_data = (sid = clrextproc) (presentation = ro) ) ) 7.在initorcl.ora添加以下內(nèi)容： *.db_unique_na