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

ASMCMD utility was introduced in Oracle 10g and offered some basic features for navigation, search, monitoring and management, for full description see the docs here. In Oracle 11gR1 the asmcmd functionality was extended to include ability to backup existing disk groups metadata among other new 11g features, for full information refer to the docs here. In Oracle 11gR2 with the introduction of the ACFS the ASMCMD functionality was further extended see here. In Oracle 11gR2 ASMCMD can be used to perform almost all of the activities that used to be performed from sqlplus prompt previously and both sqlplus and asmcmd can be used interchangeably. In this article I will demo how to backup a disk group using md_backup command and use md_restore to obtain the SQL statements to recreate the disk groups and all the dependencies such as templates, aliases, directories and disk group attributes.

The syntax of md_backup in Oracle 11gR2 is as follow.

ASMCMD> md_backup

usage: md_backup backup_file [-G diskgroup [,diskgroup,…]]

help: help md_backup

ASMCMD>

The syntax of md_restore is as follow.

ASMCMD> md_restore

usage: md_restore backup_file [–silent][–full|–nodg|–newdg -o ‘old_diskgroup:new_diskgroup [,…]’][-S sql_script_file] [-G ‘diskgroup [,diskgroup…]’]

help: help md_restore

Lets first make a backup of all disk groups.

md_backup /tmp/backup_ASM.bcp -G data,dgdup,dgdup1,dgdup2,prim,sec

The backed diskgroup metadata can be directly restored upon failure of the disk or we can have asmcmd generate a script and later use the script to generate the disk groups and all of the dependencies from sqlplus.

md_restore /tmp/backup_ASM.bcp –full -S /tmp/ASM_diskgroup.sql

The file is generated as shown in the annex.

ANNEX


ASMCMD> ls

DATA/

DGDUP/

DGDUP1/

DGDUP2/

PRIM/

SEC/

ASMCMD>

ASMCMD>  md_backup /tmp/backup_ASM.bcp -G data,dgdup,dgdup1,dgdup2,prim,sec

Disk group metadata to be backed up: DATA

Disk group metadata to be backed up: DGDUP

Disk group metadata to be backed up: DGDUP1

Disk group metadata to be backed up: DGDUP2

Disk group metadata to be backed up: PRIM

Disk group metadata to be backed up: SEC

Current alias directory path: RO/ONLINELOG

Current alias directory path: RO/CONTROLFILE

Current alias directory path: RONE/ONLINELOG

Current alias directory path: R1N

Current alias directory path: RACDB/CONTROLFILE

Current alias directory path: ORA1

Current alias directory path: R1N/PARAMETERFILE

Current alias directory path: rac-scan/ASMPARAMETERFILE

Current alias directory path: ORA1/DATAFILE

Current alias directory path: RO

Current alias directory path: ORCL/TEMPFILE

Current alias directory path: RAC0/TEMPFILE

Current alias directory path: RACDB/ONLINELOG

Current alias directory path: RACDB

Current alias directory path: RACDB/DATAFILE

Current alias directory path: RAC0

Current alias directory path: RONE/CONTROLFILE

Current alias directory path: ORCL/CONTROLFILE

Current alias directory path: RONE/PARAMETERFILE

Current alias directory path: RUP/ONLINELOG

Current alias directory path: RO/DATAFILE

Current alias directory path: RACO

Current alias directory path: rac-scan/OCRFILE

Current alias directory path: RUP/CONTROLFILE

Current alias directory path: RAC0/CONTROLFILE

Current alias directory path: RONE/DATAFILE

Current alias directory path: RUP

Current alias directory path: rac-scan

Current alias directory path: ORCL/DATAFILE

Current alias directory path: RONE/TEMPFILE

Current alias directory path: RACDB/TEMPFILE

Current alias directory path: R1N/DATAFILE

Current alias directory path: RACO/TEMPFILE

Current alias directory path: RACO/DATAFILE

Current alias directory path: R1N/TEMPFILE

