环境：
操作系统： 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
|
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
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
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
|
1
2
3
4
5
6
7
8
|
/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
|
1
2
3
4
5
|
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
|
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
|
[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
|
1
2
3
4
5
6
7
8
|
/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后，问题解决 ！
