[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自动"分组".
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/267265/viewspace-2645146/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/267265/viewspace-2645146/