ORACLE LINUX 11G RAC 单实例DATAGUARD - 图文

ORACLE LINUX 11G RAC 单实例DATAGUARD 环境说明：

源库：

双节点RAC: CPU:12 MEM:8G

操作系统：Linux 2.6.18-194.el5

10.135.33.170 11grac1.fawcar.com.cn 11grac1 10.135.33.171 11grac2.fawcar.com.cn 11grac2

10.135.33.172 11grac1-vip.fawcar.com.cn 11grac1-vip 10.135.33.173 11grac2-vip.fawcar.com.cn 11grac2-vip DB_NAME=oem

db_unique_Name=oem

DATAGUARD目标库： 单实例 CPU:4 MEM:6G

操作系统：Linux 2.6.18-194.el5 10.135.161.241 DB_NAME=oem

db_unique_name=dgtest

安装步骤

一、

源库设置强制归档：

二、

源库设置参数，设置完毕后参数如下所示

DB_NAME=oem

DB_UNIQUE_NAME=oem

LOG_ARCHIVE_CONFIG='DG_CONFIG=(oem,oem_dg)' LOG_ARCHIVE_DEST_1='LOCATION=/dbfs_backup/oem

VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=oem' LOG_ARCHIVE_DEST_2='SERVICE=oem_dg LGWR AFFIRM

VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=oem_dg'

LOG_ARCHIVE_DEST_STATE_1=ENABLE LOG_ARCHIVE_DEST_STATE_2=ENABLE REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE LOG_ARCHIVE_FORMAT=%t_%s_%r.arc LOG_ARCHIVE_MAX_PROCESSES=4 FAL_SERVER=oem_dg

DB_FILE_NAME_CONVERT='/oradata/oem_dg/datafile/','+DATA/oem/datafile/'

LOG_FILE_NAME_CONVERT= '/oradata/oem_dg/','+DATA/oem/ STANDBY_FILE_MANAGEMENT=AUTO

执行如下命令设置：

alter system set LOG_ARCHIVE_CONFIG='DG_CONFIG=(oem,oem_dg)' scope=both sid='*';

alter system set LOG_ARCHIVE_DEST_1='LOCATION=/dbfs_backup/oem VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=oem' scope=both sid='*';

alter system set LOG_ARCHIVE_DEST_2='SERVICE=oem_dg LGWR AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=oem_dg' scope=both sid='*';

alter system set log_archive_format='%t_%s_%r.arc' scope=spfile sid='*';

alter system set log_archive_max_processes=4 scope=both sid='*'; alter system set fal_server=oem_dg scope=both sid='*'; alter system set

DB_FILE_NAME_CONVERT='/oradata/oem_dg/datafile/','+DATA/oem/datafile/' scope=spfile sid='*';

alter system set LOG_FILE_NAME_CONVERT=

'/oradata/oem_dg/,'+DATA/oem/' scope=spfile sid='*';

alter system set standby_file_management=AUTO scope=both sid='*';

三、 重启源库，设置为归档模式。 srvctl stop database –d oem –o immediate; srvctl start database –d oem

注：

重启11grac2报错：

srvctl stop database –d oem –o immediate; srvctl start database –d oem

+ASM2

ORA-00600: internal error code, arguments: [spstp: ORACLE_HOME uid does not match euid], [504], [500], [], [], [], [], [], [], [], [], []

查看是grid用户下的的$oracle_home目录的权限改变了，全都变成了oracle:oinstall，修改成grid:oinstall后，ASM启动正常。 启动实例2时候报错：

NOTE: Deferred communication with ASM instance ERROR: kfnUseConn - failure to make a connection

WARNING: ASM communication error: op 0 state 0x0 (15055) ERROR: direct connection failure with ASM

NOTE: Deferred communication with ASM instance ORA-15055: unable to connect to ASM instance ORA-01034: ORACLE not available

ORA-27123: unable to attach to shared memory segment Linux-x86_64 Error: 13: Permission denied

ERROR: kfnUseConn - failure to make a connection

WARNING: ASM communication error: op 0 state 0x0 (15055) ERROR: direct connection failure with ASM

NOTE: Deferred communication with ASM instance ORA-15055: unable to connect to ASM instance ORA-01034: ORACLE not available

ORA-27123: unable to attach to shared memory segment Linux-x86_64 Error: 13: Permission denied

ERROR: kfnUseConn - failure to make a connection

WARNING: ASM communication error: op 0 state 0x0 (15055) ERROR: direct connection failure with ASM

NOTE: Deferred communication with ASM instance ORA-15055: unable to connect to ASM instance ORA-01034: ORACLE not available

ORA-27123: unable to attach to shared memory segment Linux-x86_64 Error: 13: Permission denied

ERROR: kfnUseConn - failure to make a connection

每个节点上$ORACLE_HOME/bin/oracle，$GRID_HOME/bin/oracle权限应该一样，是6751： -rwsr-s—x

检查11grac2的这两个文件，发现GRID_HOME/bin/oracled的权限为： -rwxrwxrwx 1 grid oinstall 203973009 Jul 30 21:43 oracle 修改：

chmod 6751 oracle 为：

-rwsr-s--x 1 grid oinstall 203973009 Jul 30 21:43 oracle

启动11grac2实例，正常。

四、 源库检查修改的参数：

数据库重启完毕，检查修改的参数是否正确：

set linesize 500 pages 0 col value for a90 col name for a50

select name, value from v$parameter

where name in ('db_name','db_unique_name','log_archive_config', 'log_archive_dest_1','log_archive_dest_2',

'log_archive_dest_state_1','log_archive_dest_state_2', 'remote_login_passwordfile',

'log_archive_format','log_archive_max_processes','fal_server','db_file_name_convert',

'log_file_name_convert', 'standby_file_management');