首页 > 数据库 >Oracle ASM 系列 小结

Oracle ASM 系列 小结

时间:2023-07-25 16:32:33浏览次数:44  
标签:www cn How cndba Oracle article 小结 ASM


 

 

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

 

一.  Automatic Storage Management (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://www.cndba.cn/Dave/article/854

 

 

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

 

(1)ASM Concepts Quick Overview [ID 1086199.1]

http://www.cndba.cn/Dave/article/853

(2)New Feature on ASM (Automatic Storage Manager). [ID 249992.1]
http://www.cndba.cn/Dave/article/852

 

(3)11g ASM New Feature [ID 429098.1]

http://www.cndba.cn/Dave/article/851

 

(4)Oracle Database 11g Automatic Storage Management New Features Overview

这个是pdf 格式,下载地址:

 

(5)ASM - Scalability and Limits [ID 370921.1]
http://www.cndba.cn/Dave/article/850

 

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

http://www.cndba.cn/Dave/article/849

 

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

http://www.cndba.cn/Dave/article/848

 

(8)Can External Tables Be Placed inside ASM diskgroups [ID 470989.1]

http://www.cndba.cn/Dave/article/847

 

(9)Oracle ASM and Multi-Pathing Technologies

下载地址:

 

 

三.  Automatic Storage Management (ASM) Installation:

 

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

 

• 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)


 

(2)ASM 11gR1 Installation & Configuration


 

(3)ASM 11gR2 Installation & Configuration


 

(4)Upgrade ASM to 11.2


 

(5)Oracle 11g create groups and users for Grid and DB


 

(6)ASM_Install_LINUX_Doc


 

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

http://www.cndba.cn/Dave/article/846

 

 

四.  Automatic Storage Management (ASM) Configuration:

 

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


 

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


 

(3)DBCA in Silent mode with ASM [ID 744237.1]

http://www.cndba.cn/Dave/article/843

 

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

http://www.cndba.cn/Dave/article/842

 

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

http://www.cndba.cn/Dave/article/841

 

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

http://www.cndba.cn/Dave/article/840

 

(7)How to Change ASM Home on a Node in RAC

http://www.cndba.cn/Dave/article/839

 

(8)How to configure dbconsole to display information from the ASM DISKGROUPS [ID 329581.1]


 

(9)How to configure local_listener parameter with ASMCA [ID 1112993.1]


 

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


(11)How To Create ASM Diskgroups using NFS/NAS Files


(12)How To Determinate If An EMCPOWER Partition Is Valid For ASMLIB


 

(13)How to Prepare Storage for ASM

http://www.cndba.cn/dave/article/833

(14)How to Re-configure Asm DiskGroup

http://www.cndba.cn/dave/article/832

 

五.  Automatic Storage Management (ASM) Administration:

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://www.cndba.cn/dave/article/831

 

(2)ASM Fast Mirror Resync - Example To Simulate Transient Disk Failure And Restore Disk

http://www.cndba.cn/dave/article/830

 

(3)ASM Fast Rebalance


 

(4)ASMCMD - ASM command line utility


 

(5)ASMCMD - New commands in 11gR1


 

(6)Can you create a second voting disk in a different ASM diskgroup when using External Redundancy in 11.2

(7)Create SPFILE Under ASM


(8)Database Creation on 11.2 Grid Infracture with Role Separation ( ORA-15025, KFSG-00312, ORA-15081 )

(9)Exact Steps To Migrate ASM Diskgroups To Another SAN Without Downtime

(10)Extracting Datafile Blocks From ASM


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

http://www.cndba.cn/dave/article/821

 

(12)How To Change ASM SYS PASSWORD

http://www.cndba.cn/dave/article/820

      

(13)How To Change The Asm Rebalancing Power After Starting The Rebalancing Process

(14)How to move a datafile from a file system to ASM





(15)How to move a datafile from ASM to the file system
http://www.cndba.cn/Dave/article/817

(16)How to copy a datafile from ASM to a file system not using RMAN

