RAC和单实例之间建立DG

环境rac:rac1,rac2  db_name=RACDB   rac1 ip= 192.168.80.101  ra2 ip=192.168.80.102    scan-ip=192.168.80.111
单实例中 db_name=ENMOEDU  IP=192.168.80.211

1、首先把 orapwRACDB1  传到备库上  scp orapwRACDB1 oracle:oracle@192.168.80.211:`pwd`

2、配置主库上的tns 和listener文件
listener文件在  /u01/app/11.2.0.1/grid/network/admin 下
tnsnames.ora 文件在 $ORACLE_HOME/network/admin 下
配置如下：
tnsnames.ora

RACDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.80.111)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = RACDB)
    )
  )

ENMOEDU =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.80.211)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ENMOEDU)
    )
  )
listener.ora  配置如下  这个文件我没有做更改  使用的是RAC中默认的

LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))))            # line added by Agent
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1))))                # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON                # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON              # line added by Agent
-------------------------------------------------------------------------------------------------------------------
更改备库中的tnsnames.ora 和listener.ora
此单实例上没有使用ASM管理
tnsnames.ora

RACDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.80.111)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = RACDB)
    )
  )

ENMOEDU =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.80.211)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ENMOEDU)
    )

listener.ora 配置如下：

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.80.211)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )
SID_LIST_LISTENER=
(SID_LIST=
 (SID_DESC=
  (GLOBAL_DBNAME=ENMOEDU)
  (SID_NAME=ENMOEDU)
  (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)
 )
)

ADR_BASE_LISTENER = /u01/app/oracle
--------------------------------------------------------------------------------------------
3、更改主库的参数

ALTER SYSTEM SET LOG_ARCHIVE_CONFIG='DG_CONFIG=(RACDB,ENMOEDU)' SCOPE=both
ALTER SYSTEM SET LOG_ARCHIVE_DEST_1=
 'LOCATION=USE_DB_RECOVERY_FILE_DEST
  VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
  DB_UNIQUE_NAME=RACDB' SCOPE=both;
ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE=ENMOEDU ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ENMOEDU' SCOPE=both;
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
LOG_ARCHIVE_FORMAT=%t_%s_%r.ar
alter system set DB_FILE_NAME_CONVERT='/u01/app/oracle/oradata/ENMOEDU','+DATA/racdb/datafile/' scope=spfile;
alter system set log_file_name_convert='/u01/app/oracle/oradata/ENMOEDU/','+DATA/racdb/' scope= spfile;
---------------------------------------------------------------------------------------------------------------------------------------------

4、更改备库的静态参数： 用现有的init.ora 编辑一个 initENMOEDU.ora
db_name='ENMOEDU'
memory_target=1G
processes = 150
audit_file_dest='/u01/app/oracle/admin/ENMOEDU/adump'
audit_trail ='db'
db_block_size=8192
db_domain=''
db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
db_recovery_file_dest_size=2G
diagnostic_dest='/u01/app/oracle'
dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'
open_cursors=300
remote_login_passwordfile='EXCLUSIVE'
undo_tablespace='UNDOTBS1'
# You may want to ensure that control files are created on separate physical
# devices
control_files = ('/u01/app/oracle/oradata/ENMOEDU/control01.dbf', '/u01/app/oracle/flash_recovery_area/ENMOEDU/control02.dbf')
compatible ='11.2.0'

DB_NAME=RACDB
DB_UNIQUE_NAME=ENMOEDU
LOG_ARCHIVE_CONFIG='DG_CONFIG=(RACDB,ENMOEDU)'

DB_FILE_NAME_CONVERT='+DATA/racdb/datafile','/u01/app/oracle/oradata/ENMOEDU/'
LOG_FILE_NAME_CONVERT='+DATA/racdb/','/u01/app/oracle/oradata/ENMOEDU/'
LOG_ARCHIVE_FORMAT=log%t_%s_%r.arc
LOG_ARCHIVE_DEST_1=
 'LOCATION=/u01/app/oracle/fast_recovery_area/ENMOEDU/
  VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
  DB_UNIQUE_NAME=ENMOEDU'
LOG_ARCHIVE_DEST_2=
 'SERVICE=RACDB ASYNC
  VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
  DB_UNIQUE_NAME=RACDB'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
STANDBY_FILE_MANAGEMENT=AUTO

-------------------------------------------------

5、在备库上 export ORACLE_SID=ENMOEDU
sqlplus / as sysdba
create spfile from pfile;
startup nomount
rman target sys/oracle@RACDB auxiliary sys/oracle@ENMOEDU Recovery Manager: Release 11.2.0.3.0 - Production on Mon Jun 15 22:40:19 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
connected to target database: RACDB (DBID=878818271) connected to auxiliary database: RACDB(NOT MOUNTED)
执行 duplicate target  database for standby from active database dorecover nofilenamecheck;
 alter database recover managed standby database disconnect from session;
-------------------------------------------------
在主备库分别执行 select sequence#,applied from v$archived_log; 查看日志应用的状态

在主库中添加standby log
alter database add standby logfile group 5 ('+DATA/racdb/redo05.log') size 50m;
alter database add standby logfile group 6 ('+DATA/racdb/redo06.log') size 50m;
alter database add standby logfile group 7 ('+DATA/racdb/redo07.log') size 50m;
alter database add standby logfile group 8 ('+DATA/racdb/redo08.log') size 50m;
alter database add standby logfile group 9 ('+DATA/racdb/redo09.log') size 50m;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30166976/viewspace-1700620/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30166976/viewspace-1700620/