Solved

could not read file header for datafile 5 error reason 1

Posted on 2013-01-28
8
886 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 500 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 500 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

726 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