Lokeshaggarwal's DBA

Live the life you love. Love the life you live

Backup and Restore of ASM Metadata in Oracle 11gR2 (md_backup and md_restore)


In this article I will give you a demo how to backup a disk group using md_backup command and  md_restore to obtain the SQL statements to recreate the disk groups and all the dependencies such as directories,templates, aliases and disk group attributes.

 

[grid@rac2 bin]$ ./asmcmd
ASMCMD> ls
CRS/
DATA/
FRA/
ASMCMD> md_backup -h
Unknown option: h
usage: md_backup <backup_file>
[-G ‘<diskgroup_name>,<diskgroup_name>,…’]
help: help md_backup
ASMCMD> md_backup /raczone/asmbackup.bcp -G CRS,DATA,FRA
Disk group metadata to be backed up: CRS
Disk group metadata to be backed up: DATA
Disk group metadata to be backed up: FRA
Current alias directory path: scan-cluster
Current alias directory path: scan-cluster/ASMPARAMETERFILE
Current alias directory path: scan-cluster/OCRFILE
Current alias directory path: DEV/TEMPFILE
Current alias directory path: DEV
Current alias directory path: DEV/PARAMETERFILE
Current alias directory path: DEV/DATAFILE
Current alias directory path: DEV/CONTROLFILE
Current alias directory path: DEV/ONLINELOG
Current alias directory path: DEV/CONTROLFILE
Current alias directory path: DEV
Current alias directory path: DEV/ONLINELOG
ASMCMD-09345: could not open intermediate file ‘/raczone/asmbackup.bcp’
Permission denied
ASMCMD> md_backup /tmp/asmbackup.bcp -G CRS,DATA,FRA
Disk group metadata to be backed up: CRS
Disk group metadata to be backed up: DATA
Disk group metadata to be backed up: FRA
Current alias directory path: scan-cluster
Current alias directory path: scan-cluster/ASMPARAMETERFILE
Current alias directory path: scan-cluster/OCRFILE
Current alias directory path: DEV/TEMPFILE
Current alias directory path: DEV
Current alias directory path: DEV/PARAMETERFILE
Current alias directory path: DEV/DATAFILE
Current alias directory path: DEV/CONTROLFILE
Current alias directory path: DEV/ONLINELOG
Current alias directory path: DEV/CONTROLFILE
Current alias directory path: DEV
Current alias directory path: DEV/ONLINELOG
ASMCMD> md_restore /tmp/asmbackup.bcp –full -S /tmp/ASM_diskgroup.sql
Current Diskgroup metadata being restored: CRS
Current Diskgroup metadata being restored: DATA
Current Diskgroup metadata being restored: FRA
ASMCMD>

 

