Oracle数据库配置DG详解

 1、primary数据库 
  （1）SYS@ORCL>select status from v$instance;   查看当前数据库状态
  （2）SYS@ORCL>startup mount;
  （3）SYS@ORCL>alter database force logging;     强制记录日志
  （4）SYS@ORCL>select log_mode from v$database;  查看当前数据库运行的模式
  （5）SYS@ORCL>SYS@ORCL>alter database archivelog; 开启归档
  （6）SYS@ORCL>alter system set log_archive_config='dg_config=(orcl,aux1)';  罗列出DG中所有db_unique_name
   (7) SYS@ORCL>alter system set log_archive_dest_10='location=/home/oracle/orcl_arclog valid_for=  (online_logfiles,all_roles) db_unique_name=orcl';     //指定归档目录位置
  （8）mkdir /home/oracle/orcl_arclog    该目录用于存放归档    以oracle 用身份创建
   (9) SYS@ORCL>alter system set log_archive_dest_1='service=aux1 valid_for=(online_logfiles,primary_role)  db_unique_name=aux1'  //配置日志发送方式
  （10)SYS@ORCL>alter system set log_archive_max_processes=4;配置归档进程最大数据
   (11)SYS@ORCL>create pfile from spfile;      通过spfile创pfile  给AUX1数据库启动实例  
  （12)scp $ORACLE_HOME/dbs/initORCL.ora   192.168.12.14:$ORACLE_HOME/dbs/initAUX1.ora
   (13)scp $ORACLE_HOME/dbs/orapwORCL  192.168.12.14:$ORACLE_HOME/dbs/orapwAUX1
   
 2、standby 数据库
   (14) vim $ORACLE_HOME/dbs/initAUX1.ora   修改该参数文件
        *.audit_file_dest='/u01/app/oracle/admin/AUX1/adump'
        *.background_dump_dest='/u01/app/oracle/admin/AUX1/bdump'
        *.control_files='/u01/app/oracle/oradata/AUX1/control01.ctl','/u01/app/oracle/oradata/AUX1/control02.ctl','/u01/app/oracle/oradata/AUX1/control03.ctl'
        *.core_dump_dest='/u01/app/oracle/admin/AUX1/cdump'
        *.db_unique_name='AUX1'
        *.log_archive_dest_10='location=/home/oracle/aux1_arclog valid_for=(online_logfiles,all_roles) db_unique_name=aux1'
        *.standby_archive_dest='/home/oracle/aux1_stdlog'
        *.db_file_name_convert=('/u01/app/oracle/oradata/ORCL/','/u01/app/oracle/oradata/AUX1/')   //主从数据文件路径转换
        *.log_file_name_convert=('/u01/app/oracle/oradata/ORCL/','/u01/app/oracle/oradata/AUX1/') //主从日志路径转换
        *.standby_file_management='auto'   //当主数据数据文件发生更改，从数据库做相应更改
        *.user_dump_dest='/u01/app/oracle/admin/AUX1/udump'
   （15）mkdir -p $ORACLE_BASE/admin/AUX1/{a,b,c,u}dump
         mkdir /home/oracle/aux1_arclog

         mkdir /home/oracle/aux1_stdlog
         mkdir $ORACLE_BASE/admin/AUX1
   
1、primary
   （1）[oracle@dg-primary dbs]$ rman target /         登陆rman
   （2）RMAN> report schema;                       查看当数据库结构
   （3）RMAN> show all;                    查看当rman默认配置参数
   （4）RMAN> configure channel device type disk format '/home/oracle/rmanbk/%d_%I_%s_%p.bkp';   配置备份通道 %d--数据库名 %I-数据库ID  %s--备份集  %p--代表备份片
   （5）RMAN> backup as compressed backupset database include current controlfile for standby  plus archivelog;    备份数据库包含归档文件和控制文件
   （6）RMAN> list backup;             查看备份信息
   （7）[oracle@dg-primary rmanbk]$ scp * 192.168.12.14:/home/oracle/rmanbk/    将/home/oracle/rmanbk/ 下备份片拷贝 standby主机 /home/oracle/rmanbk/
   (8) 配置网络监听 
    （1）vim  $ORACLE_HOME/network/admin/listener.ora  
       SID_LIST_LISTENER =
       (SID_LIST =
         (SID_DESC =
           (SID_NAME = ORCL)
           (ORACLE_HOME = /u01/app/oracle/product/10.2.0)

       )
       )

     LISTENER =
       (DESCRIPTION_LIST =
          (DESCRIPTION =
             (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
             (ADDRESS = (PROTOCOL = TCP)(HOST = dg-primary)(PORT = 1521))
          )
         )
    (2)[oracle@dg-standby admin]$ lsnrctl start