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