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
1 2 3 4 5 6 7 8 9 10 11 12 13 |
|
[root@aix211 /]#smit crfs
650) this.width=650;" title="aix1.png" alt="wKioL1PjOnzD-2m3AAHDYbqZwsA096.jpg" />
[root@aix211 /]#df -m
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
|
[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
1 2 3 4 5 6 7 8 |
|
[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
1 2 3 4 5 |
|
5、测试Flashback Recovery Area
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 |
|
@默认,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
1 2 3 4 5 6 7 8 |
|
@重新mount后,问题解决 !