Lokeshaggarwal's DBA

Live the life you love. Love the life you live

ORA-15033 disk belongs to diskgroup


Recently, we have faced one issue while adding disk into the diskgroup.

We have one diskgroup viz. CRS created with “NORMAL” redundancy. Someone in the UNIX team replaced the disk without running “ALTER DISKGROUP” Command.

So, while adding diskgroup, we got the below error:

alter diskgroup CRS add
FAILGROUP CRS01_0000 disk ‘/dev/rhdiskpower98’ rebalance power 11;SQL>   2
alter diskgroup CRS add
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15033: disk ‘/dev/rhdiskpower98’ belongs to diskgroup “CRS”

As the “Alter DiskGroup DATA DROP DISK” command has not been run so, we need to add disk with Force option.

SQL> alter diskgroup CRS add
FAILGROUP CRS01_0000 disk ‘/dev/rhdiskpower98’ force rebalance power 11;

Diskgroup altered.

SQL> SELECT
NVL(a.name, ‘[CANDIDATE]’)      disk_group_name
, b.path                          disk_file_path
, b.name                          disk_file_name
, b.failgroup                     disk_file_fail_group
FROM
v$asm_diskgroup a RIGHT OUTER JOIN v$asm_disk b USING (group_number) where b.path=’/dev/rhdiskpower98′
ORDER BY
a.name;

DISK_GROUP_NAME                          DISK_FILE_PATH                           DISK_FILE_NAME                 DISK_FILE_FAIL_GROUP
—————————————- —————————————- —————————— ——————————
CRS                                    /dev/rhdiskpower98                       CRS01_0000                     CRS01_0000

So, problem can be resolved by using the FORCE clause while adding disk.

Advertisements

February 26, 2016 Posted by | ASM, Uncategorized | Leave a comment

Testing the Media Management API


sbttest can be used to perform a quick test of the media manager.

If sbttest returns 0, then the test ran without error, which means that the media manager is correctly installed and can accept a data stream and return the same data when requested. If sbttest returns a nonzero value, then either the media manager is not installed or it is not configured correctly.

 

Command to run sbttest is :

sbttest test.out -trace sbttest.trace

O/P of the command:

The sbt function pointers are loaded from libobk.a(shr.o) library.
— sbtinit succeeded
— sbtinit (2nd time) succeeded
sbtinit: Media manager supports SBT API version 2.0
sbtinit: Media manager is version 5.0.0.0
sbtinit: vendor description string=Veritas NetBackup for Oracle – Release 6.5 (2010042404)
sbtinit: allocated sbt context area of 8 bytes
sbtinit: proxy copy is supported
— sbtinit2 succeeded
— regular_backup_restore starts …………………………..

 

In case, if it fails then we will get the below error like :

The sbt function pointers are loaded from libobk.so library.
— sbtinit succeeded
— sbtinit (2nd time) succeeded
sbtinit: Media manager supports SBT API version 2.0
sbtinit: Media manager is version 1.1.0.0
sbtinit: vendor description string=Symantec/BackupExec/1.1.0
sbtinit: allocated sbt context area of 8 bytes
MMAPI error from sbtinit2: 7501, BEError(0xe0001005) Backup Exec encountered an unexpected error.

— sbtinit2 failed
you have mail in /var/spool/mail/oracle

 

 

 

December 11, 2015 Posted by | Backup and Recovery, Uncategorized | Leave a comment

PROC-26: Error while accessing the physical storage ASM error AMDU-00204: AMDU-00201:


Hi,

Today, I was facing problem in 11gR2 RAC, after server got restarted, one of the node was not able to startup the clusterware services.When I check OCRCHECK, i got a message:

[root@rac1 bin]# ./ocrcheck

PROT-602: Failed to retrieve data from the cluster registry

