kfnuseconn oracle,RAC +DG

SQL> alter system set log_archive_config='DG_CONFIG=(dominic,dominic_s)' scope=both sid='*';

System altered.

SQL> alter system set log_archive_dest_1='location=+ARCHIVELOG/archive_logVALID_FOR=(ALL_LOGFILES,ALL_ROLES)DB_UNIQUE_NAME=dominic'scope=both sid='*';

System altered.

SQL> alter system set log_archive_dest_2='service=dominic_ssync affirm lgwrVALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)DB_UNIQUE_NAME=dominic_s'scope=both sid='*';

System altered.

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

System altered.

SQL> alter system set log_archive_max_processes=4 scope=both sid='*';

System altered.

SQL> alter system set fal_server=dominic scope=both sid='*';

System altered.

SQL> alter system set fal_client=dominic_s scope=both sid='*';

System altered.

SQL> alter system set DB_FILE_NAME_CONVERT='/u01/app/oracle/datafile/','+DATAFILE/dominic/datafile/','/u01/app/oracle/tempfile/','+DATAFILE/dominic/tempfile/' scope=spfile sid='*';

SQL> alter system set LOG_FILE_NAME_CONVERT='/u01/app/oracle/logfile/','+DATAFILE/dominic/onlinelog/','/u01/app/oracle/oradata/','+ARCHIVELOG/dominic/onlinelog/' scope=spfile sid='*';

System altered.

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

System altered.

创建备份文件pfile 文件。

SQL> create pfile='/u01/app/oracle/db_back/p_pfile' from spfile;

File created.

完之后，source RAC 参数文件为：

主的pfile 文件：

[oracle@lmocm189 db_back]$ cat p_pfile

dominic1.__db_cache_size=285212672

dominic2.__db_cache_size=285212672

dominic1.__java_pool_size=16777216

dominic2.__java_pool_size=16777216

dominic1.__large_pool_size=16777216

dominic2.__large_pool_size=16777216

dominic1.__pga_aggregate_target=402653184

dominic2.__pga_aggregate_target=402653184

dominic1.__sga_target=754974720

dominic2.__sga_target=754974720

dominic1.__shared_io_pool_size=0

dominic2.__shared_io_pool_size=0

dominic1.__shared_pool_size=402653184

dominic2.__shared_pool_size=419430400

dominic2.__streams_pool_size=0

dominic1.__streams_pool_size=16777216

*.audit_file_dest='/u01/app/oracle/admin/dominic/adump'

*.audit_trail='db'

*.cluster_database=true

*.compatible='11.2.0.0.0'

*.control_files='+DATAFILE/dominic/controlfile/current.260.825093345','+ARCHIVELOG/dominic/controlfile/current.256.825093345'

*.db_block_size=8192

*.db_create_file_dest='+DATAFILE'

*.db_domain=''

*.db_file_name_convert='/u01/app/oracle/datafile/','+DATAFILE/dominic/datafile/'

*.db_name='dominic'

*.db_recovery_file_dest='+ARCHIVELOG'

*.db_recovery_file_dest_size=4558159872

*.diagnostic_dest='/u01/app/oracle'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=dominicXDB)'

*.fal_client='DOMINIC_S'

*.fal_server='DOMINIC'

dominic2.instance_number=2

dominic1.instance_number=1

*.log_archive_config='DG_CONFIG=(dominic,dominic_s)'

*.log_archive_dest_1='location=+ARCHIVELOG/archive_log VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=dominic'

*.log_archive_dest_2='service=dominic_s sync affirm lgwr VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=dominic_s'

*.log_archive_format='%t_%s_%r.arc'

*.log_archive_max_processes=4

*.log_file_name_convert='/u01/app/oracle/logfile/','+DATAFILE/dominic/onlinelog/','/u01/app/oracle/oradata/','+ARCHIVELOG/dominic/onlinelog/'

*.memory_target=1153433600

*.open_cursors=300

*.processes=150

*.remote_listener='scan.com:1521'

*.remote_login_passwordfile='exclusive'

*.sessions=170

*.standby_file_management='AUTO'

