RMAN-03009: backup 命令 (ORA_DISK_1 通道上, 在 09/08/2008 14:48:58 上) 失败 ORA-19504: 无法创建文件"E:\BACKUP\XJLI_71.BAK"
ORA-27038: 所创建的文件已存在
OSD-04010: 指定了
solution 1 check out the privilege. do you have privilege to create a file in the specified folder execute command: backup database format='e:\backup\%d_%s.bak' again. it was also failure
2 run: backup database result: it can work checkout the address, it was e:\backup\
So we can get rig of suspecting pravilige
3 becauce on the first time it was failed to run backup database format='e:\backup\%d_%s.bak' and on the second time it can work the only difference between two times is the format
4 change the format backup database format='e:\backup\%d_%s_%p.bak' it can work. the only thing i did is adding a %p
Analysis is below
When we set RMAN there are two parameter need to configure out
configure channal device type disk maxpiecesize 200m
configure maxsetsize to 1g those two parameters result that one backup set contains two backup piece.
So under this situation that one backup set contains more than one backup piece, we have to set a format with %p in order to distinguish backup pieces when we execute backup database format='e:\backup\%d_%s.bak' it was failed
The reason is that this command result in an creation of file "XJLI_71.BAK" however my database is 800m, the maxsetsize is 1g, so in the thoery there are two backup piece files, each 500m. in fact there are two backup piece file, one is 500m, one is 300m So the system gonna run like this firstly this is no any problem when the first backup piece file XJLI_71.BAK was created but when the second backup piece come out , becauce of same backup set, the second backup piece is also named XJLI_71.BAK So the system gonna report an error
Consequently when we backup some objects, we need to pay attention to format . There are some principle about format %c,&u,%p,%s,%d,%n,%t
No comments:
Post a Comment