[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

could not read file header for datafile 5 error reason 1

Posted on 2013-01-28
8
Medium Priority
?
1,195 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
  • 4
  • 4
8 Comments
 
LVL 78

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 78

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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
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 78

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 78

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

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
This article will show a step by step guide on how to mask column values in Oracle 12c using DBMS_REDACT full redaction option. This option is available on licensed Oracle Enterprise edition as part of Oracle's Advanced Security.
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…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

591 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