Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

61

积分

0

好友

0

主题
1#
发表于 2012-4-13 16:02:49 | 查看: 7778| 回复: 6
服务器是:HP server(服务器没有本地硬盘)
存储服务器:SUN

SA在HP server装不上redhat5.x,所以我们在redhat6.0上测试11gRAC安装,但又以下几个问题:
1. oracle不提供redhat6.0的ASMlib驱动,不能使用ASMlib管理ASM磁盘了。
2. 打算用udev替换ASMlib,但SUN存储使用了多路径,udev没能设别出来多路径。
3. 使用raw可以成功创建ASM磁盘组,也可以成功创建数据库,并且正常使用,但不知道用raw直接创建ASM磁盘组能不能用生产环境,稳定性和性能怎么样?
不清楚那种方案更适合生产环境,高手们请帮忙分析一下!

另外有个疑问,如果在redhat5.x上安装oracle11gRAC,ASMlib能识别多路径吗?
感谢大家!
2#
发表于 2012-4-13 21:22:07
[root@vrh6 ~]# uname -a
Linux vrh6 2.6.32-300.3.1.el6uek.x86_64 #1 SMP Fri Dec 9 18:57:35 EST 2011 x86_64 x86_64 x86_64 GNU/Linux

[root@vrh6 ~]# cat /etc/issue
Oracle Linux Server release 6.2
Kernel \r on an \m

[root@vrh6 ~]# cat /etc/oracle-release
Oracle Linux Server release 6.2


[root@vrh6 ~]# yum install oracleasm-support
Loaded plugins: security
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package oracleasm-support.x86_64 0:2.1.5-1.el6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

========================================================================================================================================================================
Package                                       Arch                               Version                                  Repository                              Size
========================================================================================================================================================================
Installing:
oracleasm-support                             x86_64                             2.1.5-1.el6                              ol6_latest                              73 k

Transaction Summary
========================================================================================================================================================================
Install       1 Package(s)

Total download size: 73 k
Installed size: 214 k
Is this ok [y/N]: y
Downloading Packages:
oracleasm-support-2.1.5-1.el6.x86_64.rpm                                                                                                         |  73 kB     00:01     
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : oracleasm-support-2.1.5-1.el6.x86_64                                                                                                                 1/1

Installed:
  oracleasm-support.x86_64 0:2.1.5-1.el6                                                                                                                                






[root@vrh6 ~]# oracleasm
Usage: oracleasm [--exec-path=<exec_path>] <command> [ <args> ]
       oracleasm --exec-path
       oracleasm -h
       oracleasm -V

The basic oracleasm commands are:
    configure        Configure the Oracle Linux ASMLib driver
    init             Load and initialize the ASMLib driver
    exit             Stop the ASMLib driver
    scandisks        Scan the system for Oracle ASMLib disks
    status           Display the status of the Oracle ASMLib driver
    listdisks        List known Oracle ASMLib disks
    querydisk        Determine if a disk belongs to Oracle ASMlib
    createdisk       Allocate a device for Oracle ASMLib use
    deletedisk       Return a device to the operating system
    renamedisk       Change the label of an Oracle ASMlib disk
    update-driver    Download the latest ASMLib driver
       
       

[root@vrh6 ~]# /etc/init.d/oracleasm configure
Configuring the Oracle ASM library driver.

This will configure the on-boot properties of the Oracle ASM library
driver.  The following questions will determine whether the driver is
loaded on boot and what permissions it will have.  The current values
will be shown in brackets ('[]').  Hitting <ENTER> without typing an
answer will keep that current value.  Ctrl-C will abort.

Default user to own the driver interface []: oracle
Default group to own the driver interface []: dba
Start Oracle ASM library driver on boot (y/n) [n]: Y
Scan for Oracle ASM disks on boot (y/n) [y]: Y
Writing Oracle ASM library driver configuration: done
Initializing the Oracle ASMLib driver: [  OK  ]
Scanning the system for Oracle ASMLib disks: [  OK  ]
[root@vrh6 ~]#



