1、在备份脚本中执行了备份数据库的控制文件,
在执行日志中提示
“
archived logs required to recover from this backup will be backed up
channel e1: starting compressed archived log backup set
channel e1: specifying archived log(s) in backup set
input archived log thread=1 sequence=991 RECID=267 STAMP=1135254473
input archived log thread=1 sequence=992 RECID=268 STAMP=1135254502
input archived log thread=1 sequence=993 RECID=269 STAMP=1135254504
channel e1: starting piece 1 at 27-APR-23
released channel: e1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 04/27/2023 12:28:26
ORA-19504: failed to create file “/backup/easbak/dbincbak/controlfile_2023042712_MWEASDB_control.bak”
ORA-27038: created file already exists
Additional information: 1
”
但是备份文件已经被建立了
2、备份命令如下:
“----------------------------------------date
---------------------------------------”
source ~/.bash_profile
export FILE=“mwdbbak_inc”(date +%Y%m%d%H)
rman target / log /backup/easbak/dbincbak/{FILE}-LEVEL1.log<<EOF
run{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
allocate channel c4 type disk;
crosscheck backupset;
sql ‘alter system checkpoint’;
sql ‘alter system switch logfile’;
backup as compressed backupset incremental level=1 CUMULATIVE database tag=mwdb_bk_level1 format ‘/backup/easbak/dbincbak/mwdbbak_level1C_$(date +%Y%m%d%H)%d%s_%p.bak’ FILESPERSET 1000 MAXSETSIZE 500000M keep UNTIL TIME ‘sysdate+1’;
sql ‘alter system archive log current’;
release channel c1;
release channel c2;
release channel c3;
release channel c4;
}
run{
allocate channel e1 type disk;
crosscheck backupset;
backup as compressed backupset current controlfile tag=mwdb_controlfile_level1 format ‘/backup/easbak/dbincbak/controlfile_$(date +%Y%m%d%H)_%d_control.bak’ keep UNTIL TIME ‘sysdate+1’;
release channel e1;
}
report obsolete;
delete noprompt expired backupset;
delete noprompt obsolete;
exit;
EOF
3、rman的设置
如果放在incremental level=1 CUMULATIVE 的里面也是相同的报错。
没有找到问题出在哪里