3 Replies Latest reply: Jan 7, 2013 12:23 AM by cheesewizz RSS

    RMAN06056: could not access datafile 44

    cheesewizz
      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