Windows下安裝dataGuard操作手冊.doc

Windows下安裝dataGuard操作步驟文檔版本版本號日期說明編寫者審核者V1.02012-10-14文檔創(chuàng)建。呂萬里規(guī)劃保護模式：創(chuàng)建時使用默認設(shè)置，即最大性能模式，構(gòu)建好后切換到最大保護模式。為了考慮主庫和物理備庫的切換，主庫也建standby redo logs。留出足夠的空間給歸檔日志，建議100G，后期將通過腳本定期刪除過期日志。同操作系統(tǒng)、oralce10g以上，開啟歸檔模式。配置步驟：1、配置安裝安裝主庫主庫先安裝數(shù)據(jù)庫和實例，備庫只安裝數(shù)據(jù)庫不裝實例 安裝前，先配置環(huán)境變量，例如ORACLE_BASE: e:oracleORACLE_HOME: %ORACLE_BASE%product10.2db_1ORACLE_SID: ORCL 然后，通過圖形界面安裝數(shù)據(jù)庫 安裝數(shù)據(jù)庫的實例，實例名：ORCL 修改主數(shù)據(jù)庫模式為force logging SQL alter database force logging; SQL select force_logging from v$database; -驗證 修改主數(shù)據(jù)庫模式為歸檔模式SQL shutdown immediate; SQL startup mountSQL alter database archivelog;SQL archive log startSQL alter database openSQLalter system set log_archive_dest_1=location=E:/oracle/product/ 10.2.0/db_1/database/archive scope=spfileSQL archive log list -驗證 此例中存檔日志的存放路徑為 E:/oracle/product/10.2.0/db_1/database/archive 在主庫創(chuàng)建standby redo log SQLalter database add standby logfile group 4 E:/oracle/product/10.2.0/oradata/orcl/standbyredo04.log size 50M; SQLalter database add standby logfile group 5 E:/oracle/product/10.2.0/oradata/orcl/standbyredo05.log size 50M; SQLalter database add standby logfile group 6 E:/oracle/product/10.2.0/oradata/orcl/standbyredo06.log size 50M;SQLalter database add standby logfile group 7 E:/oracle/product/10.2.0/oradata/orcl/standbyredo07.log size 50M;SQLSELECT GROUP#,THREAD#,SEQUENCE#,ARCHIVED,STATUS FROM V$STANDBY_LOG; -驗證 在E:/oracle/product/10.2.0/admin/orcl/pfile/spfile目錄中的spfile中增加以下內(nèi)容（做之前先備份）DB_UNIQUE_NAME=primary LOG_ARCHIVE_CONFIG=DG_CONFIG=(primary,standby) LOG_ARCHIVE_DEST_1=LOCATION=E:/oracle/product/10.2.0/db_1/database/archive valid_for=(all_logfiles,all_roles) db_unique_name=primary LOG_ARCHIVE_DEST_2=SERVICE=standby LGWRA SYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME= standby LOG_ARCHIVE_DEST_STATE_1=ENABLE LOG_ARCHIVE_DEST_STATE_2=ENABLE REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVELOG_ARCHIVE_MAX_PROCESSES=4 LOG_ARCHIVE_FORMAT=%t_%s_%r.arc FAL_CLIENT = primary FAL_SERVER = standyDB_FILE_NAME_CONVERT= standby,primarySTANDBY_FILE_MANAGEMENT =AUTOlog_file_name_convert=E:/oracle/product/10.2.0/oradata/orcl,D:/oracle/product/10.2.0/oradata/orcl 主庫用修改后的pfile創(chuàng)建spfileSQL shutdown immediateSQL create spfile=E:/oracle/product/10.2.0/db_1/dbs/SPFILEORCL.ORA from pfile =E:/oracle/product/10.2.0/admin/orcl/pfile/initXXX.ora;（此處initXXX需要修改成準確的文件名稱） 在主庫用RMAN做一個全備C:/Documents and Settings/Administratorrman nocatalog target sys/adminorcl as sysdbaRMAN run 2 allocate channel c1 type disk; 3 backup format d:/db_bakup/full%u_%s_%p database 4 include current controlfile; 5 sql alter system archive log current; 6 backup filesperset 10 archivelog all format=d:/db_bakup/log%u_%s.bak; 7 release channel c1; 8 在主庫創(chuàng)建備用服務(wù)器控制文件SQL alter database create standby controlfile as D:/db_bakup/standby.ctl; 拷貝backup，pfile，standby controlfile(將standby.ctl拷貝到備庫后復(fù)制多份，比如復(fù)制改名為CONTROL01.CTL，CONTROL02.CTL，CONTROL03.CTL)，PWD file等到相應(yīng)的目錄 在備庫建立與主庫一樣的備份目錄將備份文件拷貝進去，即前面主庫RMAN備份指定目錄為D:/db_bakup則在備庫也建立相同的D:/db_bakup目錄。(可在rman中通過list backup命令查看) 修改備庫standby的pfile（注意備份）DB_UNIQUE_NAME=standby LOG_ARCHIVE_CONFIG=DG_CONFIG=(primary,standby) LOG_ARCHIVE_DEST_2=LOCATION=E:/oracle/product/10.2.0/db_1/database/archive valid_for=(all_logfiles,all_roles) db_unique_name=primary LOG_ARCHIVE_DEST_2=SERVICE=primary LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=primary LOG_ARCHIVE_DEST_STATE_1=ENABLE LOG_ARCHIVE_DEST_STATE_2=ENABLE REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVELOG_ARCHIVE_MAX_PROCESSES=4LOG_ARCHIVE_FORMAT=%t_%s_%r.arcFAL_CLIENT = standbyFAL_SERVER = primaryDB_FILE_NAME_CONVERT=primary,standbySTANDBY_FILE_MANAGEMENT =AUTO log_file_name_convert=D:/oracle/product/10.2.0/oradata/orcl,D:/oracle/product/10.2.0/oradata/orcl 在備庫端還原數(shù)據(jù)庫SQL conn / as sysdba SQL startup nomount pfile=D:/oracle/product/10.2.0/admin/orcl/pfile/init.ora.0（修改成準確名稱）SQL alter database mount standby database;C:/Documents and Settings/Administratorrman nocatalog target /RMAN show all;RMAN list backup;RMAN restore database;RMAN restore archivelog all; 分別在主庫和備庫配置監(jiān)聽并啟動1) 配置主庫listener.ora如下： SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = E:/oracle/product/10.2.0/db_1) (PROGRAM = extproc) ) (SID_DESC =(GOLBAL_DBNAME = orcl)(ORACLE_HOME = E:/oracle/product/10.2.0/db_1)(SID_NAME = orcl) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1) (ADDRESS = (PROTOCOL = TCP)(HOST = test1)(PORT = 1521) ) ) 2) 在備庫使用netca配置listener.ora配置如下： SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = E:/oracle/product/10.2.0/db_1) (PROGRAM = extproc) ) (SID_DESC = (GOLBAL_DBNAME = orcl) (ORACLE_HOME = E:/oracle/product/10.2.0/db_1) (SID_NAME = orcl) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1) (ADDRESS = (PROTOCOL = TCP)(HOST = test2)(PORT = 1521) ) ) 3)主庫和備庫的tnsnames.ora都加入以下配置： PRIMARY = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = test1)(PORT = 1521) ) (CONNECT_DATA = (service_name = orcl) ) ) STANDBY = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = test2)(PORT = 1521) ) (CONNECT_DATA = (service_name = orcl) ) ) 備庫創(chuàng)建spfileSQL create spfile=E:/oracle/product/10.2.0/db_1/database/XXX.ORA frompfile=E:/oracle/product/10.2.0/admin/orcl/pfile/init.ora.XXX;啟動備庫SQL shutdown immediateSQL startup mount 備份方式可以采用最大可用模式或最大性能模式，對于最大可用模式需要創(chuàng)建standy redo log（步驟見下面），對于最大性能模式，可以不創(chuàng)建stany redo log。建議創(chuàng)建。首先在主庫切換一次日志，使備庫中記錄的原主庫的standby redo log信息被清除。 主庫執(zhí)行： SQL alter system switch logfile;稍等一會，等在備庫中查詢v$standby_log沒有原來主庫standby log的信息返回時，再在備庫中添加standby redo log。 SQL select * from v$standby_log;SQLalter database add standby logfile group 4 E:/oracle/product/10.2.0/oradata/orcl/standbyredo04.log size 50M; SQLalter database add standby logfile group 5 E:/oracle/product/10.2.0/oradata/orcl/standbyredo05.log size 50M; SQLalter database add standby logfile group 6 E:/oracle/product/10.2.0/oradata/orcl/standbyredo06.log size 50M;SQLalter database add standby logfile group 7 E:/oracle/product/10.2.0/oradata/orcl/standbyredo07.log size 50M; 將主庫的重做日志傳輸給備用數(shù)據(jù)庫SQLalter system set log_archive_dest_state_2=enable scope=both; 在備庫啟動重做應(yīng)用SQLalter database recover managed standby database disconnect from session; 在主庫檢查日志文件是否成功傳輸SQLselect status,error from v$archive_dest where