Вы здесь

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

ASMCMD утилита была введена в Oracle 10g и предлагает некоторые основные возможности для навигации, поиска, мониторинга и управления, для полного описания смотрите документацию здесь .

В Oracle 11gR1 ASMCMD функциональность была расширена, чтобы включить возможность резервного копирования существующих групп дисков метаданных среди других новых функций 11g, для полной информации сослаться на документы здесь .

В Oracle 11gR2 с введением ACFS функциональность ASMCMD был продлен посмотреть здесь .

В Oracle 11gR2 ASMCMD может быть использован для выполнения почти всех видов деятельности, которые ранее проводились с Sqlplus строке ранее, и оба SQLPLUS и ASMCMD могут быть использованы как взаимозаменяемые. В этой статье показано , как резервное копирование диска группы с помощью команды md_backup и использовать md_restore можно использовать для воссоздания групп дисков и все зависимости, такие как шаблоны, псевдонимов, каталогов и дисков группы атрибутов.

Синтаксис md_backup в Oracle 11gR2 является следующим.

ASMCMD> md_backup

использем: 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

Сперва сделаем бекап всех дисковых груп

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

Бекапированные метаданные дисковой группы могут быть непосредственно восстановлен после сбоя диска или мы можем сохранить в ASMCMD генерированый скрипт, а потом используйте скрипт для генерации групп дисков в SQLPLUS.

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

пример ниже

