An introduction to Automatic Storage Management Christian Bilien
Automatic Storage Management A new feature introduced in Oracle Database 10g Provides a vertical integration of the file system and volume manager for Oracle database files Spreads database files across all available storage for optimal performance and resource utilization Enables simple and non-intrusive resource allocation and provides automatic rebalancing
2
ASM Installation Best Practices Install ASM in a separate ORACLE_HOME from the database ORACLE_HOME Provides higher availability and manageability Allows independent upgrades of the database and ASM. De-installation of database software can be performed without impacting the ASM instance 3
ASM Instance Only one ASM instance per node Manages storage for all database instances on the node In RAC environments, each clustered node will have an ASM instance ASM instances use the interconnect to synchronize metadata 4
Setting init.ora parameter Use default values Only processes parameter may need modification Processes parameter setting is dependent on the number of databases that connect to ASM processes= 25 + 15n, where n = # databases connected to ASM 6
ASM administration Disks Diskgroups Files
7
Diskgroup Best Practices Create two diskgroup - One for database area - Second one for flash recovery area Create diskgroups using large number of similar type disks – same size characteristics – same performance characteristics 8
Diskgroup Best Practices The size of the flash recovery area diskgroup will depend on what is stored and how much is retained If possible, physically separate the database area and flashback area make sure the two areas do not share the same physical spindles
9
Diskgroup Best Practices To minimize search overhead, perform all required mount operations in a single mount command If adding or removing multiple disks, make the change in a single rebalance operation. This coalesces rebalance operations and reduces overhead 10
Diskgroup Best Practices Use ASM External Redundancy when creating disk groups with high end storage arrays Use ASM Redundancy for low-end (modular) or JBOD storage array systems Use failure groups with ASM Redundancy 11
Disk Best Practices Make sure disks span multiple backend disk adapters Implement multiple access paths to the storage array using two or more HBAs or initiator Deploy multi-pathing software over these multiple HBAs to provide I/O load-balancing and failover capabilities. 12
Disk Best Practices If using hardware RAID, make LUN stripe size as close to 1mb as possible Use OS disk labels when available - Prevents accidental user overwrites of disks - Easier management of disks - Make sure the disk (partition) starts at 1Mb a boundary, to insure proper I/O alignment
13
Database-ASM Best Practice Create CRS dependency between database instance and ASM instance Ensures ASM instance starts up before starting database instance Use 10g Automatic Memory Management Allows ASM instance to cleanly shutdown database instance srvctl modify instance -d crm -i crm1 -s asm1
14
Database-ASM Best Practices The following recommendations for database SGA sizing can be used to calculate the SGA_TARGET value – large_pool = Add additional 600k – Processes = Add 16
15
Database-ASM Best Practices Shared_pool – Aggregate the values from the following queries to obtain current database storage sizes that is either already on ASM or will be stored in ASM. Then determine the redundancy type that is used (or will be used), and calculate the shared_pool, using the aggregated value as input. . select sum(bytes)/(1024*1024*1024) from v$datafile; . select sum(bytes)/(1024*1024*1024) from v$logfile a, v$log b where a.group#=b.group#; . select sum(bytes)/(1024*1024*1024) from v$tempfile where status='ONLINE'; For diskgroups using external redundancy = (Every 100Gb of space needs 1Mb of extra shared pool) + 2M For diskgroups using Normal redundancy: (Every 50Gb of space needs 1Mb of extra shared pool) + 4M. For diskgroups using High redundancy: (Every 33Gb of space needs 1Mb of extra shared pool) + 6M. 16
Database-ASM Best Practices RMAN is the recommended method for backup/recovery of database – RMAN is completely ASM diskgroup aware - DataPump dumpsets can be created in diskgroups
17
ASM Command Line Utility $ asmcmd ASMCMD> ls –l State Type Rebal Unbal Name MOUNTED EXTERN N N DISKGROUP1/ MOUNTED EXTERN N N FLASH/ASMCMD ASMCMD> cd DISKGROUP1 ASMCMD> ls –l Type Redund Striped Time ASMCMD> ASMCMD> Type
Sys Name Y SALES/
cd SALES ls –l Redund Striped Time
Sys Name Y CONTROLFILE/ Y DATAFILE/ Y ONLINELOG/ Y PARAMETERFILE/ Y TEMPFILE/ N spfilesales.ora => +DISKGROUP1/SALES/PARAMETERFILE/spfile.268.569267897ASMCMD ASMCMD> cd DATAFILE ASMCMD> pwd +DISKGROUP1/SALES/DATAFILE
18
Migration to ASM Database must already be 10g database Use RMAN to migrate to ASM from raw or file system RMAN can be used to migrate entire databases or individual files
Voting Disk >= 20MB, OCR >= 100MB. â Use storage mirroring to protect these devices. Configure shared Storage (for ASM). â Use large number of similarly ...
a suite of operators for calculations on arrays, in particular matrices,. ⢠a large ..... Character quantities and character vectors are used frequently in R, for example as plot labels. Where needed ...... Convert Rd format to DVI/PDF. Rd2txt. Con
significant." print hello ... Note that leading whitespace is significant. ...... Round- ing that to 17 significant digits gives the 0.10000000000000001 that Py-.
energy work to address my own healing concerns, I remained anxious about the idea of using it with ... Regardless, please feel free to distribute it via email or post it ...... Zensight with clients, you may wish to join this list in order to share c
language, one should regard most programs written in R as essentially ephemeral. 1.2 Related ..... elements of a vector respectively. range is a function whose value is a vector of length two, ... The fifth parameter may be named along=vector, which
dramatically reduces disturbances at the layer edge and the inlet site (see text below and Figure 1). ..... polar components of the mobile phase as a result of their.
HAt him.[13] to appeared first. Ong. `a-Tiên, sin spirit, that with contacts further made .... admin- the entered. He. 1893. in graduated he whence by advanced and ...... manual that to reference of fact mere. Sino-Vietnamese on mainly depended ....
resonance, a phenomenon that when properly used lets you make filters ... the peak can still be quite high, with a maximal response occurring when f = 1/2 LC.
First example of stochastic approximation (Robbins , 1951): a line search with noise. â· Parameter x â R. â· System output g(x) â R, g smooth and increasing.
Dec 10, 1999 - q Tutorial q Library ... q Python Imaging Library Handbook for 1.1.3 (PDF) q Articles ...... The relief settings control how to draw the widget border: ..... window itself will be destroyed as usual (in a controlled fashion, unlike X).
3.2.3 The originalPerceptron . ... 5.1.3 Back-propagation in fully recurrent networks . ..... chapter 7 was form by a report of Gerard Schram at the University of Amsterdam. ... within their psychology, physics, computer science, or biology departmen
Oct 11, 2013 - Namely, at time n â N, the decision maker sets the parameter equal to xn, and observes Yn = g(xn) + Mn with Mn a random variable .... can observe f(xn) + Mn. Therefore it makes sense to approximate âf by finite differences,.
No matter how professional your IT organization, if you can't resolve problems quickly and ... Drawing upon his extensive consulting experience, Gary Walker.
The approach taken to handle these two conflicting requirements was to organize the ..... Business Process Diagrams and UML Activity Diagrams will take place.
PDF Ebook voila an introduction to french 6th Free Download, Save or Read Online voila an introduction to french 6th PDF file for free from our online library.
algebras, coalgebras, etc, will be defined over K. We refer to the classical references .... Proposition 1. For all n ...... J. Pure Appl. Algebra, 209(2):477â495, 2007.
Feb 19, 2013 - Figure 2: Horaires des trains entre Paris et Lyon, E.J. Marey (1885) .... 2. The boxplot itself, which concentrates on the central bulk of the data. 3.
Sections 1, 2, 5, 6, 7, and 8 will survive any ..... directed Shapiro to the companies InXight and TheBrain, both of which sell proprietary ..... 003-paper.pdf>.
colleagues who have all helped with ideas, examples and exercisesâtheir ..... The programmer is able to develop a partial solution, test it, add new ...... in practice since the argument is expected to be an instance of Association (see ...... from