[20190522]rman备份问题.txt

[20190522]rman备份问题.txt --//链接http://www.itpub.net/thread-2116768-1-1.html,提到的一个问题,主要脚本里面出现2次database. --//导致备份出现2次,1次备份到闪回区,导致闪回区空间不足的情况. backup as compressed backupset incremental level= 1  skip inaccessible filesperset 5 Database format='/home/oracle/ora_bak/orcl_lev1_%U_%T'  tag='orcl_lev1_0520' database    include current controlfile ;  --//注意看可以发现出现2次database.我认为应该删除第2个database,zergduan指出 不对， 标准的Backup 语法是 Backup + Backup_Operand + Backup_Spec format 子句属于 operand database 属于 spec 所以应该是 backup format=xxx database， 这样才标准～ 具体可以参考 rman 的官方文档 reference那本 --//我个人喜欢放在最后,例子: http://blog.itpub.net/267265/viewspace-2089074/=>[20160427]rman tag format标识.txt --//我还是测试看看: 1.环境: SCOTT@book> @ ver1 PORT_STRING                    VERSION        BANNER ------------------------------ -------------- -------------------------------------------------------------------------------- x86_64/Linux 2.4.xx            11.2.0.4.0     Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production --//CONFIGURE CHANNEL DEVICE TYPE SBT_TAPE clear; --//CONFIGURE DEFAULT DEVICE TYPE TO DISK; --//CONFIGURE CHANNEL 1 DEVICE TYPE DISK clear; 2.测试: RMAN> backup as compressed backupset datafile 9 tag='file 9' format '/home/oracle/backup/datafile9_%U' datafile 9 tag='filex 9' format '/home/oracle/backup/datafile9x_%U'; Starting backup at 2019-05-22 09:35:43 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=1 device type=DISK channel ORA_DISK_1: starting compressed full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00009 name=/mnt/ramdisk/book/T01.dbf channel ORA_DISK_1: starting piece 1 at 2019-05-22 09:35:44 channel ORA_DISK_1: finished piece 1 at 2019-05-22 09:35:45 piece handle=/home/oracle/backup/datafile9_2vu260jg_1_1 tag=FILE 9 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 channel ORA_DISK_1: starting compressed full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00009 name=/mnt/ramdisk/book/T01.dbf channel ORA_DISK_1: starting piece 1 at 2019-05-22 09:35:45 channel ORA_DISK_1: finished piece 1 at 2019-05-22 09:35:46 piece handle=/home/oracle/backup/datafile9x_30u260jh_1_1 tag=FILEX 9 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 2019-05-22 09:35:46 $ ls -l /home/oracle/backup/datafile9* -rw-r----- 1 oracle oinstall 3284992 2019-05-22 09:35:44 /home/oracle/backup/datafile9_2vu260jg_1_1 -rw-r----- 1 oracle oinstall 3284992 2019-05-22 09:35:46 /home/oracle/backup/datafile9x_30u260jh_1_1 --//感觉我写的是对的.修改如下: RMAN> backup as compressed backupset datafile 9 tag='file 9' format '/home/oracle/backup/datafile9_%U' datafile 9 ; Starting backup at 2019-05-22 09:41:25 using channel ORA_DISK_1 channel ORA_DISK_1: starting compressed full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00009 name=/mnt/ramdisk/book/T01.dbf channel ORA_DISK_1: starting piece 1 at 2019-05-22 09:41:25 channel ORA_DISK_1: finished piece 1 at 2019-05-22 09:41:26 piece handle=/home/oracle/backup/datafile9_31u260u5_1_1 tag=FILE 9 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 channel ORA_DISK_1: starting compressed full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00009 name=/mnt/ramdisk/book/T01.dbf channel ORA_DISK_1: starting piece 1 at 2019-05-22 09:41:26 channel ORA_DISK_1: finished piece 1 at 2019-05-22 09:41:27 piece handle=/u01/app/oracle/fast_recovery_area/BOOK/backupset/2019_05_22/o1_mf_nnndf_TAG20190522T094125_gg9b66j0_.bkp tag=TAG20190522T094125 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 2019-05-22 09:41:27 RMAN> backup as compressed backupset  tag='file 9' format '/home/oracle/backup/datafile9_%U' datafile 9 ; Starting backup at 2019-05-22 09:42:51 using channel ORA_DISK_1 channel ORA_DISK_1: starting compressed full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00009 name=/mnt/ramdisk/book/T01.dbf channel ORA_DISK_1: starting piece 1 at 2019-05-22 09:42:51 channel ORA_DISK_1: finished piece 1 at 2019-05-22 09:42:52 piece handle=/home/oracle/backup/datafile9_33u2610r_1_1 tag=FILE 9 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 2019-05-22 09:42:52 --//感觉前面没有什么区别,这样看来前后没有什么区别,只不过oracle自动"分组".