dataguard安装文档.doc

领先的软件系统综合服务商华北电力大学dataguard安装文档作 者：元鼎时代创建日期：2008-9-6修改日期：2008-9-8一、环境：数据库环境：oracle10Gr2操作系统：redhat4.5主库 ip: 202.204.65.129hostname:oadb 备库 ip: 202.204.65.106 hostname:oadb2二、安装步骤：1.查看系统包（两个节点都安装）：rpm -q make gcc gcc-c+ libaio libaio-devel make-3.80-184.1gcc-3.3.3-43.24gcc-c+-3.3.3-43.24libaio-0.3.98-18.3libaio-devel-0.3.98-18.3特别注意下面两个包，必须安装，否则创建数据库时，报错：ORA-12547: TNS: lost contactlibaio-0.3.98-18.3libaio-devel-0.3.98-18.3 安装示例：rpm ivh libaio-0.3.98-18.32.解压oracle数据库安装文件unzip 10201_database_linux32.zip3.增加组和用户groupadd dba 管理员组 groupadd oinstall mkdir p /u01/app/oracle useradd -g oinstall -G dba oracle -d /u01/app/oracle passwd oraclechown -R oracle:oinstall /u01chown -R oracle:oinstall database4.修改配置文件：vi .bash_profile加入下面内容：ORACLE_BASE=/u01/app/oracleORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1 ORACLE_SID=shanonexport ORACLE_BASE ORACLE_HOME ORACLE_SIDexport LD_LIBRARY_PATH=$ORACLE_HOME/libPATH=$ORACLE_HOME/bin:$PATHexport PATH5.修改linux共享内存参数 /etc/sysctl.conf shmmax 256M6.开始安装oracle软件(分别在oadb，oadb2上安装)分别在节点1上和节点2上修改/etc/hosts文件：vi /etc/hosts:127.0.0.1 localhost202.204.65.129 oadb202.204.65.106 oadb2su - oracle ./runInstaller7.创建oracle数据库(在节点oadb),netca配置监听器和服务名（在节点oadb，oadb2上）在oadb使用dbca创建数据库；在oadb，oadb2上分别使用netca配置监听器和tns服务名（tns服务名要配置两个，分别连接到oadb和oadb2）Tnsnames.ora：shanon2 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 202.204.65.106)(PORT = 1521) ) (CONNECT_DATA = (SERVICE_NAME = shanon) ) )shanon = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 202.204.65.129)(PORT = 1521) ) (CONNECT_DATA = (SERVICE_NAME = dguard1) ) )Listener.oraSID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1) (PROGRAM = extproc) ) )LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = oadb2)(PORT = 1521) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0) ) )测试备库能连接到主库：sqlplus system/passshanon8.强制主库记录日志，修改主库的初始化参数文件 oadb：ALTER DATABASE FORCE LOGGING;Create pfile from spfile;修改初始化参数文件:vi initshanon.ora:db_unique_name=uqn_node1log_archive_config=DG_CONFIG=(uqn_node1,uqn_node2)log_archive_dest_1=LOCATION=/u02/oradata/archlog_archive_dest_2=SERVICE=shanon2 valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=uqn_node2log_archive_dest_state_1=ENABLElog_archive_dest_state_2=ENABLElog_archive_format=%t_%s_%r.arcfal_server=shanon2fal_client=shanonstandby_file_management=auto9.在主库上创建备库的控制文件 oadb: rm -f /u01/oracle/dbs/sp* startup mount;alter database create standby controlfile as /u02/oradata/standby.ctl;alter database open;shutdown immediate;10.拷贝参数文件，口令文件，控制文件，数据文件,日志文件到oadb2上;拷贝$ORACLE_BASE/ADMIN目录到oadb2上oadb：cp initshanon.ora /u02/oradatacp orapwshanon /u02/oradatacd /u02/oradatals -应该能看到参数文件，口令文件，控制文件oadb2:这时只有orainventory,product 目录node1:scp -r admin oadb2:/u01/app/oracle scp -r /u02/oradata oadb2:/u02/注意：把口令文件和参数文件拷贝到备库的正确位置。11.拷贝备库控制文件，修改备库初始化参数文件创建备库控制文件：oadb2:cd /u02/oradata/shanonrm -f control0*cp /u02/oradata/standby.ctl ./shanon/cd shanonmv standby.ctl control01.ctlcp control01.ctl control02.ctlcp control01.ctl control03.ctl修改备库初始化参数文件：oadb2:cd /u02/oradatamv initshanon.ora /u01/app/oracle/product/10.2.0/db_1/dbscd $ORACLE_HOME/dbsvi initshanon.oradb_unique_name=uqn_node2service_names=shanonlog_archive_config=DG_CONFIG=(uqn_node1,uqn_node2)log_archive_dest_2=service=shanon valid_for=(online_logfiles,primary_role) db_unique_name=uqn_node1log_archive_dest_state_1=enablelog_archive_dest_state_2=enablefal_server=shanonfal_client=shanon2standby_file_management=auto12.在两个节点上启动监听器oadblsnrctl startoadb2lsnrctl start13.在oadb上启动数据库，在oadb2上应用日志oadb:sqlplus / as sysdbastartupsqlplus system/passshanon 从node2测试能否连接node1数据库show parameter log_archiveoadb2:sqlplus / as sysdbastartup mount;alter database recover managed standby database disconnect from session;-应用日志14.测试1:oadb2:SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME,APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;oadb:alter system switch logfile;oadb2:SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME,APPLIEDFROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;15.测试2：oadb：create table tttinsert into tttoadb2:alter database recover managed standby database cancel;alter database open; -缺省就是只读模式三、备库从mount状态回到read only状态：oadb2：alter database recover managed standby database cancel;alter database open; -缺省就是只读模式四、备库从read only状态回到mount状态：oadb2：直接执行：alter database recover managed standby database disconnect from session;select name,database_role from v$database;-shanon,physical standbyoadb:select name,database_role from v$database;-shanon,primaryselect switchover_status from v$database;-not allowed五、主库切换到备库：oadb：alter database commit to switchover to physical standby with session shutdown;shutdown immediate;startup nomount;alter database mount standby database;recover database managed standby database disconnect from session;oadb2:alter database commit to switchover to primary;shutdown immediate;startup;六、备份主数据库：STARTUP MOUNTRMAN RUN ALLOCATE CHANNEL D1 TYPE DISK; ALLOCATE CHANNEL D2 TYPE DISK; ALLOCATE CHANNEL D3 TYPE DISK; BACKUP DATABASE INCLUDE CURRENT