`
helloyesyes
  • 浏览: 1303056 次
  • 性别: Icon_minigender_2
  • 来自: 武汉
文章分类
社区版块
存档分类
最新评论

Oracle ASM 系列 小结

Oracle.netBlogLinuxAIX 
阅读更多

在metalink上看到一篇有关ASM 总结的文章，贴出来，共同学习。

一. Automatic StorageManagement (ASM) Alerts:

Alert: Querying v$asm_file Gives ORA-15196 After ASM Was Upgraded From 10gR2 To 11gR2 with an AU size > 1M [ID 1145365.1]

http://blog.csdn.net/tianlesoftware/archive/2011/04/05/6302817.aspx

二. Automatic Storage Management (ASM) Concepts and Overview:

（1）ASM Concepts Quick Overview [ID 1086199.1]

http://blog.csdn.net/tianlesoftware/archive/2011/04/05/6303008.aspx

（2）New Feature on ASM (Automatic Storage Manager). [ID 249992.1]
http://blog.csdn.net/tianlesoftware/archive/2011/04/05/6303130.aspx

（3）11g ASM New Feature [ID 429098.1]

http://blog.csdn.net/tianlesoftware/archive/2011/04/05/6303563.aspx

（4）Oracle Database 11g Automatic Storage Management New Features Overview

这个是pdf 格式，下载地址：http://download.csdn.net/source/3191090

（5）ASM - Scalability and Limits [ID 370921.1]
http://blog.csdn.net/tianlesoftware/archive/2011/04/19/6333009.aspx

（6）ASM 11g New Features - How ASM Disk Resync Works. [ID 466326.1]

http://blog.csdn.net/tianlesoftware/archive/2011/04/19/6333533.aspx

（7）How does ASM work with RAID where striping and mirroring are already built-in [ID 330398.1]

http://blog.csdn.net/tianlesoftware/archive/2011/04/19/6333626.aspx

（8）Can External Tables Be Placed inside ASM diskgroups [ID 470989.1]

http://blog.csdn.net/tianlesoftware/archive/2011/04/19/6333755.aspx

（9）Oracle ASM and Multi-Pathing Technologies

下载地址：http://download.csdn.net/source/3206079

三. Automatic Storage Management (ASM) Installation:

这里只看下Linux 平台下的安装说明：

•Oracle® Database Installation Guide 10g Release 2 (10.2) for Linux x86-64:1.5.1.2 Automatic Storage Management
•Oracle® Database Installation Guide 11g Release 1 (11.1) for Linux:3.6 Installing Automatic Storage Management
•Oracle® Database Installation Guide 11g Release 2 (11.2) for Linux:3.5 Automatic Storage Management Installation Considerations

其他文档：

（1）ASM 11gR2 Grid Infrastructure Deinstallation(CSS+OHAS+ASM)

http://download.csdn.net/source/3207040

（2）ASM 11gR1 Installation & Configuration

http://download.csdn.net/source/3207095

（3）ASM 11gR2 Installation & Configuration

http://download.csdn.net/source/3207158

（4）Upgrade ASM to 11.2

http://download.csdn.net/source/3207238

（5）Oracle 11g create groups and users for Grid and DB

http://download.csdn.net/source/3207253

（6）ASM_Install_LINUX_Doc

http://download.csdn.net/source/3208327

（7）How to cleanup ASM installation (RAC and Non-RAC) [ID 311350.1]

http://blog.csdn.net/tianlesoftware/archive/2011/04/20/6335841.aspx

四. Automatic Storage Management (ASM) Configuration:

（1）How To Create An ASM Diskgroup Using XML code Thru ASMCMD [ID 1290550.1]

http://blog.csdn.net/tianlesoftware/archive/2011/04/20/6335938.aspx

（2）ASM Using OS Files Instead of Real Raw Devices On Windows. [ID 602620.1]

http://blog.csdn.net/tianlesoftware/archive/2011/04/20/6336076.aspx

（3）DBCA in Silent mode with ASM [ID 744237.1]

http://blog.csdn.net/tianlesoftware/archive/2011/04/20/6336248.aspx

（4）Deployment of very large databases (10TB to PB range) with Automatic Storage Management (ASM) [ID 368055.1]

http://blog.csdn.net/tianlesoftware/archive/2011/04/20/6336335.aspx

（5）How do you setup / remove / modify Cluster Synchronization Services Daemon (CSSD) on a non-RAC system (init.cssd)?

http://blog.csdn.net/tianlesoftware/archive/2011/04/20/6336511.aspx

（6）How To Automate ASM Startup and Shutdown on AIX 5L [ID 580133.1]

http://blog.csdn.net/tianlesoftware/archive/2011/04/20/6336569.aspx

（7）How to Change ASM Home on a Node in RAC

http://blog.csdn.net/tianlesoftware/archive/2011/04/20/6337082.aspx

（8）How to configure dbconsole to display information from the ASM DISKGROUPS [ID 329581.1]

http://blog.csdn.net/tianlesoftware/archive/2011/04/20/6337133.aspx

（9）How to configure local_listener parameter with ASMCA [ID 1112993.1]

http://blog.csdn.net/tianlesoftware/archive/2011/04/20/6337213.aspx

（10）How to configure XDB for using ftp and http protocols with ASM [ID 357714.1]

http://blog.csdn.net/tianlesoftware/archive/2011/04/20/6337281.aspx

（11）How To Create ASM Diskgroups using NFS/NAS Files

http://blog.csdn.net/tianlesoftware/archive/2011/04/21/6337682.aspx

（12）How To Determinate If An EMCPOWER Partition Is Valid For ASMLIB

http://blog.csdn.net/tianlesoftware/archive/2011/04/21/6337697.aspx

（13）How to Prepare Storage for ASM

http://blog.csdn.net/tianlesoftware/archive/2011/04/21/6337882.aspx

（14）How to Re-configure Asm DiskGroup

http://blog.csdn.net/tianlesoftware/archive/2011/04/21/6338054.aspx

五. Automatic Storage Management (ASM) Administration:

•Oracle® Database Administrator's Guide 10g Release 2 (10.2): 12 Using Automatic Storage Management
•Oracle® Database Storage Administrator's Guide 11g Release 1 (11.1)
•Oracle® Database Storage Administrator's Guide 11g Release 2 (11.2)


（1）How v$recovery_file_dest.space_used is calculated from v$asm_file.bytes in ASM

http://blog.csdn.net/tianlesoftware/archive/2011/04/21/6339075.aspx

（2）ASM Fast Mirror Resync - Example To Simulate Transient Disk Failure And Restore Disk

http://blog.csdn.net/tianlesoftware/archive/2011/04/21/6339958.aspx

（3）ASM Fast Rebalance

http://blog.csdn.net/tianlesoftware/archive/2011/04/21/6340006.aspx

（4）ASMCMD - ASM command line utility

http://blog.csdn.net/tianlesoftware/archive/2011/04/22/6340800.aspx

（5）ASMCMD - New commands in 11gR1

http://blog.csdn.net/tianlesoftware/archive/2011/04/22/6340876.aspx

（6）Can you create a second voting disk in a different ASM diskgroup when using External Redundancy in 11.2
http://blog.csdn.net/tianlesoftware/archive/2011/04/22/6341110.aspx

（7）Create SPFILE Under ASM

http://blog.csdn.net/tianlesoftware/archive/2011/04/22/6341704.aspx

（8）Database Creation on 11.2 Grid Infracture with Role Separation ( ORA-15025, KFSG-00312, ORA-15081 )
http://blog.csdn.net/tianlesoftware/archive/2011/04/22/6341861.aspx

（9）Exact Steps To Migrate ASM Diskgroups To Another SAN Without Downtime
http://blog.csdn.net/tianlesoftware/archive/2011/04/22/6341946.aspx

（10）Extracting Datafile Blocks From ASM
http://blog.csdn.net/tianlesoftware/archive/2011/04/22/6342060.aspx

（11）How To Add a New Disk(s) to An Existing Diskgroup on RAC (Best Practices).

http://blog.csdn.net/tianlesoftware/archive/2011/04/22/6342102.aspx

（12）How To Change ASM SYS PASSWORD

http://blog.csdn.net/tianlesoftware/archive/2011/04/22/6342224.aspx

（13）How To Change The Asm Rebalancing Power After Starting The Rebalancing Process
http://blog.csdn.net/tianlesoftware/archive/2011/04/22/6342285.aspx

（14）How to move a datafile from a file system to ASM

http://blog.csdn.net/tianlesoftware/archive/2011/04/22/6342722.aspx

（15）How to move a datafile from ASM to the file system
http://blog.csdn.net/tianlesoftware/archive/2011/04/22/6342740.aspx

（16）How to copy a datafile from ASM to a file system not using RMAN

http://blog.csdn.net/tianlesoftware/archive/2011/04/22/6342763.aspx

（17）How to Copy Archivelog Files From ASM to Filesystem and vice versa
http://blog.csdn.net/tianlesoftware/archive/2011/04/22/6342794.aspx

（18）How to Copy asm files between remote ASM instances using ASMCMD command

http://blog.csdn.net/tianlesoftware/archive/2011/04/22/6342875.aspx

（19）How To Create manually an ASM Instance From Scratch
http://blog.csdn.net/tianlesoftware/archive/2011/04/23/6344686.aspx

（20）How To Create An SYSASM User On Release 11g

http://blog.csdn.net/tianlesoftware/archive/2011/04/23/6344924.aspx

（21）How to Create Transportable Tablespaces Where the Source and Destination are ASM-Based

http://blog.csdn.net/tianlesoftware/archive/2011/04/23/6346300.aspx


（22）How To Delete Archive Log Files Out Of +Asm

http://blog.csdn.net/tianlesoftware/archive/2011/04/23/6346361.aspx

（23）How To Drop and Recreate ASM Diskgroup

http://blog.csdn.net/tianlesoftware/archive/2011/04/23/6346977.aspx

（24）How to duplicate a controlfile when ASM is involved
http://blog.csdn.net/tianlesoftware/archive/2011/04/23/6347031.aspx

（25）How to Increase CSS Misscount in single instance ASM installations

http://blog.csdn.net/tianlesoftware/archive/2011/04/23/6347122.aspx

（26）How to map asm files with online database files

http://blog.csdn.net/tianlesoftware/archive/2011/04/23/6347387.aspx

（27）How To Migrate ASMLIB devices to Block Devices (non-ASMLIB)
http://blog.csdn.net/tianlesoftware/archive/2011/04/23/6347412.aspx

（28）How to move ASM database files from one diskgroup to another
http://blog.csdn.net/tianlesoftware/archive/2011/04/23/6347442.aspx

（29）How to move ASM spfile to a different disk group

http://blog.csdn.net/tianlesoftware/archive/2011/04/23/6347461.aspx


（30）How To Move Controlfile To ASM

http://blog.csdn.net/tianlesoftware/archive/2011/04/23/6347521.aspx

（31）How To Move The Database To Different Diskgroup (Change Diskgroup Redundancy)

http://blog.csdn.net/tianlesoftware/archive/2011/04/24/6358961.aspx

（32）How to remove an ASM instance and its corresponding database(s) on UNIX
http://blog.csdn.net/tianlesoftware/archive/2011/04/24/6359095.aspx

（33）How to remove an ASM instance and its corresponding database(s) on WINDOWS
http://blog.csdn.net/tianlesoftware/archive/2011/04/24/6359091.aspx

（34）How To Remove An Empty ASM System Directory

http://blog.csdn.net/tianlesoftware/archive/2011/04/24/6359106.aspx

（35）How To Rename A Diskgroup On ASM 11gR2
http://blog.csdn.net/tianlesoftware/archive/2011/04/24/6359161.aspx

（36）How to rename ASM disks

http://blog.csdn.net/tianlesoftware/archive/2011/04/24/6359182.aspx

（37）How to rename ASM instances in RAC or clustered environment

http://blog.csdn.net/tianlesoftware/archive/2011/04/24/6359415.aspx

（38）How to rename diskgroup in 10g ASM (Pre-11gR2 release)
http://blog.csdn.net/tianlesoftware/archive/2011/04/24/6359460.aspx

（39）How To Resize An ASM Disk On Release 10.2.0.X
http://blog.csdn.net/tianlesoftware/archive/2011/04/25/6360747.aspx

（40）Moving ASM spfile to a shared device in RAC

http://blog.csdn.net/tianlesoftware/archive/2011/04/25/6360929.aspx

（41）OCSSD.BIN Process is Running in a Non-RAC Environment
http://blog.csdn.net/tianlesoftware/archive/2011/04/25/6360975.aspx

（42）Pattern Matching Metacharacters For asm_diskstring
http://blog.csdn.net/tianlesoftware/archive/2011/04/25/6360998.aspx

（43）Reconfigure HAS and CSS for nonRAC ASM on 11.2
http://blog.csdn.net/tianlesoftware/archive/2011/04/25/6361082.aspx

（44）Steps To Migrate-Move a Database From Non-ASM to ASM And Vice-Versa

http://blog.csdn.net/tianlesoftware/archive/2011/04/25/6361664.aspx

（45）Steps to Re-Create ASM Diskgroups
http://blog.csdn.net/tianlesoftware/archive/2011/04/25/6361701.aspx

六. Automatic Storage Management (ASM) Migration and Upgrade:

（1）Pre-requsite for 11.2.0.1 to 11.2.0.2 ASM Rolling Upgrade

http://blog.csdn.net/tianlesoftware/archive/2011/04/25/6361921.aspx

（2）How To Upgrade ASM from 10.2 to 11.1 (single Instance configuration -Non-RAC)

http://blog.csdn.net/tianlesoftware/archive/2011/04/25/6361959.aspx

（3）How to perform Rolling Upgrade-Downgrade in 11g ASM

http://blog.csdn.net/tianlesoftware/archive/2011/04/25/6362009.aspx

（4）How To Upgrade ASM from 10.2 to 11.1 (RAC)

http://blog.csdn.net/tianlesoftware/archive/2011/04/25/6362083.aspx

（5）Upgrading ASM instance from Oracle 10.1 to Oracle 10.2. (Single Instance)

http://blog.csdn.net/tianlesoftware/archive/2011/04/25/6362160.aspx

（6）Unable To Open Database After ASM Upgrade From Release 11.1 To Release 11.2
http://blog.csdn.net/tianlesoftware/archive/2011/04/25/6362184.aspx


七. Automatic Storage Management (ASM)Versions and Patches:

（1）How to install a patch on clusterware 11.2.0.1 into grid infrastructure home

http://blog.csdn.net/tianlesoftware/archive/2011/04/26/6363320.aspx

（2）Patch 8402551 Is Not Available

http://blog.csdn.net/tianlesoftware/archive/2011/04/26/6363341.aspx

From Oracle

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

Blog： http://blog.csdn.net/tianlesoftware

Email: dvd.dba@gmail.com

DBA1 群：62697716(满); DBA2 群：62697977(满) DBA3

分享到：
| 淘宝架构资料收集
评论
发表评论

您还没有登录,请您登录后再发表评论

相关推荐

    OracleASM常用知识小结

    ### Oracle ASM 常用知识小结 #### 一、ASM 概述 **ASM (Automatic Storage Management)** 是 Oracle 10g 引入的一种新型的存储管理技术，旨在为数据库提供高性能、高可用性以及易管理性的存储解决方案。通过 ASM...

    Oracle ASM 常用知识小结 共18页.pdf

    Oracle ASM，全称为Automatic Storage Management，是Oracle数据库提供的一种集成化的存储管理解决方案。它将传统的文件系统与存储管理功能结合在一起，为Oracle数据库提供高效、可靠的磁盘管理和数据存储服务。以下...

    Oracle ASM 常用知识小结

    Oracle ASM 常用知识小结 !!!!!!!

    Oracle数据库管理知识 Oracle ASM 常用知识小结总结 共18页.pptx

    Oracle ASM，全称为Automatic Storage Management，是Oracle数据库中一种先进的存储管理系统，用于高效地管理和组织数据库文件。ASM提供了自动化的磁盘管理和故障恢复功能，简化了数据库管理员的日常工作。以下是对...

    ASM命令查询

    小结 `V$ASM_DISK`和`V$ASM_DISKGROUP`是Oracle数据库中非常重要的两个视图，它们提供了丰富的信息，帮助DBA有效地管理和监控ASM环境。通过定期查询这两个视图，可以确保ASM环境的健康运行，同时也能在出现问题时...

    Oracle11G RAC 卸载

    #### 小结 通过上述方法，可以快速地将 Oracle RAC 数据库回退到安装集群软件之前的状态，从而便于重新部署。这种方法虽然有效，但必须谨慎使用。特别是对于生产环境或重要的开发和测试环境，应当避免采用此类...

    构建最高可用Oracle数据库系统 Oracle 11gR2 RAC管理、维护与性能优化

    目录 推荐序 前言 第1章 认识Oracle RAC 1.1 RAC产生的背景 1.2 RAC体系结构 1.2.1整体结构 1.2.2物理层次结构 1.2.3逻辑层次结构 1.3 RAC的特点 ...1.6本章小结 ...2.6创建ASM磁盘 ...15.5本章小结

    Oracle数据库体系结构小结[定义].pdf

    - 存储能力虚拟化：Oracle自动存储管理（ASM）创建了虚拟存储层，使多个磁盘可作为单一磁盘组使用，同时支持在线的磁盘添加和移除。 - 网格管理：Oracle企业管理器10g的网格控制提供了统一的管理系统，便于资源...

    oracle10g课堂练习I（1）

    小结 1-24 2 安装 Oracle 数据库软件 课程目标 2-2 Oracle 数据库管理员的任务 2-3 用于管理 Oracle 数据库的工具 2-4 安装：系统要求 2-6 检查系统要求 2-7 灵活体系结构 (OFA) 2-8 使用灵活体系结构 2-9...

    安装oracle数据库的环境变量设置

    #### 五、小结 正确设置Oracle数据库的环境变量对于确保其正常运行至关重要。通过上述介绍，我们可以看到每个环境变量都有其特定的功能和用途。希望本文能够帮助您更好地理解和掌握Oracle数据库的环境变量设置。

    oracle 053考前必看

    **小结：** Data Recovery Advisor是一款强大的工具，主要用于帮助DBA在遇到数据丢失或损坏的情况下进行故障诊断和恢复指导。对于上述两种情况而言，使用Data Recovery Advisor能够有效地定位问题并提供针对性的解决...

    ORACLE --RAC 集群的启动和关闭【20180625】

    #### 七、小结 通过上述步骤，我们可以有效地启动和关闭Oracle RAC集群。需要注意的是，在实际操作中，应当仔细监控每个步骤的状态，并确保按照正确的顺序执行这些步骤，以免出现意外情况。此外，`srvctl`命令的强大...

    oracle10g on linux and IBM.pdf

    #### 小结 通过本报告中提供的测试结果和性能调优建议，用户可以更好地理解 Oracle RAC 10g 在 IBM N 系列存储设备上使用 Linux 操作系统的性能特点。特别是对于那些正在考虑部署此类系统的 IT 专业人士而言，这份...

    Oracle11g RAC开启关闭、设置归档小结

    [oracle@oeltan1 ~]$ srvctl start asm -n node_name ``` 3. 最后，启动数据库实例： ``` [oracle@oeltan1 ~]$ srvctl start database -d tantest ``` **设置Oracle 11g RAC归档日志** 归档日志是数据库运行...

    ORACLE 11.2.0.4 RAC for CENTOS 7.0安装部署

    #### 小结 在部署 Oracle 11g RAC 集群之前，需要进行详尽的规划与准备工作。这包括但不限于操作系统的选择与安装、网络配置、用户及权限设置、存储配置等。通过上述步骤，可以确保 Oracle RAC 集群在 CentOS 7.0 ...

    oracle10g课堂练习I（2）

    小结 1-24 2 安装 Oracle 数据库软件 课程目标 2-2 Oracle 数据库管理员的任务 2-3 用于管理 Oracle 数据库的工具 2-4 安装：系统要求 2-6 检查系统要求 2-7 灵活体系结构 (OFA) 2-8 使用灵活体系结构 2-9...

Magicbox
Global site tag (gtag.js) - Google Analytics