This discussion is archived
3 Replies Latest reply: Jan 6, 2013 10:23 PM by cheesewizz RSS

RMAN06056: could not access datafile 44

cheesewizz Newbie
Currently Being Moderated
Hi

I am Database Administrator inchrage in our company but am not expert.

Our APPS Version R12.1
DB Version: 11.1.0.7
Linux: Oracle Linux 5

We have a Backup Exec Symantec version 2012 running in windows 2008 64bit Standard

Last month I encountered tablespace full so what i did is to create new datafile


Creating of datafile for the tablesapce i just do in orderlist

for example:

a_txn_data01.dbf
a_txn_data02.dbf
a_txn_data03.dbf
a_txn_data04.dbf
a_txn_data05.dbf

last month i just create a_txn_data07.dbf since i noticed it i deleted it after that i created a_txn_data06.dbf
but when i start our database i got error something no such file so what i did is to alter database datafile 44 OFFLINE DROP;

then it works our database is now STARTED.


in symantec backupexec i got this error

Starting backup at 04-JAN-13
RMAN-06169: could not read file header for datafile 44 error reason 4
released channel: ch0
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 01/04/2013 11:32:40
RMAN-06056: could not access datafile 44


that is why our RMAN terminated when scheduled run in BackupExec.



Please anyone who can able to help me.


Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points