Oracle Linux 6 u2 目前 提供kernel driver的oracleasm ,只需要安装oracleasm-support即可

回复 只看该作者 道具 举报

3#
发表于 2012-4-13 21:22:37
Oracle ASMLib Software Update Policy for Red Hat Enterprise Linux Supported by Red Hat

Applies to:
Linux x86
IBM: Linux on System z
IBM: Linux on POWER Systems
Linux x86-64
Linux Itanium
Red Hat Enterprise Linux:
RHEL3, RHEL4, RHEL5, RHEL6



Last updated: 26 April, 2010
What is being announced?

Purpose

This document outlines Oracle's support Policy for customers using ASMLib with Automatic Storage Management on Red Hat Enterprise Linux (RHEL) supported by Red Hat.


What is ASMLib?
ASMLib is free, optional software for the Automatic Storage Management (ASM) feature of Oracle Database that simplifies the management and discovery of ASM disks and makes I/O processing and kernel resource usage with ASM storage more efficient. ASMLib is not required to use the Automatic Storage Management (ASM) feature of Oracle Database on Linux and all features and functionality of ASM will work without ASMLib.
Software Update Policy for ASMLib running on Red Hat Enterprise Linux

Oracle provides ASMLib software and support for customers who receive Red Hat Enterprise Linux (RHEL) operating system support from Red Hat and have a valid Oracle database support contract. Only the latest release of ASMLib will be provided for new Linux kernels released with each new RHEL minor release ("Update"). For example, if Red Hat were to release kernel 2.6.18-194.0.1.el5, Oracle will only release the latest version of ASMLib, say 2.0.5, for that kernel. Oracle will not release any previous versions of ASMlib for that kernel.

Furthermore, ASMLib software is only provided for Linux kernels for which the corresponding packages (devel, src, binaries) are available to Oracle. For example, Oracle cannot provide ASMLib software for kernels provided under Red Hat's Extended Update Model or "z-stream" support.


Requirements for ASMLib Software Updates

To receive software updates for ASMLib, both the release of the Oracle database in use and the version of Red Hat Enterprise Linux in use must be fully supported by Oracle and Red Hat respectively. Specifically, the Oracle Database release must be covered under Premier support or Extended support as defined in the Oracle Lifetime Support Policy for Oracle Technology Products and the RHEL version must be supported under one of the Production Lifecycle Phases as defined in the Red Hat Enterprise Linux Life Cycle

Red Hat Enterprise Linux 5 (RHEL5) x86, x86-64, Itanium, and PowerPC
ASMLib software can be downloaded from the Oracle ASMLib Downloads for Red Hat Enterprise Linux Server 5 page on OTN. Updates and bug fixes to ASMLib are provided for Linux kernels that are part the latest supported release of RHEL5 listed in the Enterprise Linux Supported Releases document and three update releases prior to that. For example, if the latest supported release of RHEL is RHEL5, Update 5 (RHEL5.5), then updates to ASMLib will be provided for RHEL5.2, RHEL5.3, RHEL5.4 and RHEL5.5 kernels.

Red Hat Enterprise Linux 4 (RHEL4) x86, x86-64, Itanium, and PowerPC
ASMLib software can be downloaded from the Oracle ASMLib Downloads for Red Hat Enterprise Linux 4 AS page on OTN. Updates and bug fixes to ASMLib are provided for Linux kernels that are part of the latest supported release of RHEL4 listed in the Enterprise Linux Supported Releases document and three update releases prior to that. For example, if the latest supported release of RHEL is RHEL4, Update 8 (RHEL4.8), then updates to ASMLib will be provided for RHEL4.5, RHEL4.6, RHEL4.7, RHEL4.8 and RHEL4.9 kernels.

Red Hat Enterprise Linux 3 (RHEL3) x86 and x86-64