http://www.cndba.cn/Dave/article/816

 

(17)How to Copy Archivelog Files From ASM to Filesystem and vice versa

 

(18)How to Copy asm files between remote ASM instances using ASMCMD command


(19)How To Create manually an ASM Instance From Scratch

 

(20)How To Create An SYSASM User On Release 11g


 

(21)How to Create Transportable Tablespaces Where the Source and Destination are ASM-Based


(22)How To Delete Archive Log Files Out Of +Asm


(23)How To Drop and Recreate ASM Diskgroup


(24)How to duplicate a controlfile when ASM is involved

(25)How to Increase CSS Misscount in single instance ASM installations


(26)How to map asm files with online database files

http://www.cndba.cn/Dave/article/806      
(27)How To Migrate ASMLIB devices to Block Devices (non-ASMLIB)
http://www.cndba.cn/Dave/article/805

(28)How to move ASM database files from one diskgroup to another
http://www.cndba.cn/Dave/article/804

 

(29)How to move ASM spfile to a different disk group


http://www.cndba.cn/Dave/article/803

(30)How To Move Controlfile To ASM


 

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

http://www.cndba.cn/Dave/article/801

(32)How to remove an ASM instance and its corresponding database(s) on UNIX

(33)How to remove an ASM instance and its corresponding database(s) on WINDOWS
http://www.cndba.cn/Dave/article/800

(34)How To Remove An Empty ASM System Directory

http://www.cndba.cn/Dave/article/798

(35)How To Rename A Diskgroup On ASM 11gR2
http://www.cndba.cn/Dave/article/797

(36)How to rename ASM disks

http://www.cndba.cn/Dave/article/796

(37)How to rename ASM instances in RAC or clustered environment

http://www.cndba.cn/Dave/article/795

 

(38)How to rename diskgroup in 10g ASM (Pre-11gR2 release)
http://www.cndba.cn/Dave/article/794

(39)How To Resize An ASM Disk On Release 10.2.0.X
http://www.cndba.cn/Dave/article/793

 

(40)Moving ASM spfile to a shared device in RAC

http://www.cndba.cn/Dave/article/791

(41)OCSSD.BIN Process is Running in a Non-RAC Environment
http://www.cndba.cn/Dave/article/790

(42)Pattern Matching Metacharacters For asm_diskstring
http://www.cndba.cn/Dave/article/789
(43)Reconfigure HAS and CSS for nonRAC ASM on 11.2
http://www.cndba.cn/Dave/article/788

 

(44)Steps To Migrate-Move a Database From Non-ASM to ASM And Vice-Versa

http://www.cndba.cn/Dave/article/787

 

(45)Steps to Re-Create ASM Diskgroups
http://www.cndba.cn/Dave/article/786

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

(1)Pre-requsite for 11.2.0.1 to 11.2.0.2 ASM Rolling Upgrade

http://www.cndba.cn/Dave/article/785

 

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


 

(3)How to perform Rolling Upgrade-Downgrade in 11g ASM

http://www.cndba.cn/Dave/article/783

 

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

http://www.cndba.cn/Dave/article/782

 

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

http://www.cndba.cn/Dave/article/781

 

(6)Unable To Open Database After ASM Upgrade From Release 11.1 To Release 11.2
http://www.cndba.cn/Dave/article/517

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

(1)How to install a patch on clusterware 11.2.0.1 into grid infrastructure home

http://www.cndba.cn/Dave/article/779

 

(2)Patch 8402551 Is Not Available

http://www.cndba.cn/Dave/article/778

 

 

 

 

 

 

From Oracle

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


Blog: http://www.cndba.cn/dave



标签:www,cn,How,cndba,Oracle,article,小结,ASM
From: https://blog.51cto.com/cndba/6846614

