Re: Is there a hero out there?

Hi

If your database is in NO-Archivelog mode, you will only succeed in recovering the datafile or tablespace to current time if the redo to be applied is within the range of your online redo logs. Do this query

select file#, change# from V$recover_file;

if change# > first_change# of your logs, then you can recover your datafile, else depending of what kind of file it is:

Temporary or Index - drop it: alter database datafile 'path/name' offline drop;
(do this before opening your database)
then do a alter database open. Drop the specific tablespace the datafile belongs to and recreate it again - however all existing data in the tablespace is lost.

If it is a system or rollback tablespace - restore entire database (most recent backup)

Hope this will help you - it will depend on your backup procedures.

Irene

ScSherwood <scsherwood_at_aol.com> wrote in article <19980308085001.DAA21368_at_ladder02.news.aol.com>...
> We're in a desperate situation...
>
> Our database won't start as it has oracle errors ORA-1113 and ORA-1110.
>
> We only have bronze support, but need Oracle to be running or our company
 is in
> BAD, BAD shape.
>
> Does anyone know how we can get a human to help us at Oracle?
>
> PLEASE----WE NEED HELP!!!
>
> ----Scott
>
> P.S. a DBA who can come latter this Sunday morning in So Florida would
 probably
> also be a hugely welcome sight.
>
>
  Received on Wed Mar 11 1998 - 00:00:00 CET