| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RECOVERY QUESTION
Seema,
there is no reference to these 3 tablespace and files in v$database or any other system table.... application is running fine......
Thanks
--Harvinder
-----Original Message-----
Sent: Thursday, June 20, 2002 2:00 PM
To: Multiple recipients of list ORACLE-L
Harvinder
I think u have to restore complete from cold backup and create controlfile
including 3 datafiles also and bring back to database and then u can drop
tablespaces.
OR
at current stage.did u status in check v_$datafile and v_$tablespace
dictionary table ?
Thx
-Seema
>From: "Harvinder Singh" <Harvinder.Singh_at_MetraTech.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RECOVERY QUESTION
>Date: Thu, 20 Jun 2002 08:48:32 -0800
>
>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: Seema Singh INET: oracledbam_at_hotmail.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: 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 - 13:17:12 CDT
 |
 |