Lokeshaggarwal's DBA

Live the life you love. Love the life you live

amdu – ASM Metadata Dump Utility


  • Allows to dump ASM contents without opening diskgroups, allows to check ASM file mirroring when using normal redundancy
  • powerful tool for troubleshooting, introduced in 11g, usable in 10g too.

In the below demonstration, we will try to extract the controlfile, although. the diskgorups are in mounted state.

[grid@rac2 bin]$ . oraenv
ORACLE_SID = [grid] ? +ASM2
The Oracle base for ORACLE_HOME=/raczone/grid_home is /raczone/11.2.0
[grid@rac2 bin]$ ./asmcmd find –type controlfile + “*”asmcmd find –type controlfile + “*”

[grid@rac2 bin]$ ./asmcmd find –type controlfile + “*”
+DATA/DEV/CONTROLFILE/Current.260.802353245
+FRA/DEV/CONTROLFILE/Current.256.802353245

[grid@rac2 bin]$ ./asmcmd lsdsk -G DATA
Path
ORCL:DATA1

Let’s extract that controlfile out of the disk group DATA onto the file system:

[grid@rac2 tmp]$ amdu -diskstring=”ORCL:*” -extract DATA.260 -output control.260 -noreport -nodir
AMDU-00204: Disk N0001 is in currently mounted diskgroup DATA
AMDU-00201: Disk N0001: ‘ORCL:DATA1’
[grid@rac2 tmp]$ ll
total 18088
-rw-r–r– 1 grid oinstall 18497536 Dec 19 15:53 control.260

[grid@rac2 tmp]$ ls -lrt
total 18088
-rw-r–r– 1 grid oinstall 18497536 Dec 19 15:53 control.260
[grid@rac2 tmp]$ /raczone/grid_home/bin/./amdu -dump DATA -noimage
amdu_2012_12_19_15_55_41/
AMDU-00204: Disk N0001 is in currently mounted diskgroup DATA
AMDU-00201: Disk N0001: ‘ORCL:DATA1’
[grid@rac2 tmp]$ ls
amdu_2012_12_19_15_55_41 control.260
[grid@rac2 tmp]$ cd amdu_2012_12_19_15_55_41/
[grid@rac2 amdu_2012_12_19_15_55_41]$ ll
total 20
-rw-r–r– 1 grid oinstall 8320 Dec 19 15:55 DATA.map
-rw-r–r– 1 grid oinstall 4791 Dec 19 15:55 report.txt
[grid@rac2 amdu_2012_12_19_15_55_41]$ more report.txt
-*-amdu-*-

******************************* AMDU Settings ********************************
ORACLE_HOME = /raczone/grid_home
System name: Linux
Node name: rac2.raczone.com
Release: 2.6.18-128.el5
Version: #1 SMP Wed Dec 17 11:42:39 EST 2008
Machine: i686
amdu run: 19-DEC-12 15:55:41
Endianess: 1

——————————— Operations ———————————
-dump DATA

——————————- Disk Selection ——————————-
-diskstring ”

—————————— Reading Control ——————————-

——————————- Output Control ——————————-
-noimage

********************************* DISCOVERY **********************************

—————————– DISK REPORT N0001 ——————————
Disk Path: ORCL:DATA1
Unique Disk ID:
Disk Label: DATA1
Physical Sector Size: 512 bytes
Disk Size: 14306 megabytes
Group Name: DATA
Disk Name: DATA1
Failure Group Name: DATA1
Disk Number: 0
Header Status: 3
Disk Creation Time: 2012/12/18 11:38:24.527000
Last Mount Time: 2012/12/19 11:50:59.308000
Compatibility Version: 0x0b200000(11020000)
Disk Sector Size: 512 bytes
Disk size in AUs: 14306 AUs
Group Redundancy: 1
Metadata Block Size: 4096 bytes
AU Size: 1048576 bytes
Stride: 113792 AUs
Group Creation Time: 2012/12/18 11:38:24.388000
File 1 Block 1 location: AU 2
OCR Present: NO

—————————– DISK REPORT N0002 ——————————
Disk Path: ORCL:FRA
Unique Disk ID:
Disk Label: FRA
Physical Sector Size: 512 bytes
Disk Size: 7814 megabytes
Group Name: FRA
Disk Name: FRA
Failure Group Name: FRA
Disk Number: 0
Header Status: 3
Disk Creation Time: 2012/12/18 11:42:08.078000
Last Mount Time: 2012/12/19 11:50:59.843000
Compatibility Version: 0x0b200000(11020000)
Disk Sector Size: 512 bytes
Disk size in AUs: 7814 AUs
Group Redundancy: 1
Metadata Block Size: 4096 bytes
AU Size: 1048576 bytes
Stride: 113792 AUs
Group Creation Time: 2012/12/18 11:42:07.927000
File 1 Block 1 location: AU 2
OCR Present: NO

—————————– DISK REPORT N0003 ——————————
Disk Path: ORCL:VOTE1
Unique Disk ID:
Disk Label: VOTE1
Physical Sector Size: 512 bytes
Disk Size: 1953 megabytes
Group Name: CRS
Disk Name: VOTE1
Failure Group Name: VOTE1
Disk Number: 0
Header Status: 3
Disk Creation Time: 2012/12/17 16:39:42.078000
Last Mount Time: 2012/12/19 11:50:58.746000
Compatibility Version: 0x0b200000(11020000)
Disk Sector Size: 512 bytes
Disk size in AUs: 1953 AUs
Group Redundancy: 1
Metadata Block Size: 4096 bytes
AU Size: 1048576 bytes
Stride: 113792 AUs
Group Creation Time: 2012/12/17 16:39:41.936000
File 1 Block 1 location: AU 2
OCR Present: YES

***************** Slept for 6 seconds waiting for heartbeats *****************

************************** SCANNING DISKGROUP DATA ***************************
Creation Time: 2012/12/18 11:38:24.388000
Disks Discovered: 1
Redundancy: 1
AU Size: 1048576 bytes
Metadata Block Size: 4096 bytes
Physical Sector Size: 512 bytes
Metadata Stride: 113792 AU
Duplicate Disk Numbers: 0
—————————- SCANNING DISK N0001 —————————–
Disk N0001: ‘ORCL:DATA1’
AMDU-00204: Disk N0001 is in currently mounted diskgroup DATA
AMDU-00201: Disk N0001: ‘ORCL:DATA1’
** HEARTBEAT DETECTED **
Allocated AU’s: 1559
Free AU’s: 12747
AU’s read for dump: 104
Block images saved: 23563
Map lines written: 104
Heartbeats seen: 1
Corrupt metadata blocks: 0
Corrupt AT blocks: 0
————————- SUMMARY FOR DISKGROUP DATA ————————-
Allocated AU’s: 1559
Free AU’s: 12747
AU’s read for dump: 104
Block images saved: 23563
Map lines written: 104
Heartbeats seen: 1
Corrupt metadata blocks: 0
Corrupt AT blocks: 0
******************************* END OF REPORT ********************************

Advertisements

December 19, 2012 Posted by | ASM | Leave a comment

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]#

 

December 19, 2012 Posted by | ASM | Leave a comment