dg部署流水.docVIP

亦庄项目测试库dataguard部署 背景 主机：RAC 备机：rac、单机 准备工作 准备源库 准备源库(北京)到备库(上海)网络 准备源库RAC redo磁盘 在两个节点都执行下面操作 mkdir –P /mnt/archivelog/ chown oracle:oinstall –R /mnt/archivelog/ 准备源库归档模式 [oracle@yzdb02 ~]$ ORACLE_SID=db2;sqlplus / as sysdba SQL archive log list Database log mode No Archive Mode Automatic archival Disabled Archive destination /u01/app/oracle/product/102/dbs/arch Oldest online log sequence 181 Current log sequence 182 不在归档模式，执行下面操作： [oracle@yzdb01 ~]$ ORACLE_SID=db1; sqlplus / as sysdba SQL shutdown immediate; 修改下面参数： SQLalter system set log_archive_max_processes=6 scope=spfile; SQLalter system set log_archive_dest_1=location=/mnt/archivelog scope=spfile; SQLalter system set log_archive_format=ARC%s%t%r.arc scope=spfile; [oracle@yzdb02 ~]$ ORACLE_SID=db2; sqlplus / as sysdba SQL shutdown immediate; SQL startup mount; SQL alter database archivelog; Database altered. SQL alter database open; Database altered. SQL archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination /mnt/archivelog Oldest online log sequence 181 Next log sequence to archive 182 Current log sequence 182 [oracle@yzdb01 ~]$ ORACLE_SID=db1; sqlplus / as sysdba SQL startup; 部署dataguard 源库参数、目录和数据准备 修改源库初始化参数 [oracle@yzdb02 ~]$ ORACLE_SID=db2; sqlplus / as sysdba SQL show parameter spfile; NAME TYPE VALUE ------------------------------------ spfile string +RAC/rac/spfilerac.ora [oracle@yzdb01 ~]$ ORACLE_SID=db1; sqlplus / as sysdba SQL startup; SQL show parameter spfile; NAME TYPE VALUE ------------------------------------ spfile string +RAC/rac/spfilerac.ora 可见，在本例中，RAC各节点共用一个spfile，所以，我们修改参数时，可以只需在一个节点下修改就可以了。 [oracle@yzdb02 ~]$ ORACLE_SID=db2; sqlplus / as sysdba命令下执行： ALTER SYSTEM SET DB_UNIQUE_NAME=db scope=spfile;ALTER SYST