| ora-01122, ora-01110, ora-01207 [message #73301] |
Thu, 18 March 2004 09:47  |
Niraikalai Vijay
Messages: 9
Registered: November 2002
|
Junior Member |
|
|
Oracle Version 8.0.5
OS Solaris 5.8
Database uses three disks and one of the disks got corrupted. Sysadmin restored all the datafiles except one that has one of the temprorary file.
Since this files more recent than the control file,
database startup gives following error
ORA-01122: database file 21 failed verification check
ORA-01110: data file 21: '/antaeus2/app/oradata/awp1/temp04.dbf'
ORA-01207: file is more recent than controlfile - old controlfile
Is there any way to drop this temporary file and proceed with startup
Any help will be greatly appreciated.
Thanks
Nirai
|
|
|
|
| Re: ora-01122, ora-01110, ora-01207 [message #73316 is a reply to message #73301] |
Tue, 23 March 2004 01:51  |
Frank Naude
Messages: 4580
Registered: April 1998
|
Senior Member |
|
|
Hi,
You need to put datafile 21 offline, open the database, drop the entire TEMP tablespace, and recreate the tablespace from scratch.
BTW: If you were using TEMPFILEs for your TEMPORARY tablespace, you would be able to drop it without having to drop the entire tablespace.
Best regards.
Frank
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
