‘2. ASM’

RAC Database stop and start steps

  Steps to Shutdown/Start RAC Database 1. Shutdown Oracle Home process accessing database. 2. Shutdown RAC Database Instances on all nodes. 3. Shutdown All ASM instances from all nodes. 4. Shutdown Node applications running on nodes. 5. Shut down the Oracle Cluster ware or CRS. Starting steps are from 5 to 1(means which stopped last should be started 1st). […]

November 29, 2015 · Sanjay · No Comments
Posted in: 1. DB Admin, 2. ASM, 6. RAC, 7. High Availability

ASM: Disks performance metric

ASM Disks performance metric SET ECHO off SET FEEDBACK 8 SET HEADING ON SET LINESIZE 230 SET PAGESIZE 300 SET TERMOUT ON SET TIMING OFF SET TRIMOUT ON SET TRIMSPOOL ON SET VERIFY OFF CLEAR COLUMNS CLEAR BREAKS CLEAR COMPUTES COLUMN disk_group_name FORMAT a20 HEAD ‘Disk Group Name’ COLUMN disk_path FORMAT a20 HEAD ‘Disk Path’ […]

March 14, 2014 · Sanjay · No Comments
Posted in: 2. ASM, 3. All Scripts

ASM: List of ASM files and its volume details

List of ASM files and its volume details SET ECHO OFF SET FEEDBACK 6 SET HEADING ON SET LINESIZE 180 SET PAGESIZE 50000 SET TERMOUT ON SET TIMING OFF SET TRIMOUT ON SET TRIMSPOOL ON SET VERIFY OFF CLEAR COLUMNS CLEAR BREAKS CLEAR COMPUTES COLUMN full_path FORMAT a75 HEAD ‘ASM File Name / Volume Name […]

March 14, 2014 · Sanjay · No Comments
Posted in: 2. ASM, 3. All Scripts

ASM: Disks within a disk group

Disks within Disk a Group SET ECHO off SET FEEDBACK 8 SET HEADING on SET LINESIZE 230 SET PAGESIZE 300 SET TERMOUT ON SET TIMING OFF SET TRIMOUT ON SET TRIMSPOOL ON SET VERIFY OFF CLEAR COLUMNS CLEAR BREAKS CLEAR COMPUTES COLUMN disk_group_name FORMAT a30 HEAD ‘Disk Group Name’ COLUMN disk_file_path FORMAT a20 HEAD ‘Path’ […]

March 14, 2014 · Sanjay · No Comments
Posted in: 2. ASM, 3. All Scripts