- 论坛徽章:
- 0
|
由于特殊原因,删除了很多归档文件,RMAN备份时就出现错误:
RMAN-03002: failure of backup command at 04/09/2008 00:05:35
RMAN-06059: expected archived log not found, lost of archived log compromises re
coverability
ORA-19625: error identifying file /oracle/prodenv/prodarch/ARC00010000020669.arc
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: A file or directory in the path name does not
exist.
使用crosscheck archivelog all;
没解决问题。
使用change archivelog all crosscheck;
也没解决问题。
反正下面的命令也做了:
delete obsolete;
delete expired;
就是不行。
数据库重新启动过,先做一个RMAN数据库全备,然后再做RMAN数据库PLUS ARCHIVELOG。
折腾好长时间了,不知道到底差在哪了。请各位帮帮忙!
备份脚本如下:
configure controlfile autobackup on;
run
{
allocate channel t1 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
backup database plus archivelog;
release channel t1;
}
allocate channel for maintenance type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
delete noprompt obsolete;
run
{
allocate channel d1 device type disk;
backup current controlfile format '/cntrl_bak/control.prod_%t';
release channel d1;
} |
|