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
AIX RAC配置Flashback Recovery Area
环境：
操作系统： AIX 5300-09
集群软件： CRS 10.2.0.1
数据库： Oracle 10.2.0.1
本案例是用于基于VG Concurrent 的共享存储，通过HACMP 实现卷组的并发
由于共享存储采用了并发卷组，在上面不能建立文件系统；并且Flashback Recover Area亦不能建立在raw上，所以在本地卷组上建立文件系统，通过NFS共享方式来建立Flashback Recover Area。
1、在node1上建立文件系统
[root@aix211 /]#lsvg rootvg
VOLUME GROUP: rootvg VG IDENTIFIER: 00040f8a00004c0000000140c6da55a7 VG 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: 2 STALE PVs: 0 STALE PPs: 0 ACTIVE PVs: 1 AUTO ON: yes MAX PPs per VG: 32512 MAX PPs per PV: 1016 MAX PVs: 32 LTG size (Dynamic): 256 kilobyte(s) AUTO SYNC: no HOT 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=60
0
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 recovery NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest string /flash_rcy db_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 2014
Copyright (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-14
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
channel ORA_DISK_1: starting piece 1 at 07-AUG-14
channel ORA_DISK_1: finished piece 1 at 07-AUG-14
piece handle=/flash_rcy/PROD/backupset/2014_08_07/o1_mf_ncnnf_TAG20140807T155423_9y68o0ff_.bkp tag=TAG20140807T155423 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:04
Finished backup at 07-AUG-14
RMAN> 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-14
BS 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=60
0
account = false@重新mount后，问题解决 ！
How to convert pdf to xml format
What does Taobao b2c mean?
Can Douyin recharge phone bills be refunded?
How much is one Bitcoin in RMB?
How to solve the problem when the computer CPU temperature is too high
Solution to split word table into two pages
What card is TF card?
How to connect to access database in vb
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
