在Oracle 12C上实施ACFS replication
在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