本篇内容介绍了“怎么将RMAN备份文件放到ASM中”的有关知识，在实际案例的操作过程中，不少人都会遇到这样的困境，接下来就让小编带领大家学习一下如何处理这些情况吧！希望大家仔细阅读，能够学有所成！

一、问题描述

此次，我们希望将RMAN备份出来的文件放到ASM当中存储，这个操作不太难，就是正常的RMAN脚本，将format输出到正确的磁盘组就好。

二、实践

1.在磁盘组中建立目录

[grid@sam1~]$asmcmd-pASMCMD[+]>cd+flashbackASMCMD[+flashback]>mkdirbackupASMCMD[+flashback]>lsPROD/backup/cluster/

2.准备备份脚本

run{allocatechannelch2typedisk;allocatechannelch3typedisk;backupascompressedbackupsetdatabaseformat'+FLASHBACK/backup/db_%T_%U.bak'plusarchivelogformat'+FLASHBACK/backup/arch_%T_%U.bak';backupcurrentcontrolfileformat'+FLASHBACK//backup/ctl_%T_%U.bak';releasechannelch2;releasechannelch3;}

3.RAMN执行脚本

[oracle@sam1~]$rmantarget/RecoveryManager:Release11.2.0.3.0-ProductiononWedFeb2604:26:002020Copyright(c)1982,2011,Oracleand/oritsaffiliates.Allrightsreserved.connectedtotargetdatabase:PROD(DBID=285149356)RMAN>run{allocatechannelch2typedisk;allocatechannelch3typedisk;2>3>4>backupascompressedbackupsetdatabaseformat'+FLASHBACK/backup/db_%T_%U.bak'plusarchivelog5>format'+FLASHBACK/backup/arch_%T_%U.bak';6>backupcurrentcontrolfileformat'+FLASHBACK//backup/ctl_%T_%U.bak';7>releasechannelch2;releasechannelch3;8>9>}allocatedchannel:ch2channelch2:SID=29instance=PROD1devicetype=DISKallocatedchannel:ch3channelch3:SID=266instance=PROD1devicetype=DISKStartingbackupat26-FEB-20currentlogarchivedchannelch2:startingcompressedarchivedlogbackupsetchannelch2:specifyingarchivedlog(s)inbackupsetinputarchivedlogthread=2sequence=48RECID=4STAMP=1032423541inputarchivedlogthread=1sequence=92RECID=1STAMP=1032421894inputarchivedlogthread=1sequence=93RECID=2STAMP=1032423466inputarchivedlogthread=1sequence=94RECID=3STAMP=1032423539inputarchivedlogthread=1sequence=95RECID=5STAMP=1032429063inputarchivedlogthread=2sequence=49RECID=7STAMP=1033175617channelch2:startingpiece1at26-FEB-20channelch3:startingcompressedarchivedlogbackupsetchannelch3:specifyingarchivedlog(s)inbackupsetinputarchivedlogthread=1sequence=96RECID=6STAMP=1032429064inputarchivedlogthread=2sequence=50RECID=8STAMP=1033175617inputarchivedlogthread=1sequence=97RECID=11STAMP=1033175627inputarchivedlogthread=2sequence=51RECID=9STAMP=1033175623inputarchivedlogthread=2sequence=52RECID=10STAMP=1033175623inputarchivedlogthread=1sequence=98RECID=12STAMP=1033176208inputarchivedlogthread=1sequence=99RECID=13STAMP=1033176251inputarchivedlogthread=1sequence=100RECID=14STAMP=1033188448inputarchivedlogthread=1sequence=101RECID=16STAMP=1033189715inputarchivedlogthread=2sequence=53RECID=15STAMP=1033189715inputarchivedlogthread=2sequence=54RECID=17STAMP=1033189716channelch3:startingpiece1at26-FEB-20channelch2:finishedpiece1at26-FEB-20piecehandle=+FLASHBACK/backup/arch_20200226_06upflvi_1_1.baktag=TAG20200226T044954comment=NONEchannelch2:backupsetcomplete,elapsedtime:00:00:07channelch2:startingcompressedarchivedlogbackupsetchannelch2:specifyingarchivedlog(s)inbackupsetinputarchivedlogthread=1sequence=102RECID=18STAMP=1033191217inputarchivedlogthread=1sequence=103RECID=19STAMP=1033198828inputarchivedlogthread=1sequence=104RECID=20STAMP=1033358298inputarchivedlogthread=1sequence=105RECID=21STAMP=1033361394channelch2:startingpiece1at26-FEB-20channelch3:finishedpiece1at26-FEB-20piecehandle=+FLASHBACK/backup/arch_20200226_07upflvi_1_1.baktag=TAG20200226T044954comment=NONEchannelch3:backupsetcomplete,elapsedtime:00:00:07channelch2:finishedpiece1at26-FEB-20piecehandle=+FLASHBACK/backup/arch_20200226_08upflvp_1_1.baktag=TAG20200226T044954comment=NONEchannelch2:backupsetcomplete,elapsedtime:00:00:01Finishedbackupat26-FEB-20Startingbackupat26-FEB-20channelch2:startingcompressedfulldatafilebackupsetchannelch2:specifyingdatafile(s)inbackupsetinputdatafilefilenumber=00007name=+DATA/prod/datafile/data_housetax.269.873313903inputdatafilefilenumber=00008name=+DATA/prod/datafile/xx.270.929566627inputdatafilefilenumber=00006name=+DATA/prod/datafile/undotbs2.265.873311123inputdatafilefilenumber=00004name=+DATA/prod/datafile/users.259.873310959channelch2:startingpiece1at26-FEB-20channelch3:startingcompressedfulldatafilebackupsetchannelch3:specifyingdatafile(s)inbackupsetinputdatafilefilenumber=00001name=+DATA/prod/datafile/system.256.873310959inputdatafilefilenumber=00002name=+DATA/prod/datafile/sysaux.257.873310959inputdatafilefilenumber=00005name=+DATA/prod/datafile/example.264.873311025inputdatafilefilenumber=00003name=+DATA/prod/datafile/undotbs1.258.873310959channelch3:startingpiece1at26-FEB-20channelch3:finishedpiece1at26-FEB-20piecehandle=+FLASHBACK/backup/db_20200226_0aupflvq_1_1.baktag=TAG20200226T045002comment=NONEchannelch3:backupsetcomplete,elapsedtime:00:00:35channelch3:startingcompressedfulldatafilebackupsetchannelch3:specifyingdatafile(s)inbackupsetincludingcurrentcontrolfileinbackupsetchannelch3:startingpiece1at26-FEB-20channelch3:finishedpiece1at26-FEB-20piecehandle=+FLASHBACK/backup/db_20200226_0bupfm0t_1_1.baktag=TAG20200226T045002comment=NONEchannelch3:backupsetcomplete,elapsedtime:00:00:01channelch3:startingcompressedfulldatafilebackupsetchannelch3:specifyingdatafile(s)inbackupsetincludingcurrentSPFILEinbackupsetchannelch3:startingpiece1at26-FEB-20channelch3:finishedpiece1at26-FEB-20piecehandle=+FLASHBACK/backup/db_20200226_0cupfm0v_1_1.baktag=TAG20200226T045002comment=NONEchannelch3:backupsetcomplete,elapsedtime:00:00:01channelch2:finishedpiece1at26-FEB-20piecehandle=+FLASHBACK/backup/db_20200226_09upflvq_1_1.baktag=TAG20200226T045002comment=NONEchannelch2:backupsetcomplete,elapsedtime:00:00:44Finishedbackupat26-FEB-20Startingbackupat26-FEB-20currentlogarchivedchannelch2:startingcompressedarchivedlogbackupsetchannelch2:specifyingarchivedlog(s)inbackupsetinputarchivedlogthread=1sequence=106RECID=22STAMP=1033361447channelch2:startingpiece1at26-FEB-20channelch2:finishedpiece1at26-FEB-20piecehandle=+FLASHBACK/backup/arch_20200226_0dupfm17_1_1.baktag=TAG20200226T045047comment=NONEchannelch2:backupsetcomplete,elapsedtime:00:00:01Finishedbackupat26-FEB-20Startingbackupat26-FEB-20channelch2:startingfulldatafilebackupsetchannelch2:specifyingdatafile(s)inbackupsetincludingcurrentcontrolfileinbackupsetchannelch2:startingpiece1at26-FEB-20channelch2:finishedpiece1at26-FEB-20piecehandle=+FLASHBACK/backup/ctl_20200226_0eupfm18_1_1.baktag=TAG20200226T045048comment=NONEchannelch2:backupsetcomplete,elapsedtime:00:00:01Finishedbackupat26-FEB-20releasedchannel:ch2releasedchannel:ch3RMAN>

