在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:
(1)ASM Concepts Quick Overview [ID 1086199.1]
(2)New Feature on ASM (Automatic Storage Manager). [ID 249992.1]
(3)11g ASM New Feature [ID 429098.1]
(4)Oracle Database 11g Automatic Storage Management New Features Overview
这个是pdf 格式,下载地址
(5)ASM - Scalability and Limits [ID 370921.1]
(6)ASM 11g New Features - How ASM Disk Resync Works. [ID 466326.1]
(7)How does ASM work with RAID where striping and mirroring are already built-in [ID 330398.1]
(8)Can External Tables Be Placed inside ASM diskgroups [ID 470989.1]
(9)Oracle 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
其他文档:
(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]
四. 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]
(4)Deployment of very large databases (10TB to PB range) with Automatic Storage Management (ASM) [ID 368055.1]
(5)How do you setup / remove / modify Cluster Synchronization Services Daemon (CSSD) on a non-RAC system (init.cssd)?
(6)How To Automate ASM Startup and Shutdown on AIX 5L [ID 580133.1]
(7)How to Change ASM Home on a Node in RAC
(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
(14)How 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)
(1)How v$recovery_file_dest.space_used is calculated from v$asm_file.bytes in ASM
(2)ASM Fast Mirror Resync - Example To Simulate Transient Disk Failure And Restore Disk
(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).
(12)How To Change ASM SYS PASSWORD
(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
(16)How to copy a datafile from ASM to a file system not using RMAN
(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
(27)How To Migrate ASMLIB devices to Block Devices (non-ASMLIB)
(28)How to move ASM database files from one diskgroup to another
(29)How to move ASM spfile to a different disk group
(30)How To Move Controlfile To ASM
(31)How To Move The Database To Different Diskgroup (Change Diskgroup Redundancy)
(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
(34)How To Remove An Empty ASM System Directory
(35)How To Rename A Diskgroup On ASM 11gR2
(36)How to rename ASM disks
(37)How to rename ASM instances in RAC or clustered environment
(38)How to rename diskgroup in 10g ASM (Pre-11gR2 release)
(39)How To Resize An ASM Disk On Release 10.2.0.
(40)Moving ASM spfile to a shared device in RAC
(41)OCSSD.BIN Process is Running in a Non-RAC Environment
(42)Pattern Matching Metacharacters For asm_diskstring
(43)Reconfigure HAS and CSS for nonRAC ASM on 11.2
(44)Steps To Migrate-Move a Database From Non-ASM to ASM And Vice-Versa
(45)Steps to Re-Create ASM Diskgroups
六. Automatic Storage Management (ASM) Migration and Upgrade:
(1)Pre-requsite for 11.2.0.1 to 11.2.0.2 ASM Rolling Upgrade
(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
(4)How To Upgrade ASM from 10.2 to 11.1 (RAC)
(5)Upgrading ASM instance from Oracle 10.1 to Oracle 10.2. (Single Instance)
(6)Unable To Open Database After ASM Upgrade From Release 11.1 To Release 11.2
七. Automatic Storage Management (ASM) Versions and Patches:
(1)How to install a patch on clusterware 11.2.0.1 into grid infrastructure home
(2)Patch 8402551 Is Not Available
From Oracle
-------------------------------------------------------------------------------------------------------
DBA1 群:62697716(满); DBA2 群:62697977(满) DBA3 群:62697850(满)
DBA 超级群:63306533(满); DBA4 群: 83829929 DBA5群: 142216823
聊天 群:40132017 聊天2群:69087192
--加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请