AIXRAC配置FlashbackRecoveryArea

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

[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后，问题解决 ！