Oracle backup fails with error "RMAN-06056: could not access datafile".

Problem

The oracle database backup fails with error "RMAN-06056: could not access datafile".

Error Message

The RMAN output shows

could not read file header for datafile 189 error reason 1 released channel:ch0
RMAN-00571: ===================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ======
RMAN-00571: ===================================================
RMAN-03002: failure of backup plus archivelog command at 02/06/2009 09:35:29
RMAN-06056: could not access datafile 189
 

Cause

As per RMAN troubleshooting guide, A backup or copy could not proceed because the datafile header could not be read or the header was not valid.

Solution


Make the datafile accessible or skip it. A backup failure can occur for many reasons. To potentially resolve the issue, understanding the error code is important.
Following are the list of error code along with the reason.

The specified datafile could not be accessed. The reason codes are:

 1 - filename is MISSINGxx in the controlfile
 2 - file is offline
 3 - file is not verified
 4 - DBWR could not find the file
 5 - unable to open file
 6 - I/O error during read
 7 - file header is corrupt
 8 - file is not a datafile
 9 - file does not belong to this database
10 -file number is incorrect
12 -wrong file version
15 -controlfile is not current

Check the status of the datafile and take action as per the reason for the error code. This would require sound knowledge and understanding of ORACLE database operations and RMAN, so Symantec recommends to contact ORACLE support if necessary.

How to check the status of the datafile.

1. Connect to the Oracle database using sqlplus tool
2. Run the following command
  select file#, status, enabled from v$datafile where file# = XXX;

Note: XXX is the datafile number that will be reported in the job log.


Please refer to this following link to find the cause and neccessary action to resolve the RMAN issues.

   http://tahiti.oracle.com/pls/db92/db92.error_search?search=%25s 
 

Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)