Current alias directory path: RUP/TEMPFILE

Current alias directory path: RAC0/DATAFILE

Current alias directory path: ORCL

Current alias directory path: RUP/DATAFILE

Current alias directory path: ORCL/ONLINELOG

Current alias directory path: RACO/ONLINELOG

Current alias directory path: RUP/PARAMETERFILE

Current alias directory path: R1N/ONLINELOG

Current alias directory path: RO/TEMPFILE

Current alias directory path: RAC0/PARAMETERFILE

Current alias directory path: RACO/CONTROLFILE

Current alias directory path: RAC0/ONLINELOG

Current alias directory path: RONE

Current alias directory path: R1N/CONTROLFILE

Current alias directory path: RACDB/CONTROLFILE

Current alias directory path: RACDB/DATAFILE

Current alias directory path: RACDB/PARAMETERFILE

Current alias directory path: RACDB/TEMPFILE

Current alias directory path: RACDB/ONLINELOG

Current alias directory path: RACDB

Current alias directory path: rac-scan/OCRFILE

Current alias directory path: rac-scan

Current alias directory path: rac-scan/OCRFILE

Current alias directory path: rac-scan

ASMCMD>

ASMCMD> md_restore  /tmp/backup_ASM.bcp --full -S /tmp/ASM_diskgroup.sql

Current Diskgroup metadata being restored: DATA

Current Diskgroup metadata being restored: DGDUP

Current Diskgroup metadata being restored: DGDUP1

Current Diskgroup metadata being restored: DGDUP2

Current Diskgroup metadata being restored: PRIM

Current Diskgroup metadata being restored: SEC

ASMCMD>

[root@raclinux1 tmp]# cat ASM_diskgroup.sql

create diskgroup DATA EXTERNAL redundancy  disk '/dev/oracleasm/disks/DISK4' name DATA_0003 size 10236M  disk '/dev/oracleasm/disks/DISK2' name DATA_0001 size 10236M  disk '/dev/oracleasm/disks/DISK1' name DATA_0000 size 10236M  disk '/dev/oracleasm/disks/DISK3' name DATA_0002 size 10236M  disk '/dev/oracleasm/disks/DISK5' name DATA_0004 size 10236M attribute 'compatible.asm' = '11.2.0.0.0', 'compatible.rdbms' = '10.1.0.0.0';

alter diskgroup /*ASMCMD AMBR*/DATA set attribute '_._DIRVERSION' = '11.2.0.0.0';

alter diskgroup /*ASMCMD AMBR*/DATA set attribute 'COMPATIBLE.ADVM' = '11.2';

alter diskgroup /*ASMCMD AMBR*/DATA alter template AUTOBACKUP attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/DATA alter template ONLINELOG attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/DATA alter template OCRBACKUP attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/DATA alter template DUMPSET attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/DATA alter template ASM_STALE attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/DATA alter template CONTROLFILE attributes (UNPROTECTED FINE);

alter diskgroup /*ASMCMD AMBR*/DATA alter template FLASHFILE 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 ARCHIVELOG attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/DATA alter template ASMPARAMETERBAKFILE attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/DATA alter template TEMPFILE 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 FLASHBACK attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/DATA alter template DATAFILE attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/DATA alter template ASMPARAMETERFILE attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/DATA alter template BACKUPSET attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/DATA alter template PARAMETERFILE attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/rac-scan';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/R1N';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/ORCL';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/ORA1';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/RONE';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/RACDB';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/RO';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/RACO';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/RAC0';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/RUP';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/rac-scan/ASMPARAMETERFILE';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/R1N/PARAMETERFILE';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/R1N/TEMPFILE';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/R1N/ONLINELOG';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/R1N/CONTROLFILE';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/R1N/DATAFILE';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/RUP/PARAMETERFILE';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/RUP/TEMPFILE';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/RUP/ONLINELOG';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/rac-scan/OCRFILE';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/ORCL/DATAFILE';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/ORCL/CONTROLFILE';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/ORCL/ONLINELOG';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/ORCL/TEMPFILE';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/ORA1/DATAFILE';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/RONE/CONTROLFILE';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/RONE/ONLINELOG';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/RONE/DATAFILE';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/RONE/TEMPFILE';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/RONE/PARAMETERFILE';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/RACDB/CONTROLFILE';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/RACDB/ONLINELOG';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/RACDB/DATAFILE';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/RACDB/TEMPFILE';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/RO/DATAFILE';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/RO/CONTROLFILE';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/RO/ONLINELOG';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/RO/TEMPFILE';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/RACO/DATAFILE';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/RACO/CONTROLFILE';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/RACO/ONLINELOG';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/RACO/TEMPFILE';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/RAC0/DATAFILE';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/RAC0/CONTROLFILE';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/RAC0/ONLINELOG';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/RAC0/TEMPFILE';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/RAC0/PARAMETERFILE';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/RUP/DATAFILE';

