rman backup database 报 RMAN-06169

来源:互联网 发布:仟游软件科技 编辑:程序博客网 时间:2024/05/22 03:31
RMAN> backup database;

Starting backup at 08-FEB-14
using channel ORA_DISK_1
RMAN-06169: could not read file header for datafile 6 error reason 4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 02/08/2014 09:17:52
RMAN-06056: could not access datafile 6


  select t1.name,t2.name from v$tablespace t1,v$datafile t2 where t1.ts# = t2.ts#;
先找到数据文件和表空间的对应关系。

然后找到6号文件,直接删除6号文件所在的表空间。就OK了

RMAN> backup database;

Starting backup at 08-FEB-14
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/oradata/ls1/system01.dbf
input datafile file number=00002 name=/u01/oradata/ls1/sysaux01.dbf
input datafile file number=00003 name=/u01/oradata/ls1/undotbs01.dbf
input datafile file number=00005 name=/u01/oradata/ls1/test01.dbf
input datafile file number=00004 name=/u01/oradata/ls1/users01.dbf
channel ORA_DISK_1: starting piece 1 at 08-FEB-14
channel ORA_DISK_1: finished piece 1 at 08-FEB-14
piece handle=/u01/flash_recovery_area/LS1/backupset/2014_02_08/o1_mf_nnndf_TAG20140208T093116_9hdhxnw7_.bkp tag=TAG20140208T093116 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:35
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 08-FEB-14
channel ORA_DISK_1: finished piece 1 at 08-FEB-14
piece handle=/u01/flash_recovery_area/LS1/backupset/2014_02_08/o1_mf_ncsnf_TAG20140208T093116_9hdj0q15_.bkp tag=TAG20140208T093116 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 08-FEB-14





0 0