您好,欢迎访问一九零五行业门户网

在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
其它类似信息

推荐信息