alter diskgroup /*ASMCMD AMBR */ DATA add directory '+DATA/RUP/CONTROLFILE';

create diskgroup DGDUP EXTERNAL redundancy  disk '/dev/oracleasm/disks/DISK7' name DGDUP_0002 size 10236M  disk '/dev/oracleasm/disks/DISK8' name DGDUP_0003 size 10236M  disk '/dev/oracleasm/disks/DISK10' name DGDUP_0000 size 10236M  disk '/dev/oracleasm/disks/DISK6' name DGDUP_0001 size 10236M  disk '/dev/oracleasm/disks/DISK9' name DGDUP_0004 size 10236M attribute 'compatible.asm' = '11.2.0.0.0', 'compatible.rdbms' = '10.1.0.0.0';

alter diskgroup /*ASMCMD AMBR*/DGDUP set attribute '_._DIRVERSION' = '11.2.0.0.0';

alter diskgroup /*ASMCMD AMBR*/DGDUP alter template AUTOBACKUP attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/DGDUP alter template ONLINELOG attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/DGDUP alter template OCRBACKUP attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/DGDUP alter template ASMPARAMETERBAKFILE attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/DGDUP alter template ASMPARAMETERFILE attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/DGDUP alter template ASM_STALE attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/DGDUP alter template PARAMETERFILE attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/DGDUP alter template OCRFILE attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/DGDUP alter template CHANGETRACKING attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/DGDUP alter template ARCHIVELOG attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/DGDUP alter template DUMPSET attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/DGDUP alter template TEMPFILE attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/DGDUP alter template XTRANSPORT attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/DGDUP alter template DATAGUARDCONFIG attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/DGDUP alter template FLASHBACK attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/DGDUP alter template DATAFILE attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/DGDUP alter template CONTROLFILE attributes (UNPROTECTED FINE);

alter diskgroup /*ASMCMD AMBR*/DGDUP alter template BACKUPSET attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/DGDUP alter template FLASHFILE attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR */ DGDUP add directory '+DGDUP/RACDB';

alter diskgroup /*ASMCMD AMBR */ DGDUP add directory '+DGDUP/RACDB/PARAMETERFILE';

alter diskgroup /*ASMCMD AMBR */ DGDUP add directory '+DGDUP/RACDB/DATAFILE';

alter diskgroup /*ASMCMD AMBR */ DGDUP add directory '+DGDUP/RACDB/CONTROLFILE';

alter diskgroup /*ASMCMD AMBR */ DGDUP add directory '+DGDUP/RACDB/TEMPFILE';

alter diskgroup /*ASMCMD AMBR */ DGDUP add directory '+DGDUP/RACDB/ONLINELOG';

