aix rac配置flashback recovery area
环境：
操作系统： aix 5300-09
集群软件： crs 10.2.0.1
数据库： oracle 10.2.0.1
650) this.width=650; src=http://www.68idc.cn/help/uploads/allimg/160303/1231434632-0.jpg title=rac.png alt=wkiom1m-fcebv-0saafspugzxri173.jpg style=max-width:90%>
本案例是用于基于vg concurrent 的共享存储，通过hacmp 实现卷组的并发
由于共享存储采用了并发卷组，在上面不能建立文件系统；并且flashback recover area亦不能建立在raw上，所以在本地卷组上建立文件系统，通过nfs共享方式来建立flashback recover area。
1、在node1上建立文件系统
[root@aix211 /]#lsvg rootvg
volume group: rootvg vg identifier: 00040f8a00004c0000000140c6da55a7vg state: active pp size: 128 megabyte(s)vg permission: read/write total pps: 546 (69888 megabytes)max lvs: 256 free pps: 190 (24320 megabytes)lvs: 17 used pps: 356 (45568 megabytes)open lvs: 16 quorum: 2 (enabled)total pvs: 1 vg descriptors: 2stale pvs: 0 stale pps: 0active pvs: 1 auto on: yesmax pps per vg: 32512 max pps per pv: 1016 max pvs: 32ltg size (dynamic): 256 kilobyte(s) auto sync: nohot spare: no bb policy: relocatable
[root@aix211 /]#smit crfs
650) this.width=650; src=http://www.68idc.cn/help/uploads/allimg/160303/1231436360-1.jpg title=aix1.png alt=wkiol1pjonzd-2m3aahdybqzwsa096.jpg />
[root@aix211 /]#df -m
filesystem mb blocks free %used iused %iused mounted on/dev/hd4 6144.00 2070.94 67% 8211 1% //dev/hd2 3072.00 911.26 71% 51509 7% /usr/dev/hd9var 2048.00 1809.38 12% 5557 2% /var/dev/hd3 2048.00 1827.30 11% 381 1% /tmp/dev/hd1 2048.00 1293.68 37% 223 1% /home/proc - - - - - /proc/dev/hd10opt 1024.00 702.17 32% 5604 3% /opt/dev/lv00 15360.00 2490.89 84% 33598 1% /u01/dev/lv01 128.00 123.94 4% 18 1% /var/adm/csd/dev/lv02 4096.00 3967.39 4% 16 1% /arch/dev/lv03 2048.00 1983.67 4% 17 1% /dsk1/dev/lv04 2048.00 1983.67 4% 17 1% /dsk2/dev/lv05 128.00 123.94 4% 17 1% /flash_rcy
[root@aix211 /]#chown -r oracle:dba /flash_rcy
2、配置flashback directory共享
[root@aix211 /]#cat /etc/exports
/soft2 -sec=sys:krb5p:krb5i:krb5:dh,rw,access=aix212:aix199
/flash_rcy -sec=sys:krb5p:krb5i:krb5:dh,rw,root=aix212
3、在node2上配置共享访问flashback directory
[root@aix212@ /]#cat /etc/filesystems
/flash_rcy: dev = /flash_rcy vfs = nfs nodename = 192.168.8.211 mount = true options = rw,bg,hard,intr,proto=tcp,vers=3,rsize=65536,wsize=65536,timeo=600 account = false
[oracle@aix212@ /]$mkdir /flash_rcy
[root@aix212@ /]#ls -ld /flash_rcy
drwxr-sr-x 4 oracle dba 512 aug 7 15:44 /flash_rcy
[root@aix212@ /]#mount /flash_rcy
[oracle@aix212@ ~]$mount
node mounted mounted over vfs date options
-------- --------------- --------------- ------ ------------ ---------------
192.168.8.211 /flash_rcy /flash_rcy nfs3 aug 07 15:53 rw,bg,hard,intr,proto=tcp,vers=3,rsize=65536,wsize=65536,timeo=60
4、配置flashback recovery area
sql> show parameter recoveryname type value------------------------------------ ----------- ------------------------------db_recovery_file_dest string /flash_rcydb_recovery_file_dest_size big integer 2g
5、测试flashback recovery area
[oracle@aix212@ ~]$rman target /recovery manager: release 10.2.0.1.0 - production on thu aug 7 15:53:31 2014copyright (c) 1982, 2005, oracle. all rights reserved.connected to target database: prod (dbid=266564886, not open)rman> backup current controlfile;starting backup at 07-aug-14using channel ora_disk_1channel ora_disk_1: starting full datafile backupsetchannel ora_disk_1: specifying datafile(s) in backupsetincluding current control file in backupsetchannel ora_disk_1: starting piece 1 at 07-aug-14channel ora_disk_1: finished piece 1 at 07-aug-14piece handle=/flash_rcy/prod/backupset/2014_08_07/o1_mf_ncnnf_tag20140807t155423_9y68o0ff_.bkp tag=tag20140807t155423 comment=nonechannel ora_disk_1: backup set complete, elapsed time: 00:00:04finished backup at 07-aug-14rman> list backup ; list of backup sets===================bs key type lv size device type elapsed time completion time------- ---- -- ---------- ----------- ------------ ---------------1 full 10.86m disk 00:00:04 07-aug-14 bp key: 1 status: available compressed: no tag: tag20140807t155338 piece name: /flash_rcy/prod/backupset/2014_08_07/o1_mf_ncsnf_tag20140807t155338_9y68mp2s_.bkp control file included: ckp scn: 909245 ckp time: 07-aug-14 spfile included: modification time: 07-aug-14bs key type lv size device type elapsed time completion time------- ---- -- ---------- ----------- ------------ ---------------2 full 10.83m disk 00:00:02 07-aug-14 bp key: 2 status: available compressed: no tag: tag20140807t155423 piece name: /flash_rcy/prod/backupset/2014_08_07/o1_mf_ncnnf_tag20140807t155423_9y68o0ff_.bkp control file included: ckp scn: 909245 ckp time: 07-aug-14
@默认，rman备份存储到flashback recovery area，至此flashbackup recovery area配置完成！
错误案例：访问flashback recovery area失败
[oracle@aix212@ ~]$rman target /
recovery manager: release 10.2.0.1.0 - production on thu aug 7 15:48:33 2014
copyright (c) 1982, 2005, oracle. all rights reserved.
connected to target database: prod (dbid=266564886, not open)
rman> backup database;
starting backup at 07-aug-14
using target database control file instead of recovery catalog
allocated channel: ora_disk_1
channel ora_disk_1: sid=151 instance=prod2 devtype=disk
channel ora_disk_1: starting full datafile backupset
channel ora_disk_1: specifying datafile(s) in backupset
rman-03009: failure of backup command on ora_disk_1 channel at 08/07/2014 15:48:44
ora-19602: cannot backup or copy active file in noarchivelog mode
continuing other job steps, job failed will not be re-run
channel ora_disk_1: starting full datafile backupset
channel ora_disk_1: specifying datafile(s) in backupset
including current control file in backupset
including current spfile in backupset
channel ora_disk_1: starting piece 1 at 07-aug-14
rman-00571: ===========================================================
rman-00569: =============== error message stack follows ===============
rman-00571: ===========================================================
rman-03009: failure of backup command on ora_disk_1 channel at 08/07/2014 15:48:47
ora-19504: failed to create file /flash_rcy/prod/backupset/2014_08_07/o1_mf_ncsnf_tag20140807t154843_%u_.bkp
ora-27054: nfs file system where the file is created or resides is not mounted with correct options
additional information: 6
解决方法：
在/etc/filesystems配置mount参数：
[root@aix212@ /]#cat /etc/filesystems
/flash_rcy: dev = /flash_rcy vfs = nfs nodename = 192.168.8.211 mount = true options = rw,bg,hard,intr,proto=tcp,vers=3,rsize=65536,wsize=65536,timeo=600 account = false
@重新mount后，问题解决 ！