Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

could not read file header for datafile 5 error reason 1

Posted on 2013-01-28
8
Medium Priority
?
1,080 Views
Last Modified: 2013-01-28
I have gotten the error "could not read file header for datafile 5 error reason 1" when trying to backup a database from RMAN, using

backup database;

Can someone help me to diagnoze and fix the issue?
0
Comment
Question by:YZlat
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 77

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 2000 total points
ID: 38827479
Looks like a file is either missing or corrupt.

Connect to the database and post the results of the following:
select file_id, file_name from dba_data_files;

Look for the file with the file_id=5.  Make sure it is where it is supposed to be.
0
 
LVL 35

Author Comment

by:YZlat
ID: 38827528
I got the output


/u01/app/oracle/product/11.2.0.3/dbs/MISSING00005

so looks like a file is missing, but how do I determine which file is missing
0
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 total points
ID: 38827564
What datafiles were added after you recovered the controlfile from your backup/recovery testing?

See if this thread helps:
http://oracleinstance.blogspot.com/2010/10/recover-missing-datafileafter.html
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 35

Author Comment

by:YZlat
ID: 38827598
I am not sure... Looks like all data files are there that have been there before
0
 
LVL 35

Author Comment

by:YZlat
ID: 38827649
when I ran the statment you posted, I got

/u01/app/oracle/oradata/DBName/system01.dbf  
/u01/app/oracle/oradata/DBName/undotbs01.dbf  
/u01/app/oracle/oradata/DBName/sysaux01.dbf  
/u01/app/oracle/oradata/DBName/users01.dbf  
/u01/app/oracle/product/11.2.0.3/dbs/MISSING00005  

But /u01/app/oracle/oradata/DBName/ contains one more file - tbspace1_01.dbf

 
So I rename thefile:

alter database rename file '/u01/app/oracle/product/11.2.0.3/dbs/MISSING00005' to '/u01/app/oracle/oradata/DBName/tbspace1_01.dbf';

Then I ran

recover datafile 5;

and got another error:

SQL> recover datafile 5;
ORA-00283: recovery session canceled due to errors
ORA-19909: datafile 5 belongs to an orphan incarnation
ORA-01110: data file 5: '/u01/app/oracle/oradata/DBName/tbspace1_01.dbf'
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 38827651
Something is missing or Oracle wouldn't have created the missing0005 pointer.

I tried to locate a good reference that talks about the missing0000n filed but could not find anything decent.
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 38827665
>>ORA-19909: datafile 5 belongs to an orphan incarnation

Check out:
http://ora-19909.ora-code.com/
0
 
LVL 35

Author Comment

by:YZlat
ID: 38827784
Actually looks like there are no more issues and I was able to do a backup and no files are reported as missing.

Thank you so much! You are always very helpful and I have no idea what I would do without you the past couple of months
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question