欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

AIXRAC配置FlashbackRecoveryArea

程序员文章站 2022-04-15 10:41:20
...

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

AIXRAC配置FlashbackRecoveryArea

本案例是用于基于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

AIXRAC配置FlashbackRecoveryArea

[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后,问题解决 !