ASMCMD>ls
DATA/
DGDUP/
DGDUP1/
DGDUP2/
PRIM/
SEC/
ASMCMD>
ASMCMD>md_backup/tmp/backup_ASM.bcp-Gdata,dgdup,dgdup1,dgdup2,prim,sec
Diskgroupmetadatatobebackedup:DATA
Diskgroupmetadatatobebackedup:DGDUP
Diskgroupmetadatatobebackedup:DGDUP1
Diskgroupmetadatatobebackedup:DGDUP2
Diskgroupmetadatatobebackedup:PRIM
Diskgroupmetadatatobebackedup:SEC
Currentaliasdirectorypath:RO/ONLINELOG
Currentaliasdirectorypath:RO/CONTROLFILE
Currentaliasdirectorypath:RONE/ONLINELOG
Currentaliasdirectorypath:R1N
Currentaliasdirectorypath:RACDB/CONTROLFILE
Currentaliasdirectorypath:ORA1
Currentaliasdirectorypath:R1N/PARAMETERFILE
Currentaliasdirectorypath:rac-scan/ASMPARAMETERFILE
Currentaliasdirectorypath:ORA1/DATAFILE
Currentaliasdirectorypath:RO
Currentaliasdirectorypath:ORCL/TEMPFILE
Currentaliasdirectorypath:RAC0/TEMPFILE
Currentaliasdirectorypath:RACDB/ONLINELOG
Currentaliasdirectorypath:RACDB
Currentaliasdirectorypath:RACDB/DATAFILE
Currentaliasdirectorypath:RAC0
Currentaliasdirectorypath:RONE/CONTROLFILE
Currentaliasdirectorypath:ORCL/CONTROLFILE
Currentaliasdirectorypath:RONE/PARAMETERFILE
Currentaliasdirectorypath:RUP/ONLINELOG
Currentaliasdirectorypath:RO/DATAFILE
Currentaliasdirectorypath:RACO
Currentaliasdirectorypath:rac-scan/OCRFILE
Currentaliasdirectorypath:RUP/CONTROLFILE
Currentaliasdirectorypath:RAC0/CONTROLFILE
Currentaliasdirectorypath:RONE/DATAFILE
Currentaliasdirectorypath:RUP
Currentaliasdirectorypath:rac-scan
Currentaliasdirectorypath:ORCL/DATAFILE
Currentaliasdirectorypath:RONE/TEMPFILE
Currentaliasdirectorypath:RACDB/TEMPFILE
Currentaliasdirectorypath:R1N/DATAFILE
Currentaliasdirectorypath:RACO/TEMPFILE
Currentaliasdirectorypath:RACO/DATAFILE
Currentaliasdirectorypath:R1N/TEMPFILE
Currentaliasdirectorypath:RUP/TEMPFILE
Currentaliasdirectorypath:RAC0/DATAFILE
Currentaliasdirectorypath:ORCL
Currentaliasdirectorypath:RUP/DATAFILE
Currentaliasdirectorypath:ORCL/ONLINELOG
Currentaliasdirectorypath:RACO/ONLINELOG
Currentaliasdirectorypath:RUP/PARAMETERFILE
Currentaliasdirectorypath:R1N/ONLINELOG
Currentaliasdirectorypath:RO/TEMPFILE
Currentaliasdirectorypath:RAC0/PARAMETERFILE
Currentaliasdirectorypath:RACO/CONTROLFILE
Currentaliasdirectorypath:RAC0/ONLINELOG
Currentaliasdirectorypath:RONE
Currentaliasdirectorypath:R1N/CONTROLFILE
Currentaliasdirectorypath:RACDB/CONTROLFILE
Currentaliasdirectorypath:RACDB/DATAFILE
Currentaliasdirectorypath:RACDB/PARAMETERFILE
Currentaliasdirectorypath:RACDB/TEMPFILE
Currentaliasdirectorypath:RACDB/ONLINELOG
Currentaliasdirectorypath:RACDB
Currentaliasdirectorypath:rac-scan/OCRFILE
Currentaliasdirectorypath:rac-scan
Currentaliasdirectorypath:rac-scan/OCRFILE
Currentaliasdirectorypath:rac-scan
ASMCMD>
ASMCMD>md_restore/tmp/backup_ASM.bcp--full-S/tmp/ASM_diskgroup.sql
CurrentDiskgroupmetadatabeingrestored:DATA
CurrentDiskgroupmetadatabeingrestored:DGDUP
CurrentDiskgroupmetadatabeingrestored:DGDUP1
CurrentDiskgroupmetadatabeingrestored:DGDUP2
CurrentDiskgroupmetadatabeingrestored:PRIM
CurrentDiskgroupmetadatabeingrestored:SEC
ASMCMD>
[root@raclinux1tmp]#catASM_diskgroup.sql
creatediskgroupDATAEXTERNALredundancydisk'/dev/oracleasm/disks/DISK4'nameDATA_0003size10236Mdisk'/dev/oracleasm/disks/DISK2'nameDATA_0001size10236Mdisk'/dev/oracleasm/disks/DISK1'nameDATA_0000size10236Mdisk'/dev/oracleasm/disks/DISK3'nameDATA_0002size10236Mdisk'/dev/oracleasm/disks/DISK5'nameDATA_0004size10236Mattribute'compatible.asm'='11.2.0.0.0','compatible.rdbms'='10.1.0.0.0';
alterdiskgroup/*ASMCMDAMBR*/DATAsetattribute'_._DIRVERSION'='11.2.0.0.0';
alterdiskgroup/*ASMCMDAMBR*/DATAsetattribute'COMPATIBLE.ADVM'='11.2';
alterdiskgroup/*ASMCMDAMBR*/DATAaltertemplateAUTOBACKUPattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DATAaltertemplateONLINELOGattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DATAaltertemplateOCRBACKUPattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DATAaltertemplateDUMPSETattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DATAaltertemplateASM_STALEattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DATAaltertemplateCONTROLFILEattributes(UNPROTECTEDFINE);
alterdiskgroup/*ASMCMDAMBR*/DATAaltertemplateFLASHFILEattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DATAaltertemplateOCRFILEattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DATAaltertemplateCHANGETRACKINGattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DATAaltertemplateARCHIVELOGattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DATAaltertemplateASMPARAMETERBAKFILEattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DATAaltertemplateTEMPFILEattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DATAaltertemplateXTRANSPORTattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DATAaltertemplateDATAGUARDCONFIGattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DATAaltertemplateFLASHBACKattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DATAaltertemplateDATAFILEattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DATAaltertemplateASMPARAMETERFILEattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DATAaltertemplateBACKUPSETattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DATAaltertemplatePARAMETERFILEattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/rac-scan';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/R1N';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/ORCL';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/ORA1';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/RONE';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/RACDB';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/RO';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/RACO';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/RAC0';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/RUP';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/rac-scan/ASMPARAMETERFILE';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/R1N/PARAMETERFILE';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/R1N/TEMPFILE';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/R1N/ONLINELOG';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/R1N/CONTROLFILE';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/R1N/DATAFILE';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/RUP/PARAMETERFILE';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/RUP/TEMPFILE';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/RUP/ONLINELOG';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/rac-scan/OCRFILE';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/ORCL/DATAFILE';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/ORCL/CONTROLFILE';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/ORCL/ONLINELOG';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/ORCL/TEMPFILE';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/ORA1/DATAFILE';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/RONE/CONTROLFILE';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/RONE/ONLINELOG';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/RONE/DATAFILE';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/RONE/TEMPFILE';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/RONE/PARAMETERFILE';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/RACDB/CONTROLFILE';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/RACDB/ONLINELOG';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/RACDB/DATAFILE';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/RACDB/TEMPFILE';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/RO/DATAFILE';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/RO/CONTROLFILE';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/RO/ONLINELOG';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/RO/TEMPFILE';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/RACO/DATAFILE';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/RACO/CONTROLFILE';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/RACO/ONLINELOG';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/RACO/TEMPFILE';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/RAC0/DATAFILE';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/RAC0/CONTROLFILE';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/RAC0/ONLINELOG';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/RAC0/TEMPFILE';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/RAC0/PARAMETERFILE';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/RUP/DATAFILE';
alterdiskgroup/*ASMCMDAMBR*/DATAadddirectory'+DATA/RUP/CONTROLFILE';
creatediskgroupDGDUPEXTERNALredundancydisk'/dev/oracleasm/disks/DISK7'nameDGDUP_0002size10236Mdisk'/dev/oracleasm/disks/DISK8'nameDGDUP_0003size10236Mdisk'/dev/oracleasm/disks/DISK10'nameDGDUP_0000size10236Mdisk'/dev/oracleasm/disks/DISK6'nameDGDUP_0001size10236Mdisk'/dev/oracleasm/disks/DISK9'nameDGDUP_0004size10236Mattribute'compatible.asm'='11.2.0.0.0','compatible.rdbms'='10.1.0.0.0';
alterdiskgroup/*ASMCMDAMBR*/DGDUPsetattribute'_._DIRVERSION'='11.2.0.0.0';
alterdiskgroup/*ASMCMDAMBR*/DGDUPaltertemplateAUTOBACKUPattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUPaltertemplateONLINELOGattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUPaltertemplateOCRBACKUPattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUPaltertemplateASMPARAMETERBAKFILEattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUPaltertemplateASMPARAMETERFILEattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUPaltertemplateASM_STALEattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUPaltertemplatePARAMETERFILEattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUPaltertemplateOCRFILEattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUPaltertemplateCHANGETRACKINGattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUPaltertemplateARCHIVELOGattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUPaltertemplateDUMPSETattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUPaltertemplateTEMPFILEattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUPaltertemplateXTRANSPORTattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUPaltertemplateDATAGUARDCONFIGattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUPaltertemplateFLASHBACKattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUPaltertemplateDATAFILEattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUPaltertemplateCONTROLFILEattributes(UNPROTECTEDFINE);
alterdiskgroup/*ASMCMDAMBR*/DGDUPaltertemplateBACKUPSETattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUPaltertemplateFLASHFILEattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUPadddirectory'+DGDUP/RACDB';
alterdiskgroup/*ASMCMDAMBR*/DGDUPadddirectory'+DGDUP/RACDB/PARAMETERFILE';
alterdiskgroup/*ASMCMDAMBR*/DGDUPadddirectory'+DGDUP/RACDB/DATAFILE';
alterdiskgroup/*ASMCMDAMBR*/DGDUPadddirectory'+DGDUP/RACDB/CONTROLFILE';
alterdiskgroup/*ASMCMDAMBR*/DGDUPadddirectory'+DGDUP/RACDB/TEMPFILE';
alterdiskgroup/*ASMCMDAMBR*/DGDUPadddirectory'+DGDUP/RACDB/ONLINELOG';
creatediskgroupDGDUP1HIGHredundancyfailgroupDGDUP1_0003disk'/dev/oracleasm/disks/DISK14'nameDGDUP1_0003size10236MfailgroupDGDUP1_0000disk'/dev/oracleasm/disks/DISK11'nameDGDUP1_0000size10236MfailgroupDGDUP1_0004disk'/dev/oracleasm/disks/DISK15'nameDGDUP1_0004size10236MfailgroupDGDUP1_0001disk'/dev/oracleasm/disks/DISK12'nameDGDUP1_0001size10236MfailgroupDGDUP1_0002disk'/dev/oracleasm/disks/DISK13'nameDGDUP1_0002size10236Mattribute'compatible.asm'='11.2.0.0.0','compatible.rdbms'='10.1.0.0.0';
alterdiskgroup/*ASMCMDAMBR*/DGDUP1setattribute'_._DIRVERSION'='11.2.0.0.0';
alterdiskgroup/*ASMCMDAMBR*/DGDUP1altertemplateONLINELOGattributes(HIGHCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUP1altertemplateXTRANSPORTattributes(HIGHCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUP1altertemplateDUMPSETattributes(HIGHCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUP1altertemplateOCRFILEattributes(HIGHCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUP1altertemplateFLASHBACKattributes(HIGHCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUP1altertemplateCONTROLFILEattributes(HIGHFINE);
alterdiskgroup/*ASMCMDAMBR*/DGDUP1altertemplateAUTOBACKUPattributes(HIGHCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUP1altertemplateDATAFILEattributes(HIGHCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUP1altertemplateTEMPFILEattributes(HIGHCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUP1altertemplateDATAGUARDCONFIGattributes(HIGHCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUP1altertemplateFLASHFILEattributes(HIGHCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUP1altertemplateASMPARAMETERFILEattributes(HIGHCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUP1altertemplateARCHIVELOGattributes(HIGHCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUP1altertemplateBACKUPSETattributes(HIGHCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUP1altertemplateCHANGETRACKINGattributes(HIGHCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUP1altertemplatePARAMETERFILEattributes(HIGHCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUP1adddirectory'+DGDUP1/rac-scan';
alterdiskgroup/*ASMCMDAMBR*/DGDUP1adddirectory'+DGDUP1/rac-scan/OCRFILE';
creatediskgroupDGDUP2EXTERNALredundancydisk'/dev/oracleasm/disks/DISK17'nameDGDUP2_0000size10236Mdisk'/dev/oracleasm/disks/DISK20'nameDGDUP2_0003size10236Mdisk'/dev/oracleasm/disks/DISK16'nameDGDUP2_0004size10236Mdisk'/dev/oracleasm/disks/DISK19'nameDGDUP2_0002size10236Mdisk'/dev/oracleasm/disks/DISK18'nameDGDUP2_0001size10236Mattribute'compatible.asm'='11.2.0.0.0','compatible.rdbms'='10.1.0.0.0';
alterdiskgroup/*ASMCMDAMBR*/DGDUP2setattribute'_._DIRVERSION'='11.2.0.0.0';
alterdiskgroup/*ASMCMDAMBR*/DGDUP2altertemplateDATAGUARDCONFIGattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUP2altertemplateBACKUPSETattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUP2altertemplateCONTROLFILEattributes(UNPROTECTEDFINE);
alterdiskgroup/*ASMCMDAMBR*/DGDUP2altertemplateFLASHBACKattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUP2altertemplateXTRANSPORTattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUP2altertemplateDUMPSETattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUP2altertemplateTEMPFILEattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUP2altertemplateASMPARAMETERFILEattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUP2altertemplateONLINELOGattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUP2altertemplateCHANGETRACKINGattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUP2altertemplateOCRFILEattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUP2altertemplateFLASHFILEattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUP2altertemplatePARAMETERFILEattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUP2altertemplateDATAFILEattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUP2altertemplateAUTOBACKUPattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUP2altertemplateARCHIVELOGattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/DGDUP2adddirectory'+DGDUP2/rac-scan';
alterdiskgroup/*ASMCMDAMBR*/DGDUP2adddirectory'+DGDUP2/rac-scan/OCRFILE';
creatediskgroupPRIMEXTERNALredundancydisk'/dev/oracleasm/disks/DISK22'namePRIM_0001size10236Mdisk'/dev/oracleasm/disks/DISK21'namePRIM_0000size10236Mattribute'compatible.asm'='11.2.0.2.0','compatible.rdbms'='10.1.0.0.0';
alterdiskgroup/*ASMCMDAMBR*/PRIMsetattribute'_._DIRVERSION'='11.2.0.2.0';
alterdiskgroup/*ASMCMDAMBR*/PRIMsetattribute'COMPATIBLE.ADVM'='11.2.0.2.0';
alterdiskgroup/*ASMCMDAMBR*/PRIMaltertemplateXTRANSPORTattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/PRIMaltertemplateONLINELOGattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/PRIMaltertemplateDATAGUARDCONFIGattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/PRIMaltertemplateAUTOBACKUPattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/PRIMaltertemplateTEMPFILEattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/PRIMaltertemplateOCRFILEattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/PRIMaltertemplateARCHIVELOGattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/PRIMaltertemplateDUMPSETattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/PRIMaltertemplateCONTROLFILEattributes(UNPROTECTEDFINE);
alterdiskgroup/*ASMCMDAMBR*/PRIMaltertemplateBACKUPSETattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/PRIMaltertemplateASMPARAMETERFILEattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/PRIMaltertemplateFLASHBACKattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/PRIMaltertemplatePARAMETERFILEattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/PRIMaltertemplateFLASHFILEattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/PRIMaltertemplateDATAFILEattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/PRIMaltertemplateCHANGETRACKINGattributes(UNPROTECTEDCOARSE);
creatediskgroupSECEXTERNALredundancydisk'/dev/oracleasm/disks/DISK23'nameSEC_0000size10236Mdisk'/dev/oracleasm/disks/DISK25'nameSEC_0002size10236Mdisk'/dev/oracleasm/disks/DISK24'nameSEC_0001size10236Mattribute'compatible.asm'='11.2.0.2.0','compatible.rdbms'='10.1.0.0.0';
alterdiskgroup/*ASMCMDAMBR*/SECsetattribute'_._DIRVERSION'='11.2.0.2.0';
alterdiskgroup/*ASMCMDAMBR*/SECsetattribute'COMPATIBLE.ADVM'='11.2.0.2.0';
alterdiskgroup/*ASMCMDAMBR*/SECaltertemplateBACKUPSETattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/SECaltertemplateFLASHFILEattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/SECaltertemplateCHANGETRACKINGattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/SECaltertemplateTEMPFILEattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/SECaltertemplateONLINELOGattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/SECaltertemplateFLASHBACKattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/SECaltertemplateCONTROLFILEattributes(UNPROTECTEDFINE);
alterdiskgroup/*ASMCMDAMBR*/SECaltertemplateDATAGUARDCONFIGattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/SECaltertemplateASMPARAMETERFILEattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/SECaltertemplateDATAFILEattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/SECaltertemplateOCRFILEattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/SECaltertemplateXTRANSPORTattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/SECaltertemplatePARAMETERFILEattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/SECaltertemplateDUMPSETattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/SECaltertemplateARCHIVELOGattributes(UNPROTECTEDCOARSE);
alterdiskgroup/*ASMCMDAMBR*/SECaltertemplateAUTOBACKUPattributes(UNPROTECTEDCOARSE);
[root@raclinux1tmp]#

Menu: 

Post new comment

Filtered HTML

  • Адреса страниц и электронной почты автоматически преобразуются в ссылки.
  • Разрешённые HTML-теги: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Строки и параграфы переносятся автоматически.

Plain text

  • HTML-теги не обрабатываются и показываются как обычный текст
  • Адреса страниц и электронной почты автоматически преобразуются в ссылки.
  • Строки и параграфы переносятся автоматически.
CAPTCHA
Этот вопрос задается для того, чтобы выяснить, являетесь ли Вы человеком или представляете из себя автоматическую спам-рассылку.
7 + 10 =
Решите эту простую математическую задачу и введите результат. Например, для 1+3, введите 4.