dominic2.thread=2

dominic1.thread=1

dominic2.undo_tablespace='UNDOTBS2'

dominic1.undo_tablespace='UNDOTBS1'

4， 根据source 备份pfile 设置target node单实例参数文件：

[oracle@lmocm191 db_back]$ cat s_pfile

*.audit_file_dest='/u01/app/oracle/admin/dominic_s/adump'

*.audit_trail='db'

*.cluster_database=false

*.compatible='11.2.0.0.0'

*.control_files='/u01/app/oracle/oradata/dominic_s/controlfile/current.260.825093345','/u01/app/oracle/datafile/controlfile/current.256.825093345'

*.db_block_size=8192

*.db_create_file_dest='/u01/app/oracle'

*.db_domain=''

*.db_file_name_convert='+DATAFILE/dominic/datafile/','/u01/app/oracle/datafile/','+DATAFILE/dominic/tempfile/','/u01/app/oracle/tempfile/'

*.db_name='dominic'

*.db_unique_name='dominic_s'

*.db_recovery_file_dest='/u01/app/oracle/oradata/flashback_log'

*.db_recovery_file_dest_size=4558159872

*.diagnostic_dest='/u01/app/oracle'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=dominicXDB)'

*.fal_client='DOMINIC_S'

*.fal_server='DOMINIC'

*.log_archive_config='DG_CONFIG=(dominic,dominic_s)'

*.log_archive_dest_1='location=/u01/app/oracle/archive_log VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=dominic_s'

*.log_archive_dest_2='service=dominic sync affirm lgwr VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=dominic'

*.log_archive_format='%t_%s_%r.arc'

*.log_archive_max_processes=4

*.log_file_name_convert='+DATAFILE/dominic/onlinelog/','/u01/app/oracle/logfile/','+ARCHIVELOG/dominic/onlinelog/','/u01/app/oracle/oradata/'

*.memory_target=1153433600

*.open_cursors=300

*.processes=150

*.remote_listener='scan.com:1521'

*.remote_login_passwordfile='exclusive'

*.sessions=170

*.standby_file_management='AUTO'

*.undo_tablespace='UNDOTBS1'

----其实NODE+NODE 单实例DG 和 RAC+node ,RAC+RAC 参数文件差不多，只是路劲，service,unique_name 有些区别。

5， 如果在之前，SOURCE RAC 不是在归档模式，那么需要在mount下，开启归档。

重启源库，设置为归档模式。

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

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

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

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_s

erver','db_file_name_convert',

'log_file_name_convert', 'standby_file_management');

6，SOURCE 端$ORACLE_HOME/dbs 下，拷贝密码文件 到备份目录下：

源库节点一：

orapwd file=/u01/app/oracle/11.2/dbhome_1/dbs/orapwoem1 password=Oracle11 force=y

传递到节点二：

scp /u01/app/oracle/11.2/dbhome_1/dbs/orapwoem1 11grac2:/u01/app/oracle/11.2/dbhome_1/dbs/

mv /u01/app/oracle/11.2.0/db_1/dbs/orapwdominic1 /u01/app/oracle/11.2.0/db_1/dbs/orapwdominic2

传递到目标库：

scp /u01/app/oracle/11.2.0/db_1/dbs/orapwoem1 DGTEST: /app/oracle/11.2.0/db_1/dbs/

mv /app/oracle/11.2.0/db_1/dbs/ orapwoem1 /app/oracle/11.2.0/db_1/dbs/ orapwoem

7,修改源端RAC，目标端node 的监听文件：target：netca, netmgr都可！

TNSNAME.ORA 文件： target端，source端 都要修改。

[oracle@lmocm191 admin]$ cat tnsnames.ora

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2/dbhome_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

DOMINIC_S =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = lmocm191)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = dominic)

)

)

DOMINIC =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = scan.com)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = dominic)

)

)--RAC 全局监听

DOMINIC1 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST=lmocm189)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = dominic)

(SID=dominic1)

)

)--RAC 实例1

DOMINIC2 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST=lmocm190)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = dominic)

(SID=dominic2)

)

)--RAC 实例2