![](https://img-blog.csdnimg.cn/20201014180756925.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle ASM
小宝老豆
这个作者很懒,什么都没留下…
展开
-
Oracle ASM 系列 小结
在metalink上看到一篇有关ASM 总结的文章,贴出来,共同学习。 一. Automatic Storage Management (ASM) Alerts: Alert: Querying v$asm_file Gives ORA-15196 Af转载 2011-09-26 15:01:55 · 988 阅读 · 0 评论 -
Steps to Re-Create ASM Diskgroups
In the event you cannot mount your ASM disk groups, you will be unable to start any databases using those disk groups. Here is a possible error reported when mounting ASM disk groups:SQL> startu原创 2011-09-29 10:25:44 · 646 阅读 · 0 评论 -
How to perform Rolling Upgrade-Downgrade in 11g ASM
The purpose of this document is to provide information about the ASM rolling upgrade feature and Step by Step to install a patchset or patch in ASM Home without downtime.SolutionThe following原创 2011-09-29 10:02:31 · 668 阅读 · 0 评论 -
如何 搭建 RMAN 备份平台
一. RMAN 的一些理论知识 RMAN Catalog 和 Nocatalog 的区别http://blog.csdn.net/xujinyang/article/details/6838066 RMAN 系列(一)---- RMAN 体系结构概述http://blog.csdn.net/xujinyang/article/details/6829转载 2011-09-26 17:04:49 · 616 阅读 · 0 评论 -
ASM 实例 ORA-15063 ORA-15186 ASMLIB error function = [asm_open], error = [1], mesg = [Operation not pe
装RAC时,用DBCA命令创建了ASM 实例,之后创建diskgroup的时候,有一个节点的diskgroup 挂不上,看了下日志,错误如下: ORA-15186: ASMLIB error function = [asm_open], error = [1], mesg = [Operation not permitted] ORA-15063: ASM discove转载 2011-09-29 10:41:31 · 837 阅读 · 0 评论 -
Oracle Database 11gR1 和 10gR2 ASM Best Practices 说明文档
在Metalink上找到了一个Oracle Database 11gR1 和 10gR2 ASM Best Practices 的说明文档,一共是40页,花点时间,看了一下,主要讲的还是一些ASM的基础知识。 不过了解这些对理解ASM 是很有必要的。 把这个文档上传到了CSDN 的download上,大家可以免费下载。 只要注册一个帐号就ok了。 我上传的所有资源都原创 2011-09-29 10:38:29 · 522 阅读 · 0 评论 -
Upgrading ASM instance from Oracle 10.1 to Oracle 10.2. (Single Instance)
Upgrading ASM instance from Oracle 10.1 to Oracle 10.2. (Single Instance)Solution o Upgrading of ASM instance from 10.1 to 10.2 can be accomplished through DBUA. o All the database that原创 2011-09-29 10:01:03 · 597 阅读 · 0 评论 -
How to install a patch on clusterware 11.2.0.1 into grid infrastructure home
When applying a needed patch to the Grid Infrastructure Home for ASM or CRS the opatch utility may error out with the messages: ApplySession failed: ApplySession failed to prepare the system. Appl原创 2011-09-29 09:58:51 · 1034 阅读 · 0 评论 -
RAC 修改 ASM实例名 的步骤
在DBCA 创建ASM实例时,会生成几个ASM实例,如+ASM1和+ASM2。 一般来说,安装好之后,是不需要修改ASM实例名的,但是一些特殊情况,还是需要修改的,就像我之前说的: RAC 中 ASM 实例名 与 节点的对应关系 http://blog.csdn.net/xujinyang/article/details/6833349 这个名转载 2011-09-29 10:40:25 · 1981 阅读 · 0 评论 -
Oracle RAC ASM 实例 从10.2.0.1 升级到 10.2.0.4 说明
一. 说明 在官网看到一篇ASM 升级的文档,如下: How To Upgrade ASM from 10.2 to 11.1 (RAC) http://blog.csdn.net/xujinyang/article/details/6832813 Unable To Open Database After ASM Upgrade Fr转载 2011-09-29 09:57:03 · 891 阅读 · 0 评论 -
Steps To Migrate-Move a Database From Non-ASM to ASM And Vice-Versa
This article describes the steps to migrate a database from Non-ASM to ASM and vice-versa. To setup ASM, please followNote 452924.1 - How to Prepare Storage for ASMNote 265633.1 - ASM Technica原创 2011-09-29 10:26:23 · 532 阅读 · 0 评论 -
How to Convert a Single-Instance ASM to Cluster ASM [ID 452758.1]
Applies to:Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.1.0.6Information in this document applies to any platform.GoalThis document describes the procedures for convertin原创 2011-09-29 11:27:25 · 721 阅读 · 0 评论 -
Oracle RAC ASM disk header 备份 恢复 与 重建 示例说明
一. 准备知识 RAC ASM由于其高度的封装性,使得我们很难知道窥探其内部的原理。ASM如果一旦出现问题,通常都很难处理。即便在有很完备的RMAN备份的情况下,恢复起来都可能需要很长的时间。 而ASM 中最为脆弱的又是ASM disk header。如果disk header逻辑损坏了,即corrupt了,整个disk group将不能够mount,依转载 2011-09-26 16:18:18 · 1372 阅读 · 0 评论 -
Oracle ASM 详解
ASM:Automatic Storage Management, 是Oracle 主推的一种面向Oracle的存储解决方案, ASM 和 RDBMS 非常相似,ASM 也是由实例和文件组成, 也可以通过sqlplus 工具来维护。 ASM 实例的创建和删除也可以用DBCA 这个命令来操作。在dbca 的第一个界面选择配置自动存储管理就可以了。 ASM 实例需要CSS 进程, 如果是非转载 2011-09-30 13:50:54 · 1038 阅读 · 0 评论 -
Moving ASM spfile to a shared device in RAC
If using pfile, it must be a filesystem file on local filesystem.If using spfile, then it can be in the following locations.-- a filesystem file spfile on local filesystem-- spfile on shared dev原创 2011-09-29 10:30:45 · 609 阅读 · 0 评论 -
Reconfigure HAS and CSS for nonRAC ASM on 11.2
This document provides a procedure to configure/reconfigure the ( High Availability Service ) HAS and CSS resource on Oracle Grid Infrastructure for nonRAC setup Solution 1) When you insta原创 2011-09-29 10:28:17 · 521 阅读 · 0 评论 -
How To Upgrade ASM from 10.2 to 11.1 (single Instance configuration -Non-RAC)
The present document explains how to upgrade an ASM instance from 10.2 to 11.1 release (single Instance configuration / Non-RAC).Solution1) Install the new 11g ASM Oracle Home (on a different原创 2011-09-29 10:03:12 · 584 阅读 · 0 评论 -
How To Upgrade ASM from 10.2 to 11.1 (RAC)
The present document explains how to upgrade an ASM instance from 10.2 to 11.1 release (on RAC).Solution1) Shutdown all the database instances that are using ASM as storage option. 2) Shut原创 2011-09-29 10:01:38 · 750 阅读 · 0 评论 -
Unable To Open Database After ASM Upgrade From Release 11.1 To Release 11.2
After upgrade the ASM instance from release 11.1 to release 11.2 existing database is unable to start/open due to the next error:/u01/app/oracle/product/11.1.0/dbs>sqlplusSQL*Plus: Release 1原创 2011-09-29 09:59:37 · 624 阅读 · 0 评论 -
Oracle ASM 相关的 视图(V$) 和 数据字典(X$)
ASM由于其高度的封装性,使得我们很难知道窥探其内部的原理。可以通过一下视图和数据字典来来查看ASM 的信息。 一. 相关视图和数据字典 View NameX$ Table nameDescriptionV$ASM_DISKGROUPX$KFGRPpe原创 2011-09-26 16:42:57 · 1367 阅读 · 0 评论 -
Oracle 使用BBED 查看 ASM Disk Header 内容
RAC ASM由于其高度的封装性,使得我们很难知道窥探其内部的原理。ASM如果一旦出现问题,通常都很难处理。即便在有很完备的RMAN备份的情况下,恢复起来都可能需要很长的时间。 而ASM 中最为脆弱的又是ASM disk header。如果disk header逻辑损坏了,即corrupt了,整个disk group将不能够mount,依赖于ASM实例的database也将不能转载 2011-09-26 16:39:38 · 848 阅读 · 0 评论 -
How to configure XDB for using ftp and http protocols with ASM [ID 357714.1]
Configuration of XDB(XML Database) to be able to use ftp and http protocols to browse and manage ASM directories Xdb configuration enable the possibility to use FTP from an ftp session原创 2011-11-12 16:17:58 · 1003 阅读 · 0 评论