Configure FlashbackRecoveryArea for AIXRAC

AIXRAC configure FlashbackRecoveryArea environment: Operating System: AIX5300-09 cluster software: CRS10.2.0.1 Database: Lightning altwKiom1M-fceBv

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 650) this. width = 650; "src =" http://www.68idc.cn/help/uploads/allimg/160303/1231434632-0.jpg "title =" rac.png "alt =" wKiom1M-fceBv

Configure Flashback Recovery Area for AIX RAC

Environment:

Operating System: AIX 5300-09

Cluster software: CRS 10.2.0.1

Database: 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-0sAAFsPugZXrI173.jpg "style =" padding: 0px; margin: 0px; vertical-align: top; border: none; "/>

This case is used for shared storage based on VG Concurrent. The concurrency of volume groups is achieved through HACMP.

Because shared storage uses a concurrent volume group, a file system cannot be created on it, and Flashback Recover Area cannot be created on raw. Therefore, a file system is created on a local volume group through NFS.Share mode to establishFlashback Recover Area.

1. Create a file system on node1.

[Root @ aix211/] # lsvg rootvg

VOLUME GROUP:       rootvg                   VG IDENTIFIER:  00040f8a00004c0000000140c6da55a7VG 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: 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): 256 kilobyte(s)          AUTO SYNC:      noHOT SPARE:          no                       BB POLICY:      relocatable

[Root @ aix211/] # smit crfs

650) this. width = 650; "src =" http://www.68idc.cn/help/uploads/allimg/160303/1231436360-1.jpg "title =" aix1.png "alt =" wKioL1PjOnzD-2m3AAHDYbqZwsA096.jpg "/>

[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. Configure Flashback Directory sharing

[Root @ aix211/] # cat/etc/exports

/Soft2-sec = sys: krb5: krb5i: krb5: dh, rw, access = aix212: aix199

/Flash_rcy-sec = sys: krb5: krb5i: krb5: dh, rw, root = aix212

3. Configure shared access to 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/flash_rcy

[Root @ aix212 @/] # mount/flash_rcy

[Oracle @ aix212 @ ~] $ Mount

Node mounted over vfs date options

-----------------------------------------------------------------------

192.168.8.211/flash_rcy nfs3 Aug 07 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: backup set 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 is backed up and stored in the Flashback Recovery Area. So far, Flashbackup Recovery Area has been configured!

Error case: Access to Flashback Recovery Area failed

[Oracle @ aix212 @ ~] $ Rman target/

Recovery Manager: Release 10.2.0.1.0-Production on Thu Aug 7 15:48:33 2014

Copyright (c) 1982,200 5, 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:

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!