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]#
6 Comments »
Leave a Reply
-
Archives
- February 2017 (1)
- November 2016 (1)
- October 2016 (1)
- May 2016 (2)
- March 2016 (3)
- December 2014 (2)
- July 2014 (1)
- June 2014 (6)
- May 2014 (5)
- February 2014 (1)
- December 2012 (2)
- November 2012 (8)
-
Categories
-
RSS
Entries RSS
Comments RSS
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.
This paragraph is genuinely a good one it assists new net users, who are wishing iin favor of
blogging.
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.
Je ѕuis tout à faikt d’accord avec vous
Jе ѵais te dire que ce n’est guère faux !!!
Jе suis arrivé sur ce blog par chance et puis je ne le regrette pas !!!