我们的文章会在微信公众号IT民工的龙马人生和博客网站( www.htz.pw )同步更新 ，欢迎关注收藏，也欢迎大家转载，但是请在文章开始地方标注文章出处，谢谢！
由于博客中有大量代码，通过页面浏览效果更佳。
Oracle备份恢复：backup as copy保留文件名不变化，只更改路径名
有些时候可能会用到backup as copy的方式来将数据库从一个目录迁移到另一个目录，如更改存储时，怎么保存文件名不变，只更改路径名，如果在ASM环境很简单，直接使用backup as copy format ‘+DGNAME’的方式就可以实现了，因为磁盘组中的文件名是ORACLE自动管理的，但是如果是文件系统就不能通过FORMAT的方式来实现了。实现方式见下面步骤
欢迎大家加入ORACLE超级群：17115662 免费解决各种ORACLE问题,以后BLOG将迁移到http://www.htz.pw
1，数据库版本
swww.htz.pw > elect * from v$version;BANNER——————————————————————————–Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit ProductionPL/SQL Release 11.2.0.4.0 – ProductionCORE 11.2.0.4.0 ProductionTNS for Linux: Version 11.2.0.4.0 – ProductionNLSRTL Version 11.2.0.4.0 – Production
2，rman备份数据库
run {allocate channel D1 type disk;BACKUP AS COPY DB_FILE_NAME_CONVERT=(‘/oracle/app/oracle/oradata/orcl1124′,’/soft/rman’) FORMAT=’/soft/rman/spfile_and_control_%U’ database;}
如果这里有多个路径，我们可以在db_file_name_convert增加上多个目录，但是需要注意的是必须成对出现，如果没有成对出现的，将会备份到format指定的目录中。这里增加format的作用是将controlfile与spfile备份到指定的路径下
RMAN> run {2> allocate channel D1 type disk;3> BACKUP AS COPY DB_FILE_NAME_CONVERT=(‘/oracle/app/oracle/oradata/orcl1124′,’/soft/rman’) FORMAT=’/soft/rman/spfile_and_control_%U’ database;4> }released channel: ORA_DISK_1allocated channel: D1channel D1: SID=50 device type=DISKStarting backup at 03-JUN-14channel D1: starting datafile copyinput datafile file number=00001 name=/oracle/app/oracle/oradata/orcl1124/system01.dbfoutput file name=/soft/rman/system01.dbf tag=TAG20140603T222947 RECID=16 STAMP=849306632channel D1: datafile copy complete, elapsed time: 00:00:55channel D1: starting datafile copyinput datafile file number=00002 name=/oracle/app/oracle/oradata/orcl1124/sysaux01.dbfoutput file name=/soft/rman/sysaux01.dbf tag=TAG20140603T222947 RECID=17 STAMP=849306679channel D1: datafile copy complete, elapsed time: 00:00:46channel D1: starting datafile copyinput datafile file number=00005 name=/oracle/app/oracle/oradata/orcl1124/htz01.dbfoutput file name=/soft/rman/htz01.dbf tag=TAG20140603T222947 RECID=18 STAMP=849306695channel D1: datafile copy complete, elapsed time: 00:00:15channel D1: starting datafile copyinput datafile file number=00003 name=/oracle/app/oracle/oradata/orcl1124/undotbs01.dbfoutput file name=/soft/rman/undotbs01.dbf tag=TAG20140603T222947 RECID=19 STAMP=849306709channel D1: datafile copy complete, elapsed time: 00:00:15channel D1: starting datafile copyinput datafile file number=00006 name=/oracle/app/oracle/oradata/orcl1124/undotbs02.dbfoutput file name=/soft/rman/undotbs02.dbf tag=TAG20140603T222947 RECID=20 STAMP=849306719channel D1: datafile copy complete, elapsed time: 00:00:03channel D1: starting datafile copycopying current control fileoutput file name=/soft/rman/spfile_and_control_cf_D-ORCL1124_id-3333857950_1ip9up31 tag=TAG20140603T222947 RECID=21 STAMP=849306722channel D1: datafile copy complete, elapsed time: 00:00:01channel D1: starting datafile copyinput datafile file number=00004 name=/oracle/app/oracle/oradata/orcl1124/users01.dbfoutput file name=/soft/rman/users01.dbf tag=TAG20140603T222947 RECID=22 STAMP=849306723channel D1: datafile copy complete, elapsed time: 00:00:01channel D1: starting full datafile backup setchannel D1: specifying datafile(s) in backup setincluding current SPFILE in backup setchannel D1: starting piece 1 at 03-JUN-14channel D1: finished piece 1 at 03-JUN-14piece handle=/soft/rman/spfile_and_control_1kp9up34_1_1 tag=TAG20140603T222947 comment=NONEchannel D1: backup set complete, elapsed time: 00:00:01Finished backup at 03-JUN-14released channel: D1
3，生成的文件名
查看生成的文件名，这里发现文件名没有发生变化
[oracle@www.htz.pw rman]$ls -lrttotal 1602304-rwxrwSrwt 1 oracle oinstall 786440192 Jun 3 22:30 system01.dbf-rwxrwSrwt 1 oracle oinstall 639639552 Jun 3 22:31 sysaux01.dbf-rwxrwSrwt 1 oracle oinstall 104865792 Jun 3 22:31 htz01.dbf-rwxrwSrwt 1 oracle oinstall 83894272 Jun 3 22:31 undotbs01.dbf-rwxrwSrwt 1 oracle oinstall 10493952 Jun 3 22:31 undotbs02.dbf-rwxrwSrwt 1 oracle oinstall 10076160 Jun 3 22:31 spfile_and_control_cf_D-ORCL1124_id-3333857950_1ip9up31-rwxrwSrwt 1 oracle oinstall 5251072 Jun 3 22:31 users01.dbf-rwxrwSrwt 1 oracle oinstall 98304 Jun 3 22:31 spfile_and_control_1kp9up34_1_1
------------------作者介绍-----------------------
姓名：黄廷忠
现就职：Oracle中国高级服务团队
曾就职：OceanBase、云和恩墨、东方龙马等
电话、微信、QQ：18081072613
个人博客: (http://www.htz.pw)
CSDN地址: (https://blog.csdn.net/wwwhtzpw)
博客园地址: (https://www.cnblogs.com/www-htz-pw)
