Oracle 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:

 

1ASM Concepts Quick Overview [ID 1086199.1]

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

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

 

311g ASM New Feature [ID 429098.1]

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

 

4Oracle Database 11g Automatic Storage Management New Features Overview

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

 

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

 

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

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

 

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

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

 

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

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

 

9Oracle 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

 

其他文档:

 

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

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

 

2ASM 11gR1 Installation & Configuration

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

 

3ASM 11gR2 Installation & Configuration

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

 

4Upgrade ASM to 11.2

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

 

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

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

 

6ASM_Install_LINUX_Doc

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

 

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

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

 

 

.  Automatic Storage Management (ASM) Configuration:

 

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

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

 

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

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

 

3DBCA in Silent mode with ASM [ID 744237.1]

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

 

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

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

 

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

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

 

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

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

 

7How to Change ASM Home on a Node in RAC

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

 

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

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

 

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

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

 

10How 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

11How To Create ASM Diskgroups using NFS/NAS Files

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

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

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

 

13How to Prepare Storage for ASM

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

14How to Re-configure Asm DiskGroup

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

 

.  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

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

 

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

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

 

3ASM Fast Rebalance

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

 

4ASMCMD - ASM command line utility

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

 

5ASMCMD - New commands in 11gR1

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

 

6Can 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

7Create SPFILE Under ASM

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

8Database 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

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

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

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

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

 

12How To Change ASM SYS PASSWORD

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

      

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

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

http://blog.csdn.net/tianlesoftware/article/details/6342722

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

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

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

 

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

 

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

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

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

 

20How To Create An SYSASM User On Release 11g

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

 

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

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


22How To Delete Archive Log Files Out Of +Asm

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

23How To Drop and Recreate ASM Diskgroup

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

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

25How to Increase CSS Misscount in single instance ASM installations

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

26How to map asm files with online database files

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

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

 

29How to move ASM spfile to a different disk group

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


30How To Move Controlfile To ASM

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

 

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

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

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

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

34How To Remove An Empty ASM System Directory

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

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

36How to rename ASM disks

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

37How to rename ASM instances in RAC or clustered environment

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

 

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

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

 

40Moving ASM spfile to a shared device in RAC

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

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

42Pattern Matching Metacharacters For asm_diskstring
http://www.cndba.cn/Dave/article/789

43Reconfigure HAS and CSS for nonRAC ASM on 11.2
http://www.cndba.cn/Dave/article/788

 

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

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

 

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

.  Automatic Storage Management (ASM) Migration and Upgrade:

1Pre-requsite for 11.2.0.1 to 11.2.0.2 ASM Rolling Upgrade

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

 

2How 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

 

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

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

 

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

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

 

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

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

 

6Unable 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:

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

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

 

2Patch 8402551 Is Not Available

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

 

 

 

 

 

 

From Oracle

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

QQ:492913789

Email:ahdba@qq.com

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


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

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

聊天 群:40132017   聊天2群:69087192

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

  • 0
    点赞
  • 6
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值