create diskgroup DGDUP1 HIGH redundancy failgroup DGDUP1_0003 disk '/dev/oracleasm/disks/DISK14' name DGDUP1_0003 size 10236M failgroup DGDUP1_0000 disk '/dev/oracleasm/disks/DISK11' name DGDUP1_0000 size 10236M failgroup DGDUP1_0004 disk '/dev/oracleasm/disks/DISK15' name DGDUP1_0004 size 10236M failgroup DGDUP1_0001 disk '/dev/oracleasm/disks/DISK12' name DGDUP1_0001 size 10236M failgroup DGDUP1_0002 disk '/dev/oracleasm/disks/DISK13' name DGDUP1_0002 size 10236M attribute 'compatible.asm' = '11.2.0.0.0', 'compatible.rdbms' = '10.1.0.0.0';

alter diskgroup /*ASMCMD AMBR*/DGDUP1 set attribute '_._DIRVERSION' = '11.2.0.0.0';

alter diskgroup /*ASMCMD AMBR*/DGDUP1 alter template ONLINELOG attributes (HIGH COARSE);

alter diskgroup /*ASMCMD AMBR*/DGDUP1 alter template XTRANSPORT attributes (HIGH COARSE);

alter diskgroup /*ASMCMD AMBR*/DGDUP1 alter template DUMPSET attributes (HIGH COARSE);

alter diskgroup /*ASMCMD AMBR*/DGDUP1 alter template OCRFILE attributes (HIGH COARSE);

alter diskgroup /*ASMCMD AMBR*/DGDUP1 alter template FLASHBACK attributes (HIGH COARSE);

alter diskgroup /*ASMCMD AMBR*/DGDUP1 alter template CONTROLFILE attributes (HIGH FINE);

alter diskgroup /*ASMCMD AMBR*/DGDUP1 alter template AUTOBACKUP attributes (HIGH COARSE);

alter diskgroup /*ASMCMD AMBR*/DGDUP1 alter template DATAFILE attributes (HIGH COARSE);

alter diskgroup /*ASMCMD AMBR*/DGDUP1 alter template TEMPFILE attributes (HIGH COARSE);

alter diskgroup /*ASMCMD AMBR*/DGDUP1 alter template DATAGUARDCONFIG attributes (HIGH COARSE);

alter diskgroup /*ASMCMD AMBR*/DGDUP1 alter template FLASHFILE attributes (HIGH COARSE);

alter diskgroup /*ASMCMD AMBR*/DGDUP1 alter template ASMPARAMETERFILE attributes (HIGH COARSE);

alter diskgroup /*ASMCMD AMBR*/DGDUP1 alter template ARCHIVELOG attributes (HIGH COARSE);

alter diskgroup /*ASMCMD AMBR*/DGDUP1 alter template BACKUPSET attributes (HIGH COARSE);

alter diskgroup /*ASMCMD AMBR*/DGDUP1 alter template CHANGETRACKING attributes (HIGH COARSE);

alter diskgroup /*ASMCMD AMBR*/DGDUP1 alter template PARAMETERFILE attributes (HIGH COARSE);

alter diskgroup /*ASMCMD AMBR */ DGDUP1 add directory '+DGDUP1/rac-scan';

alter diskgroup /*ASMCMD AMBR */ DGDUP1 add directory '+DGDUP1/rac-scan/OCRFILE';

create diskgroup DGDUP2 EXTERNAL redundancy  disk '/dev/oracleasm/disks/DISK17' name DGDUP2_0000 size 10236M  disk '/dev/oracleasm/disks/DISK20' name DGDUP2_0003 size 10236M  disk '/dev/oracleasm/disks/DISK16' name DGDUP2_0004 size 10236M  disk '/dev/oracleasm/disks/DISK19' name DGDUP2_0002 size 10236M  disk '/dev/oracleasm/disks/DISK18' name DGDUP2_0001 size 10236M attribute 'compatible.asm' = '11.2.0.0.0', 'compatible.rdbms' = '10.1.0.0.0';

alter diskgroup /*ASMCMD AMBR*/DGDUP2 set attribute '_._DIRVERSION' = '11.2.0.0.0';

