Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Urgent problem with datafile in need of recovery
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