Shulou(Shulou.com)06/01 Report--

AIX RAC configuration Flashback Recovery Area

Environment:

Operating system: AIX 5300-09

Cluster software: CRS 10.2.0.1

Database: Oracle 10.2.0.1

This case is used for VG Concurrent-based shared storage to realize the concurrency of volume groups through HACMP.

Because the shared storage uses concurrent volume groups, the file system cannot be established on it, and the Flashback Recover Area cannot be built on raw, so the file system is established on the local volume group, and the Flashback Recover Area is established through NFS sharing.

1. Set up a file system on node1

[root@aix211 /] # lsvg rootvg

VOLUME GROUP: rootvg VG IDENTIFIER: 00040f8a00004c0000000140c6da55a7VG STATE: active PP SIZE: 128megabyte (s) VG PERMISSION: read/write TOTAL PPs: 546 (69888 megabytes) MAX LVs: 256FREE PPs: 190 (24320 megabytes) LVs: 17 USED PPs: 356 (45568 megabytes) OPEN LVs: 16 QUORUM: 2 (Enabled) TOTAL PVs: 1 VG DESCRIPTORS: 2STALE PVs: 0 STALE PPs: 0ACTIVE PVs: 1 AUTO ON: yesMAX PPs per VG: 32512 MAX PPs per PV: 1016 MAX PVs: 32LTG size (Dynamic): 256kilobyte (s) AUTO SYNC: noHOT 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 / / 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% 161% / 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. Configure Flashback Directory sharing

[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. Configure shared access Flashback Directory on node2

[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=600 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. Configure Flashback Recovery Area

SQL > show parameter recoveryNAME TYPE VALUE-- db_recovery_file_dest string / flash_rcydb_recovery_file_dest_size big integer 2G

5. Test Flashback Recovery Area

[oracle@aix212@] $rman target / Recovery Manager: Release 10.2.0.1.0-Production on Thu Aug 7 15:53:31 2014Copyright (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-14using channel ORA_DISK_1channel ORA_DISK_1: starting full datafile backupsetchannel ORA_DISK_1: specifying datafile (s) in backupsetincluding current control file in backupsetchannel ORA_DISK_1: starting piece 1 at 07-AUG-14channel ORA_DISK_1: finished piece 1 at 07-AUG-14piece handle=/flash_rcy/PROD/backupset/2014_08_07/o1_mf_ncnnf_TAG20140807T155423_9y68o0ff_.bkp tag=TAG20140807T155423 comment=NONEchannel ORA_DISK_1: backupset complete, elapsed time: 00:00:04Finished backup at 07-AUG-14RMAN > 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-14BS 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

@ by default, RMAN backups are stored to Flashback Recovery Area, and Flashbackup Recovery Area configuration is complete!

Error case: failed to access 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

Solution:

Configure the mount parameter in / etc/filesystems:

[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=600 account = false

@ after re-mount, the problem is solved!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.