Home » RDBMS Server » Server Utilities » ora-01122, ora-01110, ora-01207
ora-01122, ora-01110, ora-01207 [message #73301] Thu, 18 March 2004 09:47 Go to next message
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 Go to previous messageGo to next message
Frank Naude
Messages: 4587
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
Re: ora-01122, ora-01110, ora-01207 [message #73318 is a reply to message #73301] Tue, 23 March 2004 03:47 Go to previous message
Frank Naude
Messages: 4587
Registered: April 1998
Senior Member
Hi

Yes, I needed to offline drop the temp datafiles and drop TEMP tablespace.

Needed to rebuild the database as I was not running the database in ARCHIVE log mode.

Thanks a lot for your reply.

-Nirai
Previous Topic: export some specifice recordss it gives me errorr (req. query.)
Next Topic: How to import oracle9i dmp file into oracle8i
Goto Forum:
  


Current Time: Tue Dec 24 19:41:23 CST 2024