[root@rac2 tmp]# cat ASM_diskgroup.sql
create diskgroup CRS EXTERNAL redundancy disk ‘ORCL:VOTE1’ name VOTE1 size 1953M attribute ‘compatible.asm’ = ‘11.2.0.0.0’ , ‘compatible.rdbms’ = ‘10.1.0.0.0’ , ‘au_size’ = ‘1048576’, ‘sector_size’ = ‘512’, ‘cell.smart_scan_capable’ = ‘FALSE’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.TEMPFILE.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.PARAMETERFILE.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.OCRBACKUP.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.TEMPFILE.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.PARAMETERFILE.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.DATAGUARDCONFIG.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘ACCESS_CONTROL.UMASK’ = ‘066’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.ASM_STALE.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.ARCHIVELOG.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.DATAGUARDCONFIG.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.OCRBACKUP.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.DATAFILE.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.CONTROLFILE.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.ASMPARAMETERFILE.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.CHANGETRACKING.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.BACKUPSET.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.FLASHFILE.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.ARCHIVELOG.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.CHANGETRACKING.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.ONLINELOG.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.CHANGETRACKING.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.BACKUPSET.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘DISK_REPAIR_TIME’ = ‘3.6h’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.OCRFILE.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.AUTOBACKUP.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.DUMPSET.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.FLASHBACK.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.DUMPSET.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.DUMPSET.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.ASM_STALE.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.FLASHBACK.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.XTRANSPORT.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.DATAFILE.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.CONTROLFILE.STRIPE’ = ‘1’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.AUTOBACKUP.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.CONTROLFILE.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.DATAFILE.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.FLASHFILE.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.ASMPARAMETERFILE.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.ASM_STALE.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.FLASHBACK.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.DATAGUARDCONFIG.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE_VERSION’ = ‘186646528’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.PARAMETERFILE.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.DATAFILE.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.PARAMETERFILE.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.BACKUPSET.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.OCRBACKUP.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.ONLINELOG.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.ASMPARAMETERBAKFILE.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘ACCESS_CONTROL.ENABLED’ = ‘FALSE’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.DATAGUARDCONFIG.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.TEMPFILE.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.FLASHFILE.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.ONLINELOG.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.FLASHFILE.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.OCRBACKUP.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.OCRFILE.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.AUTOBACKUP.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.ASM_STALE.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.XTRANSPORT.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.ASMPARAMETERBAKFILE.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.DUMPSET.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.TEMPFILE.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.OCRFILE.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.ONLINELOG.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.ARCHIVELOG.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.OCRFILE.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.ARCHIVELOG.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.ASMPARAMETERFILE.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.FLASHBACK.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.XTRANSPORT.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.CONTROLFILE.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.BACKUPSET.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.XTRANSPORT.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.ASMPARAMETERBAKFILE.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.CHANGETRACKING.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.ASMPARAMETERBAKFILE.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.ASMPARAMETERFILE.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS set attribute ‘TEMPLATE.AUTOBACKUP.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/CRS alter template AUTOBACKUP attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/CRS alter template ASMPARAMETERFILE attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/CRS alter template OCRBACKUP attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/CRS alter template ARCHIVELOG attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/CRS alter template ASM_STALE attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/CRS alter template ONLINELOG attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/CRS alter template DATAFILE attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/CRS alter template OCRFILE attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/CRS alter template CHANGETRACKING attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/CRS alter template ASMPARAMETERBAKFILE attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/CRS alter template FLASHFILE attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/CRS alter template TEMPFILE attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/CRS alter template XTRANSPORT attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/CRS alter template DATAGUARDCONFIG attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/CRS alter template FLASHBACK attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/CRS alter template PARAMETERFILE attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/CRS alter template CONTROLFILE attributes (UNPROTECTED FINE);
alter diskgroup /*ASMCMD AMBR*/CRS alter template BACKUPSET attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/CRS alter template DUMPSET attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR */ CRS add directory ‘+CRS/scan-cluster’;
alter diskgroup /*ASMCMD AMBR */ CRS add directory ‘+CRS/scan-cluster/ASMPARAMETERFILE’;
alter diskgroup /*ASMCMD AMBR */ CRS add directory ‘+CRS/scan-cluster/OCRFILE’;
create diskgroup DATA EXTERNAL redundancy disk ‘ORCL:DATA1’ name DATA1 size 14306M attribute ‘compatible.asm’ = ‘11.2.0.0.0’ , ‘compatible.rdbms’ = ‘10.1.0.0.0’ , ‘au_size’ = ‘1048576’, ‘sector_size’ = ‘512’, ‘cell.smart_scan_capable’ = ‘FALSE’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.OCRBACKUP.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.TEMPFILE.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.PARAMETERFILE.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.TEMPFILE.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.PARAMETERFILE.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.DATAGUARDCONFIG.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘ACCESS_CONTROL.UMASK’ = ‘066’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.ASM_STALE.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.ARCHIVELOG.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.DATAGUARDCONFIG.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.OCRBACKUP.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.DATAFILE.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.CONTROLFILE.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.ASMPARAMETERFILE.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.CHANGETRACKING.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.BACKUPSET.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.FLASHFILE.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.ARCHIVELOG.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.CHANGETRACKING.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.ONLINELOG.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.CHANGETRACKING.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.BACKUPSET.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.OCRFILE.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘DISK_REPAIR_TIME’ = ‘3.6h’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.FLASHBACK.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.AUTOBACKUP.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.DUMPSET.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.ASM_STALE.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.DUMPSET.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.DUMPSET.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.FLASHBACK.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.XTRANSPORT.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.DATAFILE.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.CONTROLFILE.STRIPE’ = ‘1’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.AUTOBACKUP.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.CONTROLFILE.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.DATAFILE.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.FLASHFILE.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.ASMPARAMETERFILE.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.ASM_STALE.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.FLASHBACK.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.DATAGUARDCONFIG.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE_VERSION’ = ‘186646528’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.PARAMETERFILE.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.DATAFILE.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.PARAMETERFILE.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.BACKUPSET.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.OCRBACKUP.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.ONLINELOG.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.ASMPARAMETERBAKFILE.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘ACCESS_CONTROL.ENABLED’ = ‘FALSE’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.DATAGUARDCONFIG.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.TEMPFILE.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.FLASHFILE.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.ONLINELOG.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.FLASHFILE.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.OCRBACKUP.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.OCRFILE.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.ASM_STALE.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.AUTOBACKUP.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.XTRANSPORT.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.ASMPARAMETERBAKFILE.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.DUMPSET.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.TEMPFILE.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.OCRFILE.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.OCRFILE.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.ONLINELOG.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.ARCHIVELOG.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.ARCHIVELOG.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.FLASHBACK.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.ASMPARAMETERFILE.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.XTRANSPORT.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.CONTROLFILE.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.BACKUPSET.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.XTRANSPORT.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.ASMPARAMETERBAKFILE.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.CHANGETRACKING.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.ASMPARAMETERBAKFILE.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.ASMPARAMETERFILE.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA set attribute ‘TEMPLATE.AUTOBACKUP.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/DATA alter template OCRBACKUP attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/DATA alter template ASMPARAMETERFILE attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/DATA alter template AUTOBACKUP attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/DATA alter template ARCHIVELOG attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/DATA alter template ONLINELOG attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/DATA alter template BACKUPSET attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/DATA alter template DATAFILE attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/DATA alter template XTRANSPORT attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/DATA alter template DATAGUARDCONFIG attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/DATA alter template ASMPARAMETERBAKFILE attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/DATA alter template FLASHFILE attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/DATA alter template TEMPFILE attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/DATA alter template OCRFILE attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/DATA alter template CHANGETRACKING attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/DATA alter template FLASHBACK attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/DATA alter template PARAMETERFILE attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/DATA alter template CONTROLFILE attributes (UNPROTECTED FINE);
alter diskgroup /*ASMCMD AMBR*/DATA alter template ASM_STALE attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/DATA alter template DUMPSET attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR */ DATA add directory ‘+DATA/DEV’;
alter diskgroup /*ASMCMD AMBR */ DATA add directory ‘+DATA/DEV/DATAFILE’;
alter diskgroup /*ASMCMD AMBR */ DATA add directory ‘+DATA/DEV/CONTROLFILE’;
alter diskgroup /*ASMCMD AMBR */ DATA add directory ‘+DATA/DEV/PARAMETERFILE’;
alter diskgroup /*ASMCMD AMBR */ DATA add directory ‘+DATA/DEV/TEMPFILE’;
alter diskgroup /*ASMCMD AMBR */ DATA add directory ‘+DATA/DEV/ONLINELOG’;
create diskgroup FRA EXTERNAL redundancy disk ‘ORCL:FRA’ name FRA size 7814M attribute ‘compatible.asm’ = ‘11.2.0.0.0’ , ‘compatible.rdbms’ = ‘10.1.0.0.0’ , ‘au_size’ = ‘1048576’, ‘sector_size’ = ‘512’, ‘cell.smart_scan_capable’ = ‘FALSE’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.TEMPFILE.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.PARAMETERFILE.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.OCRBACKUP.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.TEMPFILE.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.PARAMETERFILE.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.DATAGUARDCONFIG.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘ACCESS_CONTROL.UMASK’ = ‘066’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.ASM_STALE.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.ARCHIVELOG.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.DATAGUARDCONFIG.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.OCRBACKUP.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.DATAFILE.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.CONTROLFILE.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.ASMPARAMETERFILE.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.CHANGETRACKING.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.BACKUPSET.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.FLASHFILE.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.ARCHIVELOG.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.CHANGETRACKING.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.ONLINELOG.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.CHANGETRACKING.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.BACKUPSET.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘DISK_REPAIR_TIME’ = ‘3.6h’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.OCRFILE.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.AUTOBACKUP.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.DUMPSET.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.FLASHBACK.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.DUMPSET.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.DUMPSET.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.ASM_STALE.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.FLASHBACK.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.XTRANSPORT.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.DATAFILE.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.CONTROLFILE.STRIPE’ = ‘1’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.AUTOBACKUP.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.CONTROLFILE.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.DATAFILE.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.FLASHFILE.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.ASMPARAMETERFILE.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.ASM_STALE.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.FLASHBACK.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.DATAGUARDCONFIG.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE_VERSION’ = ‘186646528’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.PARAMETERFILE.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.DATAFILE.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.PARAMETERFILE.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.BACKUPSET.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.OCRBACKUP.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.ONLINELOG.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.ASMPARAMETERBAKFILE.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘ACCESS_CONTROL.ENABLED’ = ‘FALSE’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.DATAGUARDCONFIG.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.TEMPFILE.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.FLASHFILE.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.ONLINELOG.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.FLASHFILE.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.OCRBACKUP.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.OCRFILE.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.AUTOBACKUP.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.ASM_STALE.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.XTRANSPORT.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.ASMPARAMETERBAKFILE.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.DUMPSET.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.TEMPFILE.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.OCRFILE.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.ONLINELOG.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.ARCHIVELOG.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.OCRFILE.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.ARCHIVELOG.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.ASMPARAMETERFILE.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.FLASHBACK.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.XTRANSPORT.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.CONTROLFILE.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.BACKUPSET.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.XTRANSPORT.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.ASMPARAMETERBAKFILE.REDUNDANCY’ = ’17’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.CHANGETRACKING.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.ASMPARAMETERBAKFILE.MIRROR_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.ASMPARAMETERFILE.PRIMARY_REGION’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA set attribute ‘TEMPLATE.AUTOBACKUP.STRIPE’ = ‘0’;
alter diskgroup /*ASMCMD AMBR*/FRA alter template DATAGUARDCONFIG attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/FRA alter template ONLINELOG attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/FRA alter template TEMPFILE attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/FRA alter template ASMPARAMETERBAKFILE attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/FRA alter template ASM_STALE attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/FRA alter template ASMPARAMETERFILE attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/FRA alter template PARAMETERFILE attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/FRA alter template BACKUPSET attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/FRA alter template CHANGETRACKING attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/FRA alter template ARCHIVELOG attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/FRA alter template DUMPSET attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/FRA alter template OCRBACKUP attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/FRA alter template FLASHBACK attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/FRA alter template AUTOBACKUP attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/FRA alter template XTRANSPORT attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/FRA alter template DATAFILE attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/FRA alter template CONTROLFILE attributes (UNPROTECTED FINE);
alter diskgroup /*ASMCMD AMBR*/FRA alter template OCRFILE attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR*/FRA alter template FLASHFILE attributes (UNPROTECTED COARSE);
alter diskgroup /*ASMCMD AMBR */ FRA add directory ‘+FRA/DEV’;
alter diskgroup /*ASMCMD AMBR */ FRA add directory ‘+FRA/DEV/CONTROLFILE’;
alter diskgroup /*ASMCMD AMBR */ FRA add directory ‘+FRA/DEV/ONLINELOG’;
[root@rac2 tmp]#

 

Advertisements

December 19, 2012 - Posted by | ASM

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: