Lokeshaggarwal's DBA

Live the life you love. Love the life you live

Relocating SCAN VIP from one node to another node


Here, I am giving you a demonstration of relocation SCAN from one node to another.

In the below section, we can see that 3 SCAN VIP are running .e 1 VIP is running on rac2 and 2 VIP are running on rac1.

[grid@rac2 bin]$ ./srvctl status scan

SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node rac2
SCAN VIP scan2 is enabled
SCAN VIP scan2 is running on node rac1
SCAN VIP scan3 is enabled
SCAN VIP scan3 is running on node rac1

 

[grid@rac2 bin]$ ./srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node rac2
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is running on node rac1
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is running on node rac1

So, now lets see the syntax for relocating the scan.

[grid@rac2 bin]$ ./srvctl relocate scan -h

Temporarily relocate SCAN VIP from one node of the cluster to another.

Usage: srvctl relocate scan -i <ordinal_number> [-n <node_name>]
-i <scan_ordinal_number> Ordinal number of IP address
-n <node_name> SCAN VIP node name
-h Print usages

Now, lets try to relocate SCAN VIP 1 to rac1.

[grid@rac2 bin]$ ./srvctl relocate scan -i 1 -n rac1

So, as per the below section we can see that now all the scan listener are runing on rac1.Hence, we can also conclude that it is not necessare that SCAN listener has to be run on every node.It can run on all nodes or on partially some nodes.

[grid@rac2 bin]$ ./srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node rac1
SCAN VIP scan2 is enabled
SCAN VIP scan2 is running on node rac1
SCAN VIP scan3 is enabled
SCAN VIP scan3 is running on node rac1
[grid@rac2 bin]$

 
[grid@rac2 bin]$ ./srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node rac1
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is running on node rac1
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is running on node rac1
[grid@rac2 bin]$

Advertisements

December 28, 2012 Posted by | RAC | Leave a comment

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 ********************************

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

Deleting an OCR in 11gR2


[root@rac2 bin]# ./ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 2768
Available space (kbytes) : 259352
ID : 15574406
Device/File Name : +CRS
Device/File integrity check succeeded
Device/File Name : +DATA
Device/File integrity check succeeded

Device/File not configured

Device/File not configured

Device/File not configured

Cluster registry integrity check succeeded

Logical corruption check succeeded

[root@rac2 bin]# ./ocrconfig -delete +DATA
[root@rac2 bin]# ./ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 2768
Available space (kbytes) : 259352
ID : 15574406
Device/File Name : +CRS
Device/File integrity check succeeded

Device/File not configured

Device/File not configured

Device/File not configured

Device/File not configured

Cluster registry integrity check succeeded

Logical corruption check succeeded

[root@rac2 bin]#

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

Adding an OCR on a separate Diskgroup 11gR2


[root@rac2 bin]# ./ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 2768
Available space (kbytes) : 259352
ID : 15574406
Device/File Name : +CRS
Device/File integrity check succeeded

Device/File not configured

Device/File not configured

Device/File not configured

Device/File not configured

Cluster registry integrity check succeeded

Logical corruption check succeeded

[root@rac2 bin]# /usr/sbin/oracleasm listdisks
DATA1
FRA
VOTE1

[root@rac2 bin]# ./ocrconfig -add +Data

PROT-30: The Oracle Cluster Registry location to be added is not accessible

What does this error mean?

By default when you create a diskgroup in 11gR2 RAC from the command prompt using SQL plus, the default compatibility attribute of the diskgroup is set to 10.1. This issue does not occur if you create it through ASMCA.

[oracle@rac2 bin]$ . oraenv

ORACLE_SID = [+ASM1] ?
The Oracle base for ORACLE_HOME=/raczone/grid_home1 is /raczone/11.2.0.1
[oracle@rac2 bin]$ ./sqlplus “/as sysdba”

SQL*Plus: Release 11.2.0.1.0 Production on Thu Dec 13 15:27:42 2012

Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – Production
With the Real Application Clusters and Automatic Storage Management options