4.检查备份出来的文件

ASMCMD[+flashback/backup]>lsarch_20200226_06upflvi_1_1.bakarch_20200226_07upflvi_1_1.bakarch_20200226_08upflvp_1_1.bakarch_20200226_0dupfm17_1_1.bakctl_20200226_0eupfm18_1_1.bakdb_20200226_09upflvq_1_1.bakdb_20200226_0aupflvq_1_1.bakdb_20200226_0bupfm0t_1_1.bakdb_20200226_0cupfm0v_1_1.bakASMCMD[+flashback/backup]>ls-lsLTypeRedundStripedTimeSysBlock_SizeBlocksBytesSpaceNameBACKUPSETUNPROTCOARSEFEB2605:00:00N512833864269363242991616arch_20200226_06upflvi_1_1.bak=>+FLASHBACK/PROD/BACKUPSET/2020_02_26/annnf0_TAG20200226T044954_0.284.1033361395BACKUPSETUNPROTCOARSEFEB2605:00:00N512684303503616035651584arch_20200226_07upflvi_1_1.bak=>+FLASHBACK/PROD/BACKUPSET/2020_02_26/annnf0_TAG20200226T044954_0.283.1033361395BACKUPSETUNPROTCOARSEFEB2605:00:00N512675934606084194304arch_20200226_08upflvp_1_1.bak=>+FLASHBACK/PROD/BACKUPSET/2020_02_26/annnf0_TAG20200226T044954_0.282.1033361401BACKUPSETUNPROTCOARSEFEB2605:00:00N51284430081048576arch_20200226_0dupfm17_1_1.bak=>+FLASHBACK/PROD/BACKUPSET/2020_02_26/annnf0_TAG20200226T045047_0.290.1033361447BACKUPSETUNPROTCOARSEFEB2605:00:00N1638411321854668818874368ctl_20200226_0eupfm18_1_1.bak=>+FLASHBACK/PROD/BACKUPSET/2020_02_26/ncnnf0_TAG20200226T045048_0.291.1033361449BACKUPSETUNPROTCOARSEFEB2605:00:00N819253464437977088439353344db_20200226_09upflvq_1_1.bak=>+FLASHBACK/PROD/BACKUPSET/2020_02_26/nnndf0_TAG20200226T045002_0.281.1033361403BACKUPSETUNPROTCOARSEFEB2605:00:00N819239146320684032321912832db_20200226_0aupflvq_1_1.bak=>+FLASHBACK/PROD/BACKUPSET/2020_02_26/nnndf0_TAG20200226T045002_0.286.1033361403BACKUPSETUNPROTCOARSEFEB2605:00:00N163846811141122097152db_20200226_0bupfm0t_1_1.bak=>+FLASHBACK/PROD/BACKUPSET/2020_02_26/ncnnf0_TAG20200226T045002_0.287.1033361439BACKUPSETUNPROTCOARSEFEB2605:00:00N163846983041048576db_20200226_0cupfm0v_1_1.bak=>+FLASHBACK/PROD/BACKUPSET/2020_02_26/nnsnf0_TAG20200226T045002_0.288.1033361439

