Dataguard实施文档技术总结.docxVIP

配置最大性能模式简单的规划：属性主库备库ip00hostnamesrctargetdb_unique_nameprimarystandbyservice_namesprimarystandbyinstance_namestustudb_namestustuORACLE_HOME/u01/app/oracle/product/10.2/db_1/u01/app/oracle/product/10.2/db_1归档存放路径/oradata/arch/oradata/archredo存放路径/oradata/stu/oradata/stu主库相关配置简单一个checklist：Enable Forced LoggingCreate a Password FileSet Primary Database Initialization ParametersEnable ArchivingSet listener and tnsnames设置force logging：SQL select FORCE_LOGGING from v$database;FOR---YES如果没有打开，如下方式打开：ALTER DATABASE FORCE LOGGING;创建密码文件：默认Oracle的密码文件是保存在$ORACLE_HOME/dbs下面的：如果没有的话，需要手动创建一个：可以直接在$ORACLE_HOME/dbs运行如下命令：orapwd file=orapw实例名 password=*******设置主库的初始化参数：修改主库的参数：*.INSTANCE_NAME=stu*.DB_UNIQUE_NAME=primary*.LOG_ARCHIVE_CONFIG=DG_CONFIG=(primary,standby)*.LOG_ARCHIVE_DEST_1=LOCATION=/oradata/archVALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=primary*.LOG_ARCHIVE_DEST_2=SERVICE=standby LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=standby*.LOG_ARCHIVE_MAX_PROCESSES=30*.STANDBY_FILE_MANAGEMENT=AUTO为了长远考虑，假如有一天将主库又切换成备库了，这样发生角色转换，那么免得再去设置，可以现在在主库上设置一些standby的参数，如下（这是可选的噢）：*.FAL_SERVER=standby*.FAL_CLIENT=primary*.DB_FILE_NAME_CONVERT=standby,primary*.LOG_FILE_NAME_CONVERT=/oradata/arch/,/oradata/arch/*.STANDBY_FILE_MANAGEMENT=AUTO再创建一个pfile：SQL create pfile=/tmp/s.txt from spfile;File created.然后将该pfile传到远端的备库上，以便后面的使用。主库需要启用归档模式：SQL SHUTDOWN IMMEDIATE;SQL STARTUP MOUNT;SQL ALTER DATABASE ARCHIVELOG;SQL ALTER DATABASE OPEN;配置监听和TNS：在主库上：没有监听的话，就写一个监听呗：vi listener.oraLISTENER = (ADDRESS_LIST= (ADDRESS=(PROTOCOL=tcp)(HOST=src)(PORT=1521)) )SID_LIST_LISTENER = (SID_LIST= (SID_DESC= (SID_NAME=stu) (SERVIE_NAME=primary) (ORACLE_HOME=/u01/app/oracle/product/10.2/db_1) ) )tnsname的配置：primary = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 0)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = primary) ) )standby = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (