David Dai -- Focus on Oracle

<br /> <br />Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.4<br /> <br />       This article will show how to display in dbconsole, information for the ASM instance used by the database.  This is particularly usefull if:<br />（1）.      T

External Tables cannot be created inside ASM diskgroup.       1 ) ASM cannot store external tables in ASM diskgroups since external tables are flat ASCII files which are not a file type supported in ASM, therefore external tables must be allocated on regul

ASM Concepts Quick Overview [ID 1086199.1]Modified 26-AUG-2010     Type BULLETIN     Status PUBLISHEDIn this Document  Purpose  Scope and Application  ASM Concepts Quick Overview  ReferencesApplies to: Oracle Server - Enterprise Edition - Version: 10.1.0.2

<br />Alert: Querying v$asm_file Gives ORA-15196 After ASM Was Upgraded From 10gR2 To 11gR2 with an AU size > 1M [ID 1145365.1]<br /> <br />Modified 29-SEP-2010     Type ALERT     Status PUBLISHED<br /> <br />In this Document<br />  Description<br />  Like

在Metalink上找到了一个Oracle Database 11gR1 和 10gR2 ASM Best Practices 的说明文档，一共是40页，花点时间，看了一下，主要讲的还是一些ASM的基础知识。不过了解这些对理解ASM 是很有必要的。       把这个文档上传到了CSDN 的download上，大家可以免费下载。只要注册一个帐号就ok了。我上传的所有资源都是0分资源。       下载地址：              ASM_11gR1_BestPractices_v34

<br /> <br />11g ASM New Feature [ID 429098.1]<br /> <br />Modified 23-AUG-2007     Type BULLETIN     Status PUBLISHED<br /> <br />In this Document<br />  Purpose<br />  Scope and Application<br />  11g ASM New Feature<br />     1.New SYSASM Role for Autom

New Feature on ASM (Automatic Storage Manager). [ID 249992.1]Modified 03-DEC-2009     Type BULLETIN     Status ARCHIVEDPURPOSE-------               Automatic Storage Management is a file system and volume manager built into the database kernel that allows

一. 准备知识       RAC ASM由于其高度的封装性，使得我们很难知道窥探其内部的原理。ASM如果一旦出现问题，通常都很难处理。即便在有很完备的RMAN备份的情况下，恢复起来都可能需要很长的时间。       而ASM 中最为脆弱的又是ASM disk header。如果

RAC ASM由于其高度的封装性，使得我们很难知道窥探其内部的原理。ASM如果一旦出现问题，通常都很难处理。即便在有很完备的RMAN备份的情况下，恢复起来都可能需要很长的时间。       而ASM 中最为脆弱的又是ASM disk header。如果disk header逻辑损

<br /> <br /> <br /><br />ASM - Scalability and Limits [ID 370921.1]<br /> <br />ASM imposes the following limits:<br /><br />（1）63 disk groups in a storage system<br />（2）10,000 ASM disks in a storage system<br />（3）2 terabyte maximum storage for each ASM

<br /> <br />一. ASM Fast Disk Resync Overview<br />    1) When we take a disk offline in case the disk is corrupted or database is not able to read or write from the disk. In case of Oracle database 10g, oracle engine use to balance the other disks with th

<br /> <br />       There is really no single answer to this question since it depends on business requirement and budget (cost, availability, performance & utilization). The followings are some trade offs that needs to be considered to compare hardware mi

<br /> <br />How to Change ASM Home on a Node in RAC <br /> <br />步骤如下：<br />1）Install a new Home to be used by ASM<br /> <br />2） Stop the listener, database, asm on the node<br /> <br />3）Listener is recommended to be run from asm home. We can reset the

<br /> <br />       Oracle recommends that you configure your system to automatically to start Oracle ASM instances and Database Instances when the system starts up, and to automatically shut them down when the system shuts down. Automating ASM/Database st

<br /> <br /> <br />How do you setup / remove / modify Cluster Synchronization Services Daemon (CSSD) on a non-RAC system (init.cssd)?<br /><br /><br /><br />Each of the LOCALCONFIG operations need to be run as ROOT<br />$ORACLE_HOME refers to the home use

<br /> <br />       To use  DBCA in silent mode and you want the database stored in the ASM +DGDATA diskgroup follow the next Correct Format for Examples:<br /><br />       If I already have an ASM instance/diskgroup then the following creates a single dat

<br /> <br />PURPOSE<br />-------<br />Support efficient deployment of very large databases (10TB to PB range) with Automatic Storage Management (ASM) in Oracle Database 10g.<br /> <br /> <br />SCOPE & APPLICATION<br />-------------------<br />This procedu

<br /> <br />The outline of the steps involved are :<br />       a)  Backup all the ASM client database files stored on the diskgroups.<br />       b)  Dropping all the diskgroups.<br />       c)  Removing ASM resource from CRS (* RAC specific)<br />

<br /> <br /> <br />Oracle Server - Enterprise Edition Version: 11.2.0.1 to 11.2.0.2 - Release: 11.2 to 11.2<br /> <br />步骤如下：<br /> <br />1)  Create a XML file (e.g. diskgroup.xml) with the next code:<br /><br /><br /><dg name="datadg" redundancy="normal"

