Guenadi N Jilevski's Oracle BLOG

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

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

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

6 Comments »

  1. 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

  2. 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

  3. 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

  4. Je ѕuis tout à faikt d’accord avec vous

    Comment by vieille nymphomane | September 24, 2014 | Reply

  5. Jе ѵais te dire que ce n’est guère faux !!!

    Comment by cochonne blonde | October 13, 2014 | Reply

  6. Jе suis arrivé sur ce blog par chance et puis je ne le regrette pas !!!

    Comment by petite pute | February 4, 2015 | Reply


Leave a Reply

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

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: