AIX RAC配置Flashback Recovery Area

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,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,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,timeo=60
0
????????account?????????=?false

@重新mount后，问题解决 ！