在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