3 Replies Latest reply on Jan 7, 2013 6:23 AM by cheesewizz

    RMAN06056: could not access datafile 44


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

      Our APPS Version R12.1
      DB Version:
      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:


      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.