5.可以将ASM中的备份文件复制到文件系统中

（1）直接cp文件到操作系统中，只能一个一个文件复制

ASMCMD[+flashback/backup]>cparch_20200226_06upflvi_1_1.bak/home/gridcopying+flashback/backup/arch_20200226_06upflvi_1_1.bak->/home/grid/arch_20200226_06upflvi_1_1.bak

利用通配符也是只复制一个文件

ASMCMD[+flashback/backup]>cp*.*/home/gridcopying+flashback/backup/arch_20200226_06upflvi_1_1.bak->/home/grid/arch_20200226_06upflvi_1_1.bakASMCMD[+flashback/backup]>

（2）使用shell脚本批量将文件从ASM拷贝到文件系统（ASMCMD 中的cp 命令不能使用通配符 * ，只能通过脚本实现批量拷贝）

[grid@sam1~]$catasmcp.sh#!/bin/shexportORACLE_SID=+ASM1echo"StarttocopybackupfilefromASMtofilesystem...."asmcmd<<EOFcdflashback/backupcparch_20200226_06upflvi_1_1.bak/home/gridcparch_20200226_07upflvi_1_1.bak/home/gridcparch_20200226_08upflvp_1_1.bak/home/gridcparch_20200226_0dupfm17_1_1.bak/home/gridcpctl_20200226_0eupfm18_1_1.bak/home/gridcpdb_20200226_09upflvq_1_1.bak/home/gridcpdb_20200226_0aupflvq_1_1.bak/home/gridcpdb_20200226_0bupfm0t_1_1.bak/home/gridcpdb_20200226_0cupfm0v_1_1.bak/home/gridEOF[grid@sam1~]$chmodu+xasmcp.sh[grid@sam1~]$ls-lasmcp.sh-rwxr--r--1gridoinstall562Feb2606:41asmcp.sh[grid@sam1~]$./asmcp.shStarttocopybackupfilefromASMtofilesystem....ASMCMD>ASMCMD>copying+flashback/backup/arch_20200226_06upflvi_1_1.bak->/home/grid/arch_20200226_06upflvi_1_1.bakASMCMD>copying+flashback/backup/arch_20200226_07upflvi_1_1.bak->/home/grid/arch_20200226_07upflvi_1_1.bakASMCMD>copying+flashback/backup/arch_20200226_08upflvp_1_1.bak->/home/grid/arch_20200226_08upflvp_1_1.bakASMCMD>copying+flashback/backup/arch_20200226_0dupfm17_1_1.bak->/home/grid/arch_20200226_0dupfm17_1_1.bakASMCMD>copying+flashback/backup/ctl_20200226_0eupfm18_1_1.bak->/home/grid/ctl_20200226_0eupfm18_1_1.bakASMCMD>copying+flashback/backup/db_20200226_09upflvq_1_1.bak->/home/grid/db_20200226_09upflvq_1_1.bakASMCMD>copying+flashback/backup/db_20200226_0aupflvq_1_1.bak->/home/grid/db_20200226_0aupflvq_1_1.bakASMCMD>copying+flashback/backup/db_20200226_0bupfm0t_1_1.bak->/home/grid/db_20200226_0bupfm0t_1_1.bakASMCMD>copying+flashback/backup/db_20200226_0cupfm0v_1_1.bak->/home/grid/db_20200226_0cupfm0v_1_1.bakASMCMD>exit[grid@sam1~]$ls-l*.bak-rw-r-----1gridoinstall42693632Feb2606:50arch_20200226_06upflvi_1_1.bak-rw-r-----1gridoinstall35036160Feb2606:50arch_20200226_07upflvi_1_1.bak-rw-r-----1gridoinstall3460608Feb2606:50arch_20200226_08upflvp_1_1.bak-rw-r-----1gridoinstall43008Feb2606:50arch_20200226_0dupfm17_1_1.bak-rw-r-----1gridoinstall18546688Feb2606:50ctl_20200226_0eupfm18_1_1.bak-rw-r-----1gridoinstall437977088Feb2606:50db_20200226_09upflvq_1_1.bak-rw-r-----1gridoinstall320684032Feb2606:50db_20200226_0aupflvq_1_1.bak-rw-r-----1gridoinstall1114112Feb2606:50db_20200226_0bupfm0t_1_1.bak-rw-r-----1gridoinstall98304Feb2606:50db_20200226_0cupfm0v_1_1.bak

“怎么将RMAN备份文件放到ASM中”的内容就介绍到这里了，感谢大家的阅读。如果想了解更多行业相关的知识可以关注亿速云网站，小编将为大家输出更多高质量的实用文章！