RECOVERY QUESTION

From: Harvinder Singh <Harvinder.Singh_at_MetraTech.com>
Date: Thu, 20 Jun 2002 08:48:32 -0800
Message-ID: <F001.00482EC0.20020620084832@fatcity.com>

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: Harvinder.Singh_at_MetraTech.com

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: ListGuru_at_fatcity.com (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).

Received on Thu Jun 20 2002 - 11:48:32 CDT