Alejandro Vargas

The server where the labs of the ASM Hands-On Training works is configured with tcsh as the default oracle user shell. A .cshrc file containing several aliases was setup to easy moving around and executing repetitive commands. On this document... alejandro.vargas

On this lab we will review some of the useful set of commands provided by the ASM command line utility. Some of the asmcmd commands display information, these information is based on v$asm views, other commands actually make changes to... alejandro.vargas

On this lab we will share our ASM disks with a second server and we will open the sati12 database on it. To do that we copied the vm to another location, without including the ASM disks, that are located... alejandro.vargas

On this lab we will review various utilities that provide further information for managing ASM. Checksum Mismatch After Storage Crash, AMDU an 11g tool that can be used with 10g as well, Blockdumps, Asmiostats and asmdebug Details on this file:... alejandro.vargas

On this lab we will review simple methods for getting input about the the database througput and response time. We will produce the load using swingbench and we will gather AWR snapshots every 10 minutes. After some time we will... alejandro.vargas

Whenever implementing new environments it is convenient to run stress tests and to gather OS statistics that will provide valuable diagnostics information. Swingbench provide an easy configurable tool to run oltp or dss like stress tests; that is very useful... alejandro.vargas

Sometimes it is required having several clones of the same database running on the same server. That was simple to do when the database was based on File System, and is still simple to do with the help of Rman.... alejandro.vargas

On this lab we will make a review of the 11g Compatibility Parameters and 3 Resilience Tests The compatibility parameters compatible.asm and compatible.rdbms define the minimum ASM and database versions that will be able to connect to a disk group.... alejandro.vargas

On this Lab we will review the following crash and recovery scenarios, and we will implement some of them: · System tablespace loss · Recover system tablespace · User datafile loss · Recover users tablespace · Online redo loss ·... alejandro.vargas

To work on the 11g part of the Labs we will start restoring an 11g database we have on a backup. The backup consist of an incremental level 0 backupset, a controlfile and spfile backup and the archived logs required... alejandro.vargas

In this Lab we will migrate our 10g Disk Groups to 11g. The first steps of the migration, Installing 11.1.0.6 on it's own Oracle Home and applying patch 11.1.0.7 are ready on this environment, so we can go ahead with... alejandro.vargas

ASMLib is best practice for managing ASM on Linux, it may happen that a database server that was configured a couple of years ago with ASM 10g R1 is still using raw devices, or that a new ASM 10g R2... alejandro.vargas

The use of ftp and html add flexibility to manage the ASM environment, here a brief description of how to implement this configuration. XDB enable use of FTP and HTML protocols to access and manage files located on ASM disksgroups.... alejandro.vargas

For Databases requiring normal redundancy I definitively recommend 11g instead of 10g, because the fast mirror resynchronization new feature that makes possible to reinstate a failed disk without requiring to rebuild it as is the case on 10g. This Hands... alejandro.vargas

This lab looks into the ASM disk header section that contain the Partnership and Status Table, the PST. I have found in some limited occasions, specially following storage crashes that result in problems to mount the ASM disk groups, that... alejandro.vargas