在oracle 12c上实施acfs replication
环境: 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
copyright (c) 1982, 2013, oracle. all rights reserved.
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