ORACLE 11G R2: SCRIPTS BACKUP DEL ASM (METADATOS, SPFILE, RECREACION DE DISKGROUPS)

Ejemplo de backup de la configuración ASM de un RAC llamado ORCL

Realizamos copia de los metadatos y del spfile de asm mediante el comando md_backup de asmcmd

Script /home/oracle/scripts/asm/backasm.sh

##################################################

# Copia de los metadatos de la instancia ASM1 #

##################################################

#!/bin/bash

date=`date '+%d%m%y'`

export date

sid="+ASM1"
export sid

asmcmd md_backup /software/oracle/backup/ORCL/asm/Respaldo_DiskGroup_$sid.$date

asmcmd spbackup +DATA/ORCL/ASMPARAMETERFILE/REGISTRY.253.725461119 /software/oracle/backup/ORCL/asm

Generamos tambien script para recrear el diskgroup

Script /home/oracle/scripts/asm/ backup_diskgroup.sh

# -Script info diskgroups -----------------------------

#!/usr/bin/ksh

# Crash scenario

# Casos :

# ASM disk(s) is not visible on the operating system.

# asm_diskstring parameter is not set correctly on ASM instance(s)

# ASM metadata in disk is overwritten or corrupted

echo "Chequeo el espacio en "$ORACLE_SID

# Para Recrear un Diskgroup....

# CREATE DISKGROUP name EXTERNAL REDUNDANCY DISK 'path1', 'path2', 'path3', ....;

sqlplus '/as sysasm' @/home/oracle/scripts/asm/ASMDiskGroups.sql

cp -p /home/oracle/scripts/asm/ASMDiskGroups.txt /software/oracle/backup/ORCL/asm

Script /home/oracle/scripts/asm/ASMDiskGroups.sql

spool /home/oracle/scripts/asm/ASMDiskGroups.txt

select instance_name from v$instance

/

set lines 130

col path for a35

col Diskgroup for a15

col DiskName for a20

col disk# for 999

col total_mb for 999,999,999

col free_mb for 999,999,999

compute sum of total_mb on DiskGroup

compute sum of free_mb on DiskGroup

set pages 255

select a.name DiskGroup, b.disk_number Disk#, b.name DiskName, b.total_mb, b.free_mb,

b.path, b.header_status

from v$asm_disk b, v$asm_diskgroup a

where a.group_number (+) =b.group_number

order by b.group_number, b.disk_number, b.name

/

exit

/

spool off