YZlat
asked on
could not read file header for datafile 5 error reason 1
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?
backup database;
Can someone help me to diagnoze and fix the issue?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I am not sure... Looks like all data files are there that have been there before
ASKER
when I ran the statment you posted, I got
/u01/app/oracle/oradata/DB Name/syste m01.dbf
/u01/app/oracle/oradata/DB Name/undot bs01.dbf
/u01/app/oracle/oradata/DB Name/sysau x01.dbf
/u01/app/oracle/oradata/DB Name/users 01.dbf
/u01/app/oracle/product/11 .2.0.3/dbs /MISSING00 005
But /u01/app/oracle/oradata/DB Name/ contains one more file - tbspace1_01.dbf
So I rename thefile:
alter database rename file '/u01/app/oracle/product/1 1.2.0.3/db s/MISSING0 0005' to '/u01/app/oracle/oradata/D BName/tbsp ace1_01.db f';
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/D BName/tbsp ace1_01.db f'
/u01/app/oracle/oradata/DB
/u01/app/oracle/oradata/DB
/u01/app/oracle/oradata/DB
/u01/app/oracle/oradata/DB
/u01/app/oracle/product/11
But /u01/app/oracle/oradata/DB
So I rename thefile:
alter database rename file '/u01/app/oracle/product/1
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/D
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.
I tried to locate a good reference that talks about the missing0000n filed but could not find anything decent.
ASKER
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
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
ASKER
/u01/app/oracle/product/11
so looks like a file is missing, but how do I determine which file is missing