oracle 11gR2 asmcmd 工具增加md_backup和md_restore命令
oracle 11gR2 版本增加對磁碟組後設資料備份與恢復的命令
md_backup :Creates a backup of the metadata of mounted disk groups.
md_restore :Restores disk groups from a backup of the metadata.
md_backup :
Syntax and Description
md_backup backup_file
[-G 'diskgroup [,diskgroup,...]']
Example 12–38 Using md_backup
ASMCMD [+] > md_backup /tmp/dgbackup20090716
ASMCMD [+] > md_backup /tmp/dgbackup20090716 -G data,fra
Disk group metadata to be backed up: DATA
Disk group metadata to be backed up: FRA
Current alias directory path: ASM/ASMPARAMETERFILE
Current alias directory path: ORCL/DATAFILE
Current alias directory path: ORCL/TEMPFILE
Current alias directory path: ORCL/CONTROLFILE
Current alias directory path: ORCL/PARAMETERFILE
Current alias directory path: ASM
Current alias directory path: ORCL/ONLINELOG
Current alias directory path: ORCL
Current alias directory path: ORCL/CONTROLFILE
Current alias directory path: ORCL/ARCHIVELOG/2009_07_13
Current alias directory path: ORCL/BACKUPSET/2009_07_14
Current alias directory path: ORCL/ARCHIVELOG/2009_07_14
Current alias directory path: ORCL
Current alias directory path: ORCL/DATAFILE
Current alias directory path: ORCL/ARCHIVELOG
Current alias directory path: ORCL/BACKUPSET
Current alias directory path: ORCL/ONLINELOG
md_restore :
Syntax and Description
md_restore backup_file [--silent]
[--full|--nodg|--newdg -o 'old_diskgroup:new_diskgroup [,...]']
[-S sql_script_file] [-G 'diskgroup [,diskgroup...]']
Example
The first example restores the disk group data from the backup script. and creates a
copy. The second example takes an existing disk group data and restores its metadata.
The third example restores disk group data completely but the new disk group that is
created is called data2. The fourth example restores from the backup file after
applying the overrides defined in the override.sql script. file.
Example 12–39 Using md_restore
ASMCMD [+] > md_restore –-full –G data –-silent /tmp/dgbackup20090714
ASMCMD [+] > md_restore –-nodg –G data –-silent /tmp/dgbackup20090714
ASMCMD [+] > md_restore –-newdg -o 'data:data2' --silent /tmp/dgbackup20090714
ASMCMD [+] > md_restore -S override.sql --silent /tmp/dgbackup20090714
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7199859/viewspace-661716/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle 11gR2 asmcmd工具增加 cp命令OracleASM
- 【ASM】ASMCMD 之md_backup,md_restore介紹ASMREST
- 11g asm md_backup md_restoreASMREST
- Oracle ASMCMD命令參考OracleASM
- oracle 11.2 版本 asmcmd 針對 spfile 引數檔案增加的命令OracleASM
- ASM命令列管理工具asmcmdASM命令列
- ASMCMD命令ASM
- 【asmcmd】使用asmcmd工具管理ASMASM
- ORACLE 11gr2 ASM redo log 增加OracleASM
- ASM工具asmcmdASM
- asmcmd命令學習ASM
- 【ASM】ASMCMD cp 命令ASM
- asmcmd命令用法教程ASM
- oracle 11g md_backup md_restor命令使用方法OracleREST
- oracle asm asmcmdOracleASM
- ASMCMD中的各個命令ASM
- asmcmd的cp命令小bugASM
- Oracle RAC 常用維護工具和命令Oracle
- asmcmd工具的詳細介紹ASM
- oracle 11gR2 amdu 工具可以直接使用Oracle
- oracle 11gR2 RAC crsctl 命令的增強Oracle
- Oracle ASM使用asmcmd中的cp命令來執行遠端複製OracleASM
- oracle 11gR2 新增deinstall命令來解除安裝grid和databaseOracleDatabase
- 【轉載】Oracle RAC 常用維護工具和命令Oracle
- grid使用者asmcmd命令相關ASM
- 學習ASM技術(六)-- ASMCMD命令列ASM命令列
- oracle 11g rac asmcmd du 命令不顯示的一個情況OracleASM
- OCP(11g)------> ASM Command-Line Utility (ASMCMD)和 使用 ASMCMDASM
- asmcmdASM
- asmcmd lsdsk和lsdg檢視asmdisk和asmdiskgroupASM
- 管理Oracle RAC工具及命令Oracle
- oracle 11gR2 安裝時增加修改作業系統引數指令碼Oracle作業系統指令碼
- 使用 ASMCMD 工具管理ASM目錄及檔案ASM
- Oracle 12C ASM asmcmd amdu_extractOracleASM
- ASMCMD - cpASM
- 使用asmcmdASM
- ASMCMD命令複製檔案報錯ORA-15046ASM
- oracle刪除表欄位和oracle表增加欄位Oracle