ASMLib software can be downloaded from the Oracle ASMLib Downloads for Red Hat Enterprise Linux 3 AS page on OTN. Updates and bug fixes to ASMLib are provided for RHEL3 Update 8 and Update 9 kernels only. Note that RHEL3 will no longer be supported by Red Hat after October 31, 2010 (End of Red Hat's Regular Life Cycle). As such, Oracle will no longer provide ASMLib software updates or support for RHEL3 after that date.



Software Update Policy for ASMLib running on future releases of Red Hat Enterprise Linux
Red Hat Enterprise Linux 6 (RHEL6)
For RHEL6, Oracle will only provide ASMLib software and updates when configured with a kernel distributed by Oracle. Oracle will not provide ASMLib packages for kernels distributed by Red Hat as part of RHEL6. ASMLib updates will be delivered via Unbreakable Linux Network(ULN) which is available to customers with Oracle Linux support. ULN works with both Oracle Linux or Red Hat Linux installations, but ASMlib usage will require replacing any Red Hat kernel with a kernel provided by Oracle.
What do you need to do?
To ensure your ASMLib is supported by Oracle on your Red Hat Enterprise Linux supported by Red Hat, please update your RHEL and ASMLib software to the supported version.
Who to contact for more information?
You can get help in the following ways:

    If you have purchased Basic or Premier support, you can open a service request with Oracle support
    If you have purchased Network support, you may discuss technical issues on the OTN Linux forum or in MOS ASMlib commnunity.

回复 只看该作者 道具 举报

4#
发表于 2012-4-13 21:24:49
For RHEL6, Oracle will only provide ASMLib software and updates when configured with a kernel distributed by Oracle. Oracle will not provide ASMLib packages for kernels distributed by Red Hat as part of RHEL6. ASMLib updates will be delivered via Unbreakable Linux Network(ULN) which is available to customers with Oracle Linux support. ULN works with both Oracle Linux or Red Hat Linux installations, but ASMlib usage will require replacing any Red Hat kernel with a kernel provided by Oracle.
What do you need to do?
To ensure your ASMLib is supported by Oracle on your Red Hat Enterprise Linux supported by Red Hat, please update your RHEL and ASMLib software to the supported version.

回复 只看该作者 道具 举报

5#
发表于 2012-4-13 21:35:38
Some noise from free list

Did anyone else see the announcement from Oracle that they will not be
providing ASMlib for kernels distributed by RH as part of RHEL 6, only for Oracle
kernels?  See Metalink Note 1089399.1:

"For RHEL6, Oracle will only provide ASMLib software and updates when
configured with a kernel distributed by Oracle. Oracle will not provide ASMLib packages
for kernels distributed by Red Hat as part of RHEL6. ASMLib updates will be
delivered via Unbreakable Linux Network(ULN) which is available to customers
with Oracle Linux support. ULN works with both Oracle Linux or Red Hat Linux
installations, but ASMlib usage will require replacing any Red Hat kernel
with a
kernel provided by Oracle."

To me, this sounds like Oracle is forcing all ASM Linux sites to buy into
their support structure and drop RH support.  When we investigated the cost between
RH and Oracle Linux support, we found Oracle Linux to be more expensive than RH
(when comparing apples to apples).  For those on an already tight budget, this
is not going to sit well.

I had also heard that this may have something to do with RedHat's decision to
pre-bundle patches in the kernel, making it more difficult for Oracle to
provide Red Hat support (and take away customers from Red Hat support):

http://www.linuxinsider.com/rsstory/72012.html?wlc=1303298360

If that's the reason, it's going to backfire on RedHat as all those running
ASM on Linux will have to flip to Oracle Support just to be able to download
ASMlib updates.  They'll end up losing customers anyway.  The only other option is
for ASM customers to drop the use of ASM and lose all the great functionality it
provides.  Tough decisions ahead, I believe.

回复 只看该作者 道具 举报

6#
发表于 2012-4-19 23:32:16
谢谢Liu                       
最后还是用Redhat5.6,ASMlib

回复 只看该作者 道具 举报

7#
发表于 2012-4-20 10:50:47

回复 6# 的帖子

没有使用多路径软件吗?

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-11-15 12:17 , Processed in 0.049306 second(s), 22 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569