Windows下安装dataGuard操作手册.doc

Windows下安装dataGuard操作步骤文档版本版本号日期说明编写者审核者V1.02012-10-14文档创建。吕万里规划保护模式：创建时使用默认设置，即最大性能模式，构建好后切换到最大保护模式。为了考虑主库和物理备库的切换，主库也建standby redo logs。留出足够的空间给归档日志，建议100G，后期将通过脚本定期删除过期日志。同操作系统、oralce10g以上，开启归档模式。配置步骤：1、配置安装安装主库主库先安装数据库和实例，备库只安装数据库不装实例 安装前，先配置环境变量，例如ORACLE_BASE: e:oracleORACLE_HOME: %ORACLE_BASE%product10.2db_1ORACLE_SID: ORCL 然后，通过图形界面安装数据库 安装数据库的实例，实例名：ORCL 修改主数据库模式为force logging SQL alter database force logging; SQL select force_logging from v$database; -验证 修改主数据库模式为归档模式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 在主库创建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中增加以下内容（做之前先备份）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创建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 在主库创建备用服务器控制文件SQL alter database create standby controlfile as D:/db_bakup/standby.ctl; 拷贝backup，pfile，standby controlfile(将standby.ctl拷贝到备库后复制多份，比如复制改名为CONTROL01.CTL，CONTROL02.CTL，CONTROL03.CTL)，PWD file等到相应的目录 在备库建立与主库一样的备份目录将备份文件拷贝进去，即前面主库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 在备库端还原数据库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; 分别在主库和备库配置监听并启动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) ) ) 备库创建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 备份方式可以采用最大可用模式或最大性能模式，对于最大可用模式需要创建standy redo log（步骤见下面），对于最大性能模式，可以不创建stany redo log。建议创建。首先在主库切换一次日志，使备库中记录的原主库的standby redo log信息被清除。 主库执行： 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; 将主库的重做日志传输给备用数据库SQLalter system set log_archive_dest_state_2=enable scope=both; 在备库启动重做应用SQLalter database recover managed standby database disconnect from session; 在主库检查日志文件是否成功传输SQLselect status,error from v$archive_dest where