Oracle-L: RE: RECOVERY QUESTION

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Thu, 20 Jun 2002 09:33:29 -0800
Message-ID: <F001.00482FB8.20020620093329@fatcity.com>

Harvinder - If you select from DBA_DATA_FILES, you will probably see those tablespaces as having a MISSING location. Take them offline if you like. Not a big deal, I have run a lot that way on test databases. Of course, if anyone tries to access the tablespace they get an error. Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----

Sent: Thursday, June 20, 2002 11:49 AM
To: Multiple recipients of list ORACLE-L

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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.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