在Oracle 12C上实施ACFS replication(一)

2015-02-02 20:43:03 · 作者: · 浏览: 7

环境: qc550705 & qc550707, AIX6.1+12c RAC


Primary FS: qc550705:/acfs3


Standby FS: qc550707:/acfsstd1


实施前提:primary FS的可用空间必须等于其已使用空间


以下是实施Replication的步骤:


1、 建立replication admin(一个节点上操作)


grid@qc550705:/home/grid>sqlplus "/as sysasm"


?


SQL*Plus: Release 12.1.0.1.0 Production on Fri Feb 14 16:24:33 2014


?


?


?


Connected to:


Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production


With the Real Application Clusters and Automatic Storage Management options


?


SQL> CREATE USER acfsrep1 IDENTIFIED BY "773946";


?


User created.


?


SQL> GRANT sysasm,sysdba TO acfsrep1;


?


Grant succeeded.。


?


2、 建立standby FS


--Add ACFS volume


SQL> select a.group_number,b.name,a.name,value from v$asm_attribute a,v$asm_diskgroup b where lower(a.name) like '%compatible%' and b.group_number=a.group_number;


?


GROUP_NUMBER NAME? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? NAME? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? VALUE


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


? ? ? ? ? 1 ACFSDG? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? compatible.asm? ? ? ? ? ? ? ? ? ? ? ? ? 12.1.0.0.0


? ? ? ? ? 1 ACFSDG? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? compatible.rdbms? ? ? ? ? ? ? ? ? ? ? ? 12.1.0.0.0


? ? ? ? ? 1 ACFSDG? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? compatible.advm? ? ? ? ? ? ? ? ? ? ? ? ? 12.1.0.0.0


? ? ? ? ? 2 SYSDG? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? compatible.asm? ? ? ? ? ? ? ? ? ? ? ? ? 12.1.0.0.0


? ? ? ? ? 2 SYSDG? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? compatible.rdbms? ? ? ? ? ? ? ? ? ? ? ? 10.1.0.0.0


?


SQL> alter diskgroup acfsdg add volume acfsvol_std1 size 16G unprotected stripe_columns 1;


?


Diskgroup altered.


?


SQL> quit


Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production


With the Real Application Clusters and Automatic Storage Management options


grid@qc550707:/home/grid>ls -l /dev/asm/acfsvol*


brw-rw-r--? ? 1 root? ? asmadmin? ? 50,24577 Jan 29 13:46 /dev/asm/acfsvol1-48


brw-rw-r--? ? 1 root? ? asmadmin? ? 50,24578 Jan 29 12:31 /dev/asm/acfsvol3-48


brw-rw-r--? ? 1 root? ? asmadmin? ? 50,24579 Feb 14 16:32 /dev/asm/acfsvol_std1-48


grid@qc550707:/home/grid>mkfs -V acfs -s 16G /dev/asm/acfsvol_std1-48


mkfs: version? ? ? ? ? ? ? ? ? = 12.1.0.1.0


mkfs: on-disk version? ? ? ? ? = 39.0


mkfs: volume? ? ? ? ? ? ? ? ? ? = /dev/asm/acfsvol_std1-48


mkfs: volume size? ? ? ? ? ? ? = 17179869184


mkfs: Format complete.


?


--Mount /acfsstd1


root@qc550707:/>srvctl add filesystem -device /dev/asm/acfsvol_std1-48 -path /acfsstd1 -node qc550707


root@qc550707:/>srvctl start filesystem -device /dev/asm/acfsvol_std1-48 -node qc550707


?


root@qc550707:/>crsctl status res ora.acfsdg.acfsvol_std1.acfs -t


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


Name? ? ? ? ? Target? State? ? ? ? Server? ? ? ? ? ? ? ? ? State details


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


Cluster Resources


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


ora.acfsdg.acfsvol_std1.acfs


? ? ? 1? ? ? ? ONLINE? ONLINE? ? ? qc550707? ? ? ? ? ? ? ? mounted on /acfsstd1


? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ,STABLE


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


?


3、 为ASM instances增加ACFS replication专用的Service(两节点都要执行)?


--add service name for +ASM1


grid@qc550705:/home/grid>sqlplus "/as sysasm"


?


SQL*Plus: Release 12.1.0.1.0 Production on Fri Feb 14 16:36:29 2014


?


Copyright (c) 1982, 2013, Oracle.? All rights reserved.


?


?


Connected to:


Oracle Database 12c Enterprise Edition Release 12