alter diskgroup /*ASMCMD AMBR*/DGDUP2 alter template DATAGUARDCONFIG attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/DGDUP2 alter template BACKUPSET attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/DGDUP2 alter template CONTROLFILE attributes (UNPROTECTED FINE);

alter diskgroup /*ASMCMD AMBR*/DGDUP2 alter template FLASHBACK attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/DGDUP2 alter template XTRANSPORT attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/DGDUP2 alter template DUMPSET attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/DGDUP2 alter template TEMPFILE attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/DGDUP2 alter template ASMPARAMETERFILE attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/DGDUP2 alter template ONLINELOG attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/DGDUP2 alter template CHANGETRACKING attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/DGDUP2 alter template OCRFILE attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/DGDUP2 alter template FLASHFILE attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/DGDUP2 alter template PARAMETERFILE attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/DGDUP2 alter template DATAFILE attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/DGDUP2 alter template AUTOBACKUP attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/DGDUP2 alter template ARCHIVELOG attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR */ DGDUP2 add directory '+DGDUP2/rac-scan';

alter diskgroup /*ASMCMD AMBR */ DGDUP2 add directory '+DGDUP2/rac-scan/OCRFILE';

create diskgroup PRIM EXTERNAL redundancy  disk '/dev/oracleasm/disks/DISK22' name PRIM_0001 size 10236M  disk '/dev/oracleasm/disks/DISK21' name PRIM_0000 size 10236M attribute 'compatible.asm' = '11.2.0.2.0', 'compatible.rdbms' = '10.1.0.0.0';

alter diskgroup /*ASMCMD AMBR*/PRIM set attribute '_._DIRVERSION' = '11.2.0.2.0';

alter diskgroup /*ASMCMD AMBR*/PRIM set attribute 'COMPATIBLE.ADVM' = '11.2.0.2.0';

alter diskgroup /*ASMCMD AMBR*/PRIM alter template XTRANSPORT attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/PRIM alter template ONLINELOG attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/PRIM alter template DATAGUARDCONFIG attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/PRIM alter template AUTOBACKUP attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/PRIM alter template TEMPFILE attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/PRIM alter template OCRFILE attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/PRIM alter template ARCHIVELOG attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/PRIM alter template DUMPSET attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/PRIM alter template CONTROLFILE attributes (UNPROTECTED FINE);

alter diskgroup /*ASMCMD AMBR*/PRIM alter template BACKUPSET attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/PRIM alter template ASMPARAMETERFILE attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/PRIM alter template FLASHBACK attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/PRIM alter template PARAMETERFILE attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/PRIM alter template FLASHFILE attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/PRIM alter template DATAFILE attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/PRIM alter template CHANGETRACKING attributes (UNPROTECTED COARSE);

create diskgroup SEC EXTERNAL redundancy  disk '/dev/oracleasm/disks/DISK23' name SEC_0000 size 10236M  disk '/dev/oracleasm/disks/DISK25' name SEC_0002 size 10236M  disk '/dev/oracleasm/disks/DISK24' name SEC_0001 size 10236M attribute 'compatible.asm' = '11.2.0.2.0', 'compatible.rdbms' = '10.1.0.0.0';

alter diskgroup /*ASMCMD AMBR*/SEC set attribute '_._DIRVERSION' = '11.2.0.2.0';

alter diskgroup /*ASMCMD AMBR*/SEC set attribute 'COMPATIBLE.ADVM' = '11.2.0.2.0';

alter diskgroup /*ASMCMD AMBR*/SEC alter template BACKUPSET attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/SEC alter template FLASHFILE attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/SEC alter template CHANGETRACKING attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/SEC alter template TEMPFILE attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/SEC alter template ONLINELOG attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/SEC alter template FLASHBACK attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/SEC alter template CONTROLFILE attributes (UNPROTECTED FINE);

