oracle rman 06056,RMAN-06169: could not read file header for datafile 6 error reason 5

Hi All

Getting this error while DB backup ran using RMAN

RMAN-06169: could not read file header for datafile 6 error reason 5

released channel: t1

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of backup command at 05/28/2016 18:02:03

RMAN-06056: could not access datafile 6

When i checked the DB and the result is as follows:

SQL> select * from v$datafile where FILE#=6;

no rows selected

SQL> select * from v$recover_file where file#=6;

no rows selected

SQL>  select file#, name, status from v$datafile_header;

FILE# NAME                                               STATUS

---------- -------------------------------------------------- -------

1 /data2/XXX/system01.dbf                        ONLINE

2 /data2/XXX/sysaux01.dbf                        ONLINE

3 /data2/XXX/undotbs01.dbf                       ONLINE

4 /data2/XXX/users01.dbf                         ONLINE

7 /data1/app/oracle/XXX/ceiinst1_cei_ts_extended ONLINE

.dbf

8 /data1/app/oracle/XXX/ceiinst1_cei_ts_base.dbf ONLINE

9 /data1/app/oracle/XXX/ceiinst1_cei_ts_catalog. ONLINE

dbf

7 rows selected.

SQL> select file#, ts#, status, enabled, name from v$tempfile;

FILE#        TS# STATUS  ENABLED

---------- ---------- ------- ----------

NAME

--------------------------------------------------

1          3 ONLINE  READ WRITE

/data2/XXX/temp01.dbf

2         10 ONLINE  READ WRITE

/data1/app/oracle/XXX/ceiinst1_cei_ts_temp.dbf

File# 5 & 6 belongs to temporary tablespaces as shown below. I do not understand why the backup is failing?

Regards

Ariz

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值