高级 rman 备份问题求助
hem 2006-11-23 10:10:33 备份脚本:
#!/bin/sh
source /home/oracle/.bash_profile
cd $ORACLE_HOME/bin
./rman target / catalog rman/rman@244 msglog=/home/oracle/work/log/rman_bk_L0_`date '+%Y%m%d%H%M%S'`.log <<EOF
run {
allocate channel c1 type disk;
backup incremental level 0 filesperset 5 tag 'dbL0' format '/mnt/raid/rman_bk/ora_o_%d_%t%s%p%u' database skip readonly include current controlfile;
sql 'alter system archive log current' ;
backup(archivelog all format '/mnt/raid/rman_bk/ora_a_%d_%t%s%p%u');
release channel c1;
}
list backup;
exit;
EOF
数据文件 控制文件 Spfile 文件都成功备份完毕,可是以前的归档日志都被我删了,新的归档日志还保留着,以后恢复是否还能完全恢复,还是只能恢复到当前时间点?
备份日志如下:
Starting Control File and SPFILE Autobackup at 2006-11-22 20:36:32
piece handle=/oracle/product/9.2.0.4/dbs/c-810128133-20061122-00 comment=NONE
Finished Control File and SPFILE Autobackup at 2006-11-22 20:36:37
sql statement: alter system archive log current
Starting backup at 2006-11-22 20:36:51
current log archived
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 11/22/2006 20:36:56
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /mnt/raid/oradata/arch/lrdb/1_5084.dbf
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
RMAN>