alter diskgroup /*ASMCMD AMBR*/SEC alter template DATAGUARDCONFIG attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/SEC alter template ASMPARAMETERFILE attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/SEC alter template DATAFILE attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/SEC alter template OCRFILE attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/SEC alter template XTRANSPORT attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/SEC alter template PARAMETERFILE attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/SEC alter template DUMPSET attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/SEC alter template ARCHIVELOG attributes (UNPROTECTED COARSE);

alter diskgroup /*ASMCMD AMBR*/SEC alter template AUTOBACKUP attributes (UNPROTECTED COARSE);

[root@raclinux1 tmp]#

December 20, 2010 - Posted by gjilevski | oracle

6 Comments »

hello!,I really like your writing very much! share we communicate more approximately your post on AOL?

I need a specialist on this house to unravel my problem.
May be that’s you! Looking forward to see you.

Comment by 2014 keyword research | May 23, 2014 | Reply
This paragraph is genuinely a good one it assists new net users, who are wishing iin favor of
blogging.

Comment by reducing arm pump | May 25, 2014 | Reply
This is a relatively effortless stage that can convey your web-site to a full
new amount of visibility and level of popularity. The hosts of most podcasts include a summary of each episode with
links to each guest’s website. Make sure to undertake meticulous
keyword research for being successful with your online business.

Comment by Jenna | June 6, 2014 | Reply
Je ѕuis tout à faikt d’accord avec vous

Comment by vieille nymphomane | September 24, 2014 | Reply
Jе ѵais te dire que ce n’est guère faux !!!

Comment by cochonne blonde | October 13, 2014 | Reply
Jе suis arrivé sur ce blog par chance et puis je ne le regrette pas !!!

Comment by petite pute | February 4, 2015 | Reply

About

Guenadi Jilevski is a Senior Oracle Professional (OCP 7, 8, 8i, 9i, 10g, 11g, 12c OCE 10gR2 RAC, OCE Oracle RAC 11gR2 and Grid Infrastructure Administrator, Oracle Exadata 11g Certified Implementation Specialist,Oracle GoldenGate 10g/11g Certified Implementation Specialist and OCM 9i, OCM 11g) with more than 20 years of industrial experience in high end Oracle technology starting with Oracle RDBMS version 6 up to 11g. He has been involved with multi platform High Availability Solutions starting with OPS and Veritas and Sun cluster as well as complex multiple node RAC 9i, 10g and 11g implementations on AIX, Linux, Solaris and HP. He has experience in deploying disaster recovery solutions with standby databases compliant to Oracle MAA and third party solutions such as Shareplex and Goldengate. As a former employee of Oracle Corporation Advanced Technology Solutions Consulting Practice in Americas, Guenadi has been involved in multiple visible high end projects for RAC enabling EBS, Peoplesoft, Siebel ERP applications, end to end performance tuning, architectured High Availability and Disaster Recovery solutions to name a few. Presently he is working as A Senior Oracle Consultant in EMEA.

Guenadi Jilevski is Oracle OCP 7, 8, 8i, 9i, 10g, 11g, 12c OCE 10gR2 RAC, OCE Oracle RAC 11gR2 and Grid Infrastructure Administrator, Oracle Exadata 11g Certified Implementation Specialist,Oracle GoldenGate 10g/11g Certified Implementation Specialist and Oracle OCM9i , OCM 11g, Teradata Certified DBA, Informix Certified DBA.

The views expressed on this blog are my own and do not necessarily reflect the views of Current/Past/Future Employers. The views and opinions expressed by visitors on this blog are theirs solely and may not reflect mine.

Archives
Archives
Blog Stats
- 1,021,174 hits
Top Rated
Blogroll
- WordPress.com 0
- WordPress.org 0
Calendar

December 2010

M T W T F S S

« Oct Jan »

1 2 3 4 5

6 7 8 9 10 11 12

13 14 15 16 17 18 19

20 21 22 23 24 25 26

27 28 29 30 31
Search

Search for:
Email Subscription

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 1,109 other followers
OraNA

Guenadi N Jilevski's Oracle BLOG

Oracle RAC, DG, EBS, DR and HA DBA BLOG