Solved

could not read file header for datafile 5 error reason 1

Posted on 2013-01-28
8
870 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 76

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 76

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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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 76

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 76

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Oracle RAC 12c 8 87
Oracle - SQL Parse String 5 45
Select and Insert Query running slow 4 45
oracle DR - data guard failover. 18 46
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
Via a live example, show how to take different types of Oracle backups using RMAN.

856 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