相关文章

  • How to Restore ASM Based OCR After Complete Loss of the CRS Diskgroup on Linux/U
    InthisDocumentGoalSolutionReferencesAPPLIESTO:OracleDatabase-EnterpriseEdition-Version11.2.0.1.0andlaterOracleDatabaseCloudSchemaService-VersionN/AandlaterGen1ExadataCloudatCustomer(OracleExadataDatabaseCloudMachine)......
  • Oracle数据类型与对应的PostgreSQL数据类型(oracle 19c 迁移到kingbase)
    Oracle数据类型与对应的PostgreSQL数据类型的映射:1.数值类型:-OracleNUMBER->PostgreSQLNUMERIC-OracleINTEGER->PostgreSQLINTEGER-OracleBINARY_FLOAT->PostgreSQLREAL-OracleBINARY_DOUBLE->PostgreSQLDOUBLEPRECISION2.字符串类型:-Or......
  • ORACLE PIVOT函数
      语法     函数用途: PIVOT函数被用于SELECT子句中,在查询时将行转换成列,并在由行转列时对对应数据进行聚合统计.一般使用PIVOT操作后结果集将比原结果集包含更多的列,以及更少的行。   计算步骤:      1.PIVOT函数计算位于PIVOT子句起始位置的聚合函数......
  • oracle数据库临时表空间损坏,报错ORA-01116,ORA-01110 ,ORA-27041,ORA-06512的解决方式
     打脚本的时候报错:ORA-01116:打开数据库文件203时出错ORA-01110:数据文件203:'/u01/app/oracle/oradata/temp02.dbf'ORA-27041:无法打开文件Linux-x86_64Error:2:NosuchfileordirectoryAdditionalinformation:3ORA-06512:在line9  是我们环境的临时表空间......
  • oracle imp增量导入
    oracleimp导入可以使用ignore=y参数进行增量导入如果不使用ignore=y 参数在进行imp导入时,就会对已经存在的表就不会进行导入(会报错并跳过),如果加上ignore=y参数,就会对已经存在的表中没有的记录进行更新,但对已经存在记录不会进行覆盖修改。......
  • 介绍了Oracle数据库锁的种类及研究
    介绍了Oracle数据库锁的种类及研究作者:佚名本文通过对Oracle数据库锁机制的研究,首先介绍了Oracle数据库锁的种类,并描述了实际应用中遇到的与锁相关的异常情况,特别对经常遇到的由于等待锁而使事务被挂起的问题进行了定位及解决,并对死锁这一比较严重的现象,提出了相应的......
  • ORACLE空间管理实验4:块管理之ASSM三级位图结构
    L1、L2、L3块的作用:--方便查找数据块。L3中有指向L2的指针,L2有指向L1的指针,L1中有多个数据块的指针和状态。1、每个L3中,有多个L2的地址(第一个L3是段头)。2、每个L2中,有多个L1的地址。3、每个L1中,有多个数据块地址。ORACLE最多支持三级位图。一级位图用于管理具体数据块的使用。......
  • ORACLE空间管理实验5:块管理之ASSM下高水位的影响--删除和查询
    高水位概念:所有的oracle段(segments,在此,为了理解方便,建议把segment作为表的一个同义词)都有一个在段内容纳数据的上限,我们把这个上限称为"highwatermark"或HWM。这个HWM是一个标记,用来说明已经有多少没有使用的数据块分配给这个segment。HWM原则上HWM只......
  • ORACLE空间管理实验2:区的管理与分配
    内容基于LMT管理的表空间,字典管理已经不用了。本篇主要验证了这些问题:1.LMT管理的表空间,区的分配有两种方法:系统分配和UNIFORM固定大小-->见实验   2.验证Oracle找寻可用区的方式:从数据文件开头的位图块中获得可用区的信息,DUMP时可见FIRST:3这种,表......
  • 深入解析Oracle IMU模式下的REDO格式
    1.什么是IMU?IMU的主要作用是什么,也就是说为了解决什么问题?IMU--->InMemoryUndo,10g新特性,数据库会在sharedpool开辟独立的内存区域用于存储Undo信息,每个新事务都会分配一个IMUbuffer(私有的),一个buffer里有很多node,一个node相当于一个block(回滚块)。IMU特性:IMU顾名思义就是在内......