Originally posted by Sameer
Code:
# Recovery is required if any of the datafiles are restored backups,
# or if the last shutdown was not normal or immediate.
RECOVER DATABASE USING BACKUP CONTROLFILE
# Database can now be opened zeroing the online logs.
ALTER DATABASE OPEN RESETLOGS;
# No tempfile entries found to add.
#
So where is my tempfile.. FILE IS NOT PHISICALLY PRESENT ON THE DISK.... I have renamed it.... as I have said it before.. so logically tempfile displayed by v$tempfile view doesn't PHYSICAL EXIST ON DISK AND ALSO NEW FILE IS NOT PHYSICALLY CREATED
Well, later I found following error in my dbwr trace file...

Code:
*** 2002-09-28 19:05:04.000
*** SESSION ID:(2.1) 2002-09-28 19:05:04.000
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: 'C:\ORACLE\ORADATA\ORCL\TEMP01.DBF'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) Das System kann die angegebene Datei nicht finden.
Somehow my system could not able to create file physically on disk.. and later when I did big sort operation I got ORA-25153.. I added a tempfile and everything worked well...

Thanks

Sameer

[Edited by Sameer on 09-29-2002 at 02:45 PM]