Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Urgent problem with datafile in need of recovery

Urgent problem with datafile in need of recovery

From: Simon Goland <sg_at_mda.ca>
Date: 1997/03/30
Message-ID: <333F17A1.24@mda.ca>#1/1

OK, so I am doing some major reorg of the database, and part of it is to make it slightly more OFA-compliant. One tablespace, TOOLS, consists of 5 datafiles (for the record, I only inherited this database and am trying to make it more useable), tools01.dbf .. tools05.dbf . The database was running in NOARCHIVELOG mode, but I did a full cold backup to tape before doing anything.

Now, I did the following for all 5 files of the TOOLS tablespace:

alter tablespace tools offline;
alter tablespace tools rename datafile
  '<wherever it was>/tools1.dbf' to
  '/export/share/disk4/oracle/ldbc/tools01.dbf'; alter tablespace tools online;

And when I tried to bring it online, I got the following error message for the first 3 of the 5 files for this tablespace (files 04 and 05 are OK for some strange reason):

SVRMGR> alter tablespace tools online;
alter tablespace tools online
*
ORA-01113: file 3 needs media recovery
ORA-01110: data file 3: '/export/share/disk4/oracle/ldbc/tools01.dbf'

I ran DB_VERIFY on the file, before and after restoring it from the tape backup, and everything seems to be normal:

DBVERIFY: Release 7.3.2.1.0 - Production on Sun Mar 30 17:43:37 1997 Copyright (c) Oracle Corporation 1979, 1994. All rights reserved. DBVERIFY - Verification starting : FILE = /export/share/disk4/oracle/ldbc/tools01.dbf  

DBVERIFY - Verification complete  

Total Pages Examined         : 7680
Total Pages Processed (Data) : 5536
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 1828
Total Pages Failing   (Index): 0
Total Pages Empty            : 211
Total Pages Marked Corrupt   : 0
Total Pages Influx           : 0


And I keep getting the same error for these 3 files (tools01.dbf, tools02.dbf, tools03.dbf). And there is no other backup, other than the tape, and a nightly full DB export that I run as a cron job. The database is 7.3.2.1.0.

So what can I do now to get this tablespace back online? Any help will be greatly appreciated, and if you can email it in addition to posting, that would be even better.

Thanks,

-- 
[ Simon Goland       B-)>     sg_at_mda.ca ]
[   Without action there is no change   ]
Received on Sun Mar 30 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US