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

Article:TECH67938  |  Created: 2009-01-15  |  Updated: 2011-07-12  |  Article URL http://www.symantec.com/docs/TECH67938
Article Type
Technical Solution


Issue



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


Error



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 
 

Supplemental Materials

SourceError Code
Value0xe0000340
Description

The Database script returned an error


SourceError Code
ValueRMAN-06056
Description

could not access datafile



Legacy ID



319596


Article URL http://www.symantec.com/docs/TECH67938


Terms of use for this information are found in Legal Notices