SQL> desc v$asm_diskgroup
Name Null? Type
—————————————– ——– —————————-
GROUP_NUMBER NUMBER
NAME VARCHAR2(30)
SECTOR_SIZE NUMBER
BLOCK_SIZE NUMBER
ALLOCATION_UNIT_SIZE NUMBER
STATE VARCHAR2(11)
TYPE VARCHAR2(6)
TOTAL_MB NUMBER
FREE_MB NUMBER
HOT_USED_MB NUMBER
COLD_USED_MB NUMBER
REQUIRED_MIRROR_FREE_MB NUMBER
USABLE_FILE_MB NUMBER
OFFLINE_DISKS NUMBER
COMPATIBILITY VARCHAR2(60)
DATABASE_COMPATIBILITY VARCHAR2(60)
VOTING_FILES VARCHAR2(1)

SQL> select TOTAL_MB,FREE_MB,VOTING_FILES,ALLOCATION_UNIT_SIZE,BLOCK_SIZE from v$asm_diskgroup;

TOTAL_MB FREE_MB V ALLOCATION_UNIT_SIZE BLOCK_SIZE
———- ———- – ——————– ———-
1953 1557 N 1048576 4096
11445 8947 N 1048576 4096
7814 7484 N 1048576 4096

SQL> COL NAME FORMAT A12
SQL> COL COMPATIBILITY FORMAT A20
SQL> COL DATABASE_COMPATIBILITY FORMAT A20
SQL> SELECT NAME,COMPATIBILITY,DATABASE_COMPATIBILITY from v$asm_diskgroup;

NAME COMPATIBILITY DATABASE_COMPATIBILI
———— ——————– ——————–
CRS 11.2.0.0.0 10.1.0.0.0
DATA 11.2.0.0.0 10.1.0.0.0
FRA 11.2.0.0.0 10.1.0.0.0

[grid@rac2 bin]$ ./sqlplus “/as sysasm”

SQL*Plus: Release 11.2.0.1.0 Production on Thu Dec 13 15:38:42 2012

Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – Production
With the Real Application Clusters and Automatic Storage Management options

SQL> alter diskgroup data set ATTRIBUTE ‘COMPATIBILITY.ASM’=’11.2’;
alter diskgroup data set ATTRIBUTE ‘COMPATIBILITY.ASM’=’11.2’
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15242: could not set attribute COMPATIBILITY.ASM
ORA-15240: attribute name COMPATIBILITY.ASM is invalid
SQL> COL NAME FORMAT A12
SQL> COL COMPATIBILITY FORMAT A20
SQL> COL DATABASE_COMPATIBILITY FORMAT A20
SQL> SELECT NAME,COMPATIBILITY,DATABASE_COMPATIBILITY from v$asm_diskgroup;

NAME COMPATIBILITY DATABASE_COMPATIBILI
———— ——————– ——————–
CRS 11.2.0.0.0 10.1.0.0.0
DATA 11.2.0.0.0 10.1.0.0.0
FRA 11.2.0.0.0 10.1.0.0.0

SQL> alter diskgroup data set ATTRIBUTE ‘COMPATIBLE.RDBMS’=’11.2’;

Diskgroup altered.

SQL> alter diskgroup data set ATTRIBUTE ‘COMPATIBLE.ASM’=’11.2’;

Diskgroup altered.

SQL> SELECT NAME,COMPATIBILITY,DATABASE_COMPATIBILITY from v$asm_diskgroup;

NAME COMPATIBILITY DATABASE_COMPATIBILI
———— ——————– ——————–
CRS 11.2.0.0.0 10.1.0.0.0
DATA 11.2.0.0.0 11.2.0.0.0
FRA 11.2.0.0.0 10.1.0.0.0

SQL> host
[grid@rac2 bin]$

[root@rac2 bin]# cd /raczone/grid_home1/bin/
[root@rac2 bin]# ./ocrconfig -add +DATA
[root@rac2 bin]# ./ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 2768
Available space (kbytes) : 259352
ID : 15574406
Device/File Name : +CRS
Device/File integrity check succeeded
Device/File Name : +DATA
Device/File integrity check succeeded

Device/File not configured

Device/File not configured

Device/File not configured

Cluster registry integrity check succeeded

Logical corruption check succeeded

[root@rac2 bin]#

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