<br /> <br />Windows 平台下，使用OS files 代替raw devices，步骤如下：<br /> <br />1)    If the ASM instance was not created, then create an ASM instance thru the DBCA .<br />2)  Update the initialization parameter file with the next hidden parameter:<br />Connected to:

ASM由于其高度的封装性，使得我们很难知道窥探其内部的原理。可以通过一下视图和数据字典来来查看ASM 的信息。 一. 相关视图和数据字典  View Name X$ Table name Description V$ASM_DISKGROUP X$KFGRP p

<br /> <br /> <br />Patch 8402551 not available to download from Metalink.Solution<br />Patch 8402551 has been withdrawn because it had some issues, it was replaced by Patch 8969852.<br /><br />Even Patch 8402551 included in Patch 8461420, Patch 8969852 sh

<br /> <br /> <br />       After installing a non-RAC (Real Application Clusters) 10g database, you notice an ocssd.bin process running.<br /><br />ps -ef | grep ocssd.bin<br />oracle 11139 11056 0 14:02:14 pts/52 0:00 grep ocssd.bin<br />oracle 1824 1 0 M

<br /> <br /> <br />If using pfile, it must be a filesystem file on local filesystem.<br />If using spfile, then it can be in the following locations.<br />-- a filesystem file spfile on local filesystem<br />-- spfile on shared device<br />-- a ASM file i

<br /> <br /> <br />       In a single asm_diskstring parameter we can have 255 characters and this excludes the asterisk (*) , comma (,) and single-quote ('). This is limited by v$asm_disk.path column's datatype length. <br /><br />       In an ASM instan

<br /> <br /> <br />1) Please backup the database(s) contained inside the associated diskgroup.<br /><br />2) Then shutdown the databases contained inside the associated diskgroup.<br /><br />3) Dismount the associated diskgroup to verify no client databas

<br /> <br />       rename diskgroup option is a new feature of 11gR2 .<br /><br />       The command renamedg was introduced in 11gR2; however, there are many cases where a diskgroup in a 10g or 11.1 environment needs to be renamed. You can use this tool

<br /> <br /> <br />之前做的一个实验：<br />       RAC 修改 ASM实例名的步骤<br />       http://blog.csdn.net/tianlesoftware/archive/2011/03/25/6275827.aspx<br /> <br /> <br />       The following procedures do require some down time. One node at a time, we will shutdown al

<br /> <br /> <br />       If all you are doing is changing the name of the disk, then the only thing that should be necessary from Oracle's perspective is to change the ASM_DISKSTRING parameter on the ASM instance. Alternatively, you may be able to just r

一. 说明 在官网看到一篇ASM 升级的文档，如下：       How To Upgrade ASM from 10.2 to 11.1 (RAC)       http://blog.csdn.net/tianlesoftware/archive/2011/04/25/6362083.aspx        Unable To Open Database After ASM Upgrade F

<br /> <br />This document will list the possible meta characters for asm_diskstring parameter <br /> <br />Solution<br />* and [] are the two valid meta characters for asm_diskstring parameter.<br /><br />SQL> alter system set asm_diskstring='/dev/raw/raw

<br /> <br />       This document provides a procedure to configure/reconfigure the ( High Availability Service ) HAS and CSS resource on Oracle Grid Infrastructure for nonRAC setup <br /> <br />Solution<br />       1）When you install grid infrastructure f

<br /> <br /> <br />This article describes the steps to migrate a database from Non-ASM to ASM and vice-versa. <br /><br />To setup ASM, please follow<br />Note 452924.1 - How to Prepare Storage for ASM<br />Note 265633.1 - ASM Technical Best Practices<br

<br /> <br />       When applying a needed patch to the Grid Infrastructure Home for ASM or CRS the opatch utility may error out with the messages:<br /> <br />ApplySession failed: ApplySession failed to prepare the system. ApplySession was not able to cre

<br /> <br />After upgrade the ASM instance from release 11.1 to release 11.2 existing database is unable to start/open due to the next error:<br /><br /><br />/u01/app/oracle/product/11.1.0/dbs>sqlplus<br /><br />SQL*Plus: Release 11.1.0.6.0 - Production

<br /> <br /> <br />Upgrading  ASM instance from Oracle 10.1 to Oracle 10.2. (Single Instance) Solution<br /> o Upgrading  of ASM instance  from 10.1 to 10.2 can be accomplished through DBUA.<br /> o  All the database that use the ASM instance  being upgra

<br /> <br />The present document explains how to upgrade an ASM instance from 10.2 to 11.1 release (on RAC). Solution<br />1) Shutdown all the database instances that are using ASM as storage option. <br /><br />2) Shutdown the ASM instances. <br /><br />

<br /> <br />       The purpose of this document is to provide information about the ASM rolling upgrade feature and Step by Step to install a patchset or patch in ASM Home without downtime.Solution<br />The following conditions should be met for to perfor

<br /> <br />       The present document explains how to upgrade an ASM instance from 10.2 to 11.1 release (single Instance configuration / Non-RAC). Solution<br />1) Install the new 11g ASM Oracle Home (on a different directory) as described in the Instal

<br /> <br /> <br />       This note is to clarify the patch requirement when doing 11.2.0.1 to 11.2.0.2 rolling upgrade. <br /> <br />Pre-requsite for 11.2.0.1 to 11.2.0.2 ASM Rolling Upgrade<br />       There has been some confusion as what patches need