11G DG搭建--rman方式

DG创建

 

环境

这次创建DG的环境是

Database：11.2.0.3

主备库的oracle软件安装路径都在/u01/app/oracle下面。

主库IP地址：20.4.1.81

备库IP地址：20.4.1.79

 

 

准备TNS项

在主库上编辑tns文件，然后拷贝到备库上。

[oracle@2F ~]$ cat /u01/app/oracle/product/11.2.0/db/network/admin/tnsnames.ora # tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db/network/admin/tnsnames.ora # Generated by Oracle configuration tools.   ORCL =   (DESCRIPTION =     (ADDRESS_LIST =       (ADDRESS = (PROTOCOL = TCP)(HOST = 20.4.1.81)(PORT = 1521))     )     (CONNECT_DATA =       (SERVICE_NAME = orcl)     )   )   #连接到主库的tns zd_pri =   (DESCRIPTION =     (ADDRESS_LIST =       (ADDRESS = (PROTOCOL = TCP)(HOST = 20.4.1.81)(PORT = 1521))     )     (CONNECT_DATA =       (SERVICE_NAME = pri)     )   )   #连接到备库的tns zd_std =   (DESCRIPTION =     (ADDRESS_LIST =       (ADDRESS = (PROTOCOL = TCP)(HOST = 20.4.1.79)(PORT = 1521))     )     (CONNECT_DATA =       (SERVICE_NAME = std)     )   )

配置好之后，将该tnsname.ora拷贝的standby库上。

验证一下tnsping，和使用sqlplus登陆一下，连接是通的

[oracle@2F ~]$ tnsping zd_pri   TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 08-MAR-2014 14:33:21   Copyright (c) 1997, 2011, Oracle.  All rights reserved.   Used parameter files:     Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 20.4.1.81)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = pri))) OK (0 msec) [oracle@2F ~]$ sqlplus system/oracle@zd_pri   SQL*Plus: Release 11.2.0.3.0 Production on Sat Mar 8 14:33:35 2014   Copyright (c) 1982, 2011, Oracle.  All rights reserved.     Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options   SQL>

 

配置主备库的listener.ora文件（如果不做switch over就不需要做），添加SID_LIST

SID_LIST_LISTENER=   (SID_LIST =          (SID_DESC=                    (GLOBAL_DBNAME=pri)                    (ORACLE_HOME=/u01/app/oracle/product/11.2.0/db)                    (SID_NAME=orcl)          )   )

添加这个的时候，需要注意的是SID_LIST_LISTENER必须定格写，不然会报错。

在备库的时候也需要添加如下内容

 

SID_LIST_LISTENER=   (SID_LIST =          (SID_DESC=                    (GLOBAL_DBNAME=std)                    (ORACLE_HOME=/u01/app/oracle/product/11.2.0/db)                    (SID_NAME=orcl)          )   )

 

修改主库的相关项：

alter database force logging; alter database archivelog;

 

[oracle@2F ~]$ sqlplus / as sysdba   SQL*Plus: Release 11.2.0.3.0 Production on Sat Mar 8 13:10:11 2014