| Oracle Error [message #62964] |
Sun, 29 August 2004 22:30  |
Avra
Messages: 65
Registered: July 2004
|
Member |
|
|
Hi,
When I'm trying to open the oracle database with the alter database open, i'm getting the following error....pls help me to solve this.....
ORA-01122: database file 8 failed verification check
ORA-01110: data file 8: 'D:ORACLEORADATAORACLE8IFAOLD01.DBF'
ORA-01251: Unknown File Header Version read for file number 8
Thanks,
Avra
|
|
|
|
| Re: Oracle Error [message #62971 is a reply to message #62964] |
Mon, 30 August 2004 01:04  |
Dilip
Messages: 12
Registered: January 2002
|
Junior Member |
|
|
check out your alert log file and try to trace the exact information from that file..
it seems a proper checkpoint has not occured on your database,if this is the case take that datafile into offline then open the database(if your database is in Archivelog mode)perform a recovery for that datafile/tablespace then bring down the datafile/tablespace into online...
it will work
Regards
D.Dilip
|
|
|
|
| Re: Oracle Error [message #62976 is a reply to message #62964] |
Mon, 30 August 2004 04:40 |
feras
Messages: 9
Registered: September 2000
|
Junior Member |
|
|
**The following apply to D.B. in noarchive mode
1-mount the database.
2-backup you're control file Using (alter databse backup controlfiles to trace.
3-The previous command will generate a trace file(located in the log directory i.e. /ORACELEHOME/rdbms/log)
4-edit the file and remove the entry that contains the file which are infected.and save it by abc...sql )
5-svrmgrl
6-@abc..
7-By the end of this you will have database opened.then later you create a new database file.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
