Hi,
We have a cold backup of sunday evening and all the archive log since that....
we lost the hard disk containg files of 3 tablespaces...and moreover we don't need
this tablespaces anymore......
1) we restore the cold backup containg all the datafiles except this 3 tablespace
datafiles.......
2) startup nomount
3) create controlfile and remove reference to datafiles of this 3 tablespaces.......
4) recover database until cancel using backup controlfile.........
5) alter database open resetlogs......
6) drop this 3 tablespaces manuallu with command :
drop tablespace name including contents and datafiles;
7) Now everything looks normal but when we do backup controlfile to trace it has
following lines along with create controlfile syntax........
*** 2002-06-20 11:24:07.000
*** 2002-06-20 11:28:40.000
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01111: name for data file 12 is unknown - rename to correct file
ORA-01110: data file 12: 'E:\ORA\ORA92\DATABASE\MISSING00012'
ORA-01259: unable to delete datafile E:\ORA\ORA92\DATABASE\MISSING00012
ORA-01157: cannot identify/lock data file 13 - see DBWR trace file
ORA-01111: name for data file 13 is unknown - rename to correct file
ORA-01110: data file 13: 'E:\ORA\ORA92\DATABASE\MISSING00013'
ORA-01259: unable to delete datafile E:\ORA\ORA92\DATABASE\MISSING00013
ORA-01157: cannot identify/lock data file 14 - see DBWR trace file
ORA-01111: name for data file 14 is unknown - rename to correct file
ORA-01110: data file 14: 'E:\ORA\ORA92\DATABASE\MISSING00014'
ORA-01259: unable to delete datafile E:\ORA\ORA92\DATABASE\MISSING00014
*** 2002-06-20 11:30:16.000
DOES IT OKAY to start application or we do need to take some extra steps???????
Thanks
--Harvinder
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Harvinder Singh
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
