首页 > 数据库 > mysql教程 > AIXRAC配置FlashbackRecoveryArea

AIXRAC配置FlashbackRecoveryArea

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
发布: 2016-06-07 14:51:59
原创
1352 人浏览过

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

wKiom1M-fceBv-0sAAFsPugZXrI173.jpg

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

650) this.width=650;" title="aix1.png" alt="wKioL1PjOnzD-2m3AAHDYbqZwsA096.jpg" />

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






相关标签:
本站声明
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn
热门教程
更多>
最新下载
更多>
网站特效
网站源码
网站素材
前端模板