1. Make sure it's just got indexes in it (dba_extents/dba_segments)
2. exp system/pass full=y compress=n rows=n (this just exports structure
only) file=myfile.exp
2a. imp system/pass file=myfile.exp indexfile=recreateindexes.sql (this
doesn't import, only creates .sql file)
3. shutdown down database
4. startup mount
5. alter database datafile '/opt/oracle/oradata/cidesi/xdb01.dbf' offline
drop;
6. alter database open
7. alter tablespace cidesi (<-I assume) add datafile
'opt/oracle/oradata/cidesi/xdb01.dbf' size whatever;
8. @recreateindexes.sql

All done.

Tony.

----- Original Message -----
From: "Adriana Garcia Lemus "
<oracledba-ezmlmshield-x9518265.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Tuesday, August 03, 2004 5:39 PM
Subject: Accidentally overwrote an index file with a cold backup file!!!


> Hi,
> Need your help!!... as I was asked to do a copy of a tape, I
accidentally overwrote an index file as I was doing the restore to disk
(/opt/oracle/oradata/cidesi/xdb01.dbf) , and of course the database is up,
so far there has not been any complain, but I am afraid as soon as I do a
shutdown/startup something on the databse something might go wrong (a cold
back is done daily), I did an export on the main schemas before doing the
failed restore..... could someone advice on what to do before this gets
serious??... any suggestion is appreciated.
>
>
> Many Thanks in Advance,
> -Adriana.
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>
>


Oracle LazyDBA home page