Re: Urgent problem with datafile in need of recovery

Simon Goland wrote:
>
> 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.

  It is a normal situation. You can bring it online by using shutdown your database. Then, you can STARTUP RECOVER. Or STARTUP MOUNT and then RECOVER DATABASE.   

---
Name   : Lun Wing San (Certified Oracle Database Administrator)

Title  : Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841

This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer. Warranty expired when you
opened this article and I will not be responsible for its contents or use.