ORACLE LINUX 11G RAC 单实例DATAGUARD
环境说明：
源库：
双节点RAC:
CPU:12
MEM:8G
操作系统：Linux 2.6.18-194.el5
10.135.33.170  11grac1.fawcar  11grac1
10.135.33.171  11grac2.fawcar  11grac2
10.135.33.172  11grac1-vip.fawcar      11grac1-vip
10.135.33.173  11grac2-vip.fawcar      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;
linux安装oracle 11gsrvctl 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

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。