DP备份报错：ORA-19643 incremental-start SCN too recent
oracle数据库昨天做了一次全备，刚才做 1级备份时报错：ORA-19643: datafile string: incremental-start SCN is too recent2
1级备份脚本如下：
run {
allocate channel 'dev_0' type 'sbt_tape'
parms 'SBT_LIBRARY=/opt/omni b bob2oracle8_64bit.so,ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=orcl,OB2BARLIST=ORACL_full_backup) ,BLKSIZE=524288'
maxopenfiles 1;
send device type 'sbt_tape' 'OB2BARHOSTNAME=rac-scan';
sql 'alter system archive log current';
backup incremental level 1
format 'ORACL_full_backup<orcl_%s:%t:%p>.dbf'
database;
backup
format 'ORACL_full_backup<orcl_%s:%t:%p>.dbf'
archivelog all;
backup
format 'ORACL_full_backup<orcl_%s:%t:%p>.dbf'
current controlfile;
}
谢谢！ backup incremental level 1 ???????? 是啊。。。 本帖最后由 LouisJi 于 2011-07-16 22:41 编辑
刚发现用户的DBA在服务器上创建了一个cron任务，每天早上3点执行他写的rman备份脚本。
大致如下：
crosscheck backupset of archivelog all ;
backup filesperset 3 format '/backup/arch.%d.level.$LEVEL.%d_%Y%M%D_%
U'(archivelog from time 'sysdate-7' all delete input) ;
sql 'alter system archive log current';
delete noprompt expired backupset of archivelog all ;
crosscheck backupset of database ;
backup incremental level $LEVEL filesperset 3 format '/backup/data.%d
.level.$LEVEL.%d_%Y%M%D_%U'(database include current controlfile) ;
delete noprompt expired backupset of database ;
delete noprompt obsolete ;
DP是通过DP server上的 catalog库来存储备份信息的。
请问是不是他的rman脚本中删除了archive log等信息导致DP的备份任务失败呢？
页:
[1]