PROC-26: Error while accessing the physical storage ASM error [SLOS: cat=8, opn=kgfolclcpi1, dep=204, loc=kgfokge

AMDU-00204: Disk N0003 is in currently mounted diskgroup CRS

AMDU-00201: Disk N0003: ‘ORCL:VOTE1’

[root@rac1 bin]# ./crsctl check crs

CRS-4638: Oracle High Availability Services is online

CRS-4535: Cannot communicate with Cluster Ready Services

CRS-4529: Cluster Synchronization Services is online

CRS-4533: Event Manager is online

[root@rac1 bin]# ./crs_stat -t

CRS-0184: Cannot communicate with the CRS daemon.

But on the another node all the services were successfully running

So ,I tried to find out any error in OCSSD.log,CRSD.log :

 

Getting an error in ocssd.log

2014-01-29 21:10:13.288: [    CSSD][2997357456]clssgmEvtInformation: reqtype (11) cmProc (0x9d02110) client ((nil))
2014-01-29 21:10:13.288: [    CSSD][2997357456]clssgmEvtInformation: reqtype (11) req (0x9c1aa70)
2014-01-29 21:10:13.288: [    CSSD][2997357456]clssnmQueueNotification: type (11) 0x9c1aa70
2014-01-29 21:10:13.999: [    GPnP][3046368960]clsgpnpm_newWiredMsg: [at clsgpnpm.c:633] Msg-reply has soap fault 10 (Operation returned Retry (error CLSGPNP_CALL_AGAIN)) [uri “http://www.grid-pnp.org/2005/12/gpnp-errors#”%5D
2014-01-29 21:10:13.999: [    GPnP][3046368960]clsgpnpm_newWiredMsg: [at clsgpnpm.c:663] Result: (31) CLSGPNP_CALL_AGAIN. Received gpnp meg-reply 0x9cebdb0 with soap fault, reason ‘Operation returned Retry (error CLSGPNP_CALL_AGAIN)'(10) 10
2014-01-29 21:10:13.999: [    GPnP][3046368960]clsgpnpm_receiveMsg: [at clsgpnpm.c:2954] Result: (31) CLSGPNP_CALL_AGAIN. error in gpnp-msg from ‘ipc’ buf=0x9ce9af8
2014-01-29 21:10:13.999: [    GPnP][3046368960]clsgpnpm_exchange: [at clsgpnpm.c:1198] Result: (31) CLSGPNP_CALL_AGAIN. Error soap response from url “ipc://GPNPD_rac1”,msg=0x9cebdb0 rdom=0x9d58c40 try=1/500
@

crsd.log file

{code}
2014-02-03 11:22:40.021: [    GPnP][3046098640]clsgpnpwu_walletfopen: [at clsgpnpwu.c:494] Opened SSO wallet: ‘/raczone/grid_home/gpnp/rac1/wallets/peer/cwallet.sso’
2014-02-03 11:22:40.021: [    GPnP][3046098640]clsgpnp_getCK: [at clsgpnp0.c:1965] Result: (0) CLSGPNP_OK. Get gpnp wallet – provider 1 of 2 (LSKP-FSW(1))
2014-02-03 11:22:40.021: [    GPnP][3046098640]clsgpnp_getCK: [at clsgpnp0.c:1982] Got gpnp security keys (wallet).>
2014-02-03 11:22:40.021: [    GPnP][3046098640]clsgpnp_Init: [at clsgpnp0.c:837] GPnP client pid=5545, tl=3, f=0

2014-02-03 11:22:40.058: [GIPCXCPT][3046098640] gipcShutdownF: skipping shutdown, count 2, from [ clsinet.c : 1732], ret gipcretSuccess (0)

2014-02-03 11:22:40.060: [GIPCXCPT][3046098640] gipcShutdownF: skipping shutdown, count 1, from [ clsgpnp0.c : 1021], ret gipcretSuccess (0)

2014-02-03 11:22:40.069: [  OCRASM][3046098640]proprasmo: Error in open/create file in dg [CRS]

[  OCRASM][3046098640]SLOS : SLOS: cat=7, opn=kgfoAl06, dep=15077, loc=kgfokge

ORA-15077: could not locate ASM instance serving a required diskgroup

2014-02-03 11:22:40.071: [  OCRASM][3046098640]proprasmo: kgfoCheckMount returned [7]

2014-02-03 11:22:40.071: [  OCRASM][3046098640]proprasmo: The ASM instance is down

2014-02-03 11:22:40.071: [  OCRRAW][3046098640]proprioo: Failed to open [+CRS]. Returned proprasmo() with [26]. Marking location as UNAVAILABLE.

2014-02-03 11:22:40.071: [  OCRRAW][3046098640]proprioo: No OCR/OLR devices are usable

2014-02-03 11:22:40.071: [  OCRASM][3046098640]proprasmcl: asmhandle is NULL

2014-02-03 11:22:40.071: [  OCRRAW][3046098640]proprinit: Could not open raw device

2014-02-03 11:22:40.071: [  OCRASM][3046098640]proprasmcl: asmhandle is NULL

2014-02-03 11:22:40.072: [  OCRAPI][3046098640]a_init:16!: Backend init unsuccessful : [26]

2014-02-03 11:22:40.072: [  CRSOCR][3046098640] OCR context init failure.  Error: PROC-26: Error while accessing the physical storage ASM error [SLOS: cat=7, opn=kgfoAl06, dep=15077, loc=kgfokge

ORA-15077: could not locate ASM instance serving a required diskgroup

] [7]

2014-02-03 11:22:40.072: [    CRSD][3046098640][PANIC] CRSD exiting: Could not init OCR, code: 26

2014-02-03 11:22:40.072: [    CRSD][3046098640] Done.
I have also checked using amdu utility:

 

RAC1 were the error is coming up:

[grid@rac1 bin]$ ./asmcmd lsdsk -G DATA

Connected to an idle instance.

[grid@rac1 bin]$ ./amdu -diskstring=”ORCL:*” -dump DATA  -nomap -nodir   | grep HEARTBEAT

AMDU-00204: Disk N0001 is in currently mounted diskgroup DATA

AMDU-00201: Disk N0001: ‘ORCL:DATA1’

** HEARTBEAT DETECTED **

[grid@rac1 bin]$ ./amdu -diskstring=”ORCL:*” -dump VOTE  -nomap -nodir   | grep HEARTBEAT

AMDU-00210: No disks found in diskgroup VOTE

[grid@rac1 bin]$ ./amdu -diskstring=”ORCL:*” -dump FRA  -nomap -nodir   | grep HEARTBEAT

AMDU-00204: Disk N0002 is in currently mounted diskgroup FRA

AMDU-00201: Disk N0002: ‘ORCL:FRA1’

** HEARTBEAT DETECTED **

[grid@rac1 bin]$ ./amdu -diskstring=”ORCL:*” -dump CRS  -nomap -nodir   | grep HEARTBEAT

AMDU-00204: Disk N0003 is in currently mounted diskgroup CRS

AMDU-00201: Disk N0003: ‘ORCL:VOTE1’

** HEARTBEAT DETECTED **

[grid@rac1 bin]$

RAC2 (Here, clusterware is running properly)

ORACLE_SID = [grid] ? +ASM2

The Oracle base for ORACLE_HOME=/raczone/grid_home is /raczone/11.2.0

[grid@rac2 bin]$ ./asmcmd lsdsk -G DATA

Path

ORCL:DATA1

[grid@rac2 bin]$ ./amdu -diskstring=”ORCL:*” -dump DATA  -nomap -nodir   | grep HEARTBEAT

AMDU-00204: Disk N0001 is in currently mounted diskgroup DATA

AMDU-00201: Disk N0001: ‘ORCL:DATA1’

** HEARTBEAT DETECTED **

[grid@rac2 bin]$

[grid@rac2 bin]$ ./amdu -diskstring=”ORCL:*” -dump VOTE  -nomap -nodir   | grep HEARTBEAT

AMDU-00210: No disks found in diskgroup VOTE

[grid@rac2 bin]$ ./amdu -diskstring=”ORCL:*” -dump CRS  -nomap -nodir   | grep HEARTBEAT

AMDU-00204: Disk N0003 is in currently mounted diskgroup CRS

AMDU-00201: Disk N0003: ‘ORCL:VOTE1’

** HEARTBEAT DETECTED **

[grid@rac2 bin]$ ./amdu -diskstring=”ORCL:*” -dump FRA  -nomap -nodir   | grep HEARTBEAT

AMDU-00204: Disk N0002 is in currently mounted diskgroup FRA

AMDU-00201: Disk N0002: ‘ORCL:FRA1’

** HEARTBEAT DETECTED **

So, heartbeat also was not a problem,

When I executed Asmcmd, I got to know that ASM instance was not up,so I tried to startup the instance:

[grid@rac1 bin]$ asmcmd
Connected to an idle instance.

but in rac2, asm instance was up

[grid@rac2 bin]$ asmcmd
ASMCMD> ls
CRS/
DATA/
FRA/

So I have started the instance ,

ASMCMD> startup
ASM instance started

Total System Global Area  284565504 bytes
Fixed Size                  1336036 bytes
Variable Size             258063644 bytes
ASM Cache                  25165824 bytes
ASM diskgroups mounted
ASMCMD> ls
CRS/
DATA/
FRA/
ASMCMD> cd CRS
ASMCMD> ls
scan-cluster/
ASMCMD> cd sc*
ASMCMD> ls
ASMPARAMETERFILE/
OCRFILE/
ASMCMD> cd OCR*
ASMCMD> ls -l
Type     Redund  Striped  Time             Sys  Name
OCRFILE  UNPROT  COARSE   FEB 03 15:00:00  Y    REGISTRY.255.837088345
ASMCMD>
ASMCMD> exit
[grid@rac1 bin]$ ./ocrcheck
Status of Oracle Cluster Registry is as follows :
Version                  :          3
Total space (kbytes)     :     262120
Used space (kbytes)      :       2800
Available space (kbytes) :     259320
ID                       : 1486492518
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 bypassed due to non-privileged user

[grid@rac1 bin]$ exit
logout

[root@rac1 bin]# ./crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
[root@rac1 bin]# ./crs_stat -t
Name           Type           Target    State     Host
————————————————————
ora.CRS.dg     ora….up.type ONLINE    ONLINE    rac1
ora.DATA.dg    ora….up.type ONLINE    ONLINE    rac1
ora.FRA.dg     ora….up.type ONLINE    ONLINE    rac1
ora….ER.lsnr ora….er.type ONLINE    ONLINE    rac1
ora….N1.lsnr ora….er.type ONLINE    ONLINE    rac1
ora….N2.lsnr ora….er.type ONLINE    ONLINE    rac2
ora….N3.lsnr ora….er.type ONLINE    ONLINE    rac2
ora.asm        ora.asm.type   ONLINE    ONLINE    rac1
ora.dev.db     ora….se.type ONLINE    ONLINE    rac2
ora.eons       ora.eons.type  ONLINE    ONLINE    rac1
ora.gsd        ora.gsd.type   OFFLINE   OFFLINE
ora….network ora….rk.type ONLINE    ONLINE    rac1
ora.oc4j       ora.oc4j.type  OFFLINE   OFFLINE
ora.ons        ora.ons.type   ONLINE    ONLINE    rac1
ora….SM1.asm application    ONLINE    ONLINE    rac1
ora….C1.lsnr application    ONLINE    ONLINE    rac1
ora.rac1.gsd   application    OFFLINE   OFFLINE
ora.rac1.ons   application    ONLINE    ONLINE    rac1
ora.rac1.vip   ora….t1.type ONLINE    ONLINE    rac1
ora….SM2.asm application    ONLINE    ONLINE    rac2
ora….C2.lsnr application    ONLINE    ONLINE    rac2
ora.rac2.gsd   application    OFFLINE   OFFLINE
ora.rac2.ons   application    ONLINE    ONLINE    rac2
ora.rac2.vip   ora….t1.type ONLINE    ONLINE    rac2
ora….ry.acfs ora….fs.type ONLINE    ONLINE    rac1
ora.scan1.vip  ora….ip.type ONLINE    ONLINE    rac1
ora.scan2.vip  ora….ip.type ONLINE    ONLINE    rac2
ora.scan3.vip  ora….ip.type ONLINE    ONLINE    rac2
[root@rac1 bin]# ./crs_stat -t|grep OFFLINE
ora.gsd        ora.gsd.type   OFFLINE   OFFLINE
ora.oc4j       ora.oc4j.type  OFFLINE   OFFLINE
ora.rac1.gsd   application    OFFLINE   OFFLINE
ora.rac2.gsd   application    OFFLINE   OFFLINE
[root@rac1 bin]#
[root@rac1 bin]#

And now all the services are now successfully runinng.

 

February 3, 2014 Posted by | RAC | Leave a comment

Oracle Database 12c installation steps


In the below screen shots, we can see the installation steps of Oracle 12c database:

Oracle database 12c installation steps

Oracle database 12c installation steps

2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 23

June 27, 2013 Posted by | 12c Database | 1 Comment

Auto start of Golden Gate after DB server reboots


One can use BOOTDELAYMINUTES parameter in manager parameter file,

BOOTDELAYMINUTES parameter on a Windows system is to delay the activities that Manager performs when it starts, such as executing parameters or autostart of extract and replicat processes.

For example, BOOTDELAYMINUTES can be used to delay AUTOSTART parameters until database services are started.

Specify BOOTDELAYMINUTES before other parameter entries. This parameter only supports Windows.

Example:

GGSCI (rssb) 3> view params mgr

PORT 7808

BOOTDELAYMINUTES 3

USERID gg,PASSWORD gg

AUTOSTART EXTRACT EXTLINUX

PURGEOLDEXTRACTS D:\lok\Stud_Mat\Golden_Gate\gg_sw\Source\dirdat\ex, USECHECKPOI NTS

 

 

 

 

 

April 2, 2013 Posted by | Golden Gate | Leave a comment

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

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