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]



.  Automatic Storage Management (ASM) Concepts and Overview:


1ASM Concepts Quick Overview [ID 1086199.1]​​

2New Feature on ASM (Automatic Storage Manager). [ID 249992.1]​​


311g ASM New Feature [ID 429098.1]


4Oracle Database 11g Automatic Storage Management New Features Overview

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


5ASM - Scalability and Limits [ID 370921.1]​​


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


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


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


9Oracle ASM and Multi-Pathing Technologies

       下载地址​​



.  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​


其他文档:


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


2ASM 11gR1 Installation & Configuration


3ASM 11gR2 Installation & Configuration


4Upgrade ASM to 11.2


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


6ASM_Install_LINUX_Doc


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



.  Automatic Storage Management (ASM) Configuration:


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


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


3DBCA in Silent mode with ASM [ID 744237.1]


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


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


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


7How to Change ASM Home on a Node in RAC


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


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


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

11How To Create ASM Diskgroups using NFS/NAS Files

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

13How to Prepare Storage for ASM

​​​
14How to Re-configure Asm DiskGroup


.  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)​ 


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


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


 3ASM Fast Rebalance


4ASMCMD - ASM command line utility

 

5ASMCMD - New commands in 11gR1

    

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

7Create SPFILE Under ASM

​​

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

9Exact Steps To Migrate ASM Diskgroups To Another SAN Without Downtime
​​​​

10Extracting Datafile Blocks From ASM
​​​​
11How To Add a New Disk(s) to An Existing Diskgroup on RAC (Best Practices).


12How To Change ASM SYS PASSWORD


13How To Change The Asm Rebalancing Power After Starting The Rebalancing Process
​​​​

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

​​​​
15How to move a datafile from ASM to the file system
​​​​

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


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


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

19How To Create manually an ASM Instance From Scratch

20How To Create An SYSASM User On Release 11g


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


22How To Delete Archive Log Files Out Of +Asm

23How To Drop and Recreate ASM Diskgroup

24How to duplicate a controlfile when ASM is involved​​​​

25How to Increase CSS Misscount in single instance ASM installations​​​​
26How to map asm files with online database files
27How To Migrate ASMLIB devices to Block Devices (non-ASMLIB)​​​​

28How to move ASM database files from one diskgroup to another

29How to move ASM spfile to a different disk group


30How To Move Controlfile To ASM


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

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

33How to remove an ASM instance and its corresponding database(s) on WINDOWS
​​​​

34How To Remove An Empty ASM System Directory

​​​​

35How To Rename A Diskgroup On ASM 11gR2
​​​​

36How to rename ASM disks

​​

37How to rename ASM instances in RAC or clustered environment


38How to rename diskgroup in 10g ASM (Pre-11gR2 release)
​​​​

39How To Resize An ASM Disk On Release 10.2.0.

40Moving ASM spfile to a shared device in RAC

41OCSSD.BIN Process is Running in a Non-RAC Environment​​​​

42Pattern Matching Metacharacters For asm_diskstring​​​​
43Reconfigure HAS and CSS for nonRAC ASM on 11.2

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

45Steps to Re-Create ASM Diskgroups
​​​​

.  Automatic Storage Management (ASM) Migration and Upgrade:

1Pre-requsite for 11.2.0.1 to 11.2.0.2 ASM Rolling Upgrade


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

​​


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

​​


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

​​


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

​​


6Unable To Open Database After ASM Upgrade From Release 11.1 To Release 11.2

.  Automatic Storage Management (ASM) Versions and Patches:

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

​​


2Patch 8402551 Is Not Available




From Oracle

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

DBA1 群:62697716();   DBA2 群:62697977()   DBA3 群:62697850()  

DBA 超级群:63306533();  DBA4 群: 83829929  DBA5群: 142216823   

聊天 群:40132017   聊天2群:69087192

--加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请