Re: Please HELP !! Serious trouble with cold recovery.

Unfortunately, the db was running with a NOARCHIVELOG option. I will try to recover with server manager.

Thanks Sybrad.

Sybrand Bakker wrote:

> Question: are you running in archivelog? If not, you won't be able to
> perform media recovery anyway!
> In fact you have been running a hot backup (requires archivelog) while this
> fact was not being signalled to Oracle, so Oracle thinks the databasefile is
> older than the controlfile (which is BTW most likely is)
> The only choice you seem to have is take the currently restored files
> from server manager
> startup mount
> alter database open resetlogs
> and PRAY the database is still consistent.
>
> Hth,
>
> --
> Sybrand Bakker, Oracle DBA
> Thanasis Siozos <tm_hy_at_anko.gr> wrote in message
> news:38121916.6A29C724_at_anko.gr...
> > Please help me, my job depends on this and I am desperate :((
> >
> > I had a disk failure in the disk that the ORACLE datafiles are stored.
> > The only backup I have is a copy of the data files/control files etc.
> > from the \orant\database directory.
> >
> > After I changed the disk, I am trying to restore the database in the
> > same
> > path with the same names, SIDs etc. The database services start OK but
> > when I try to start the instance from Instance Manager I get the error:
> >
> > ORA-01113: file 3 needs media recovery.
> > ORA-01110: data file 3: 'D:\ORANT\DATABASES\USR1ANKO.ORA'
> >
> > Now, I am sure that the USR1ANKO.ORA file is the original, since I
> > unpacked it from a zip
> > file.
> >
> > When I was taking the backup, I was just copying the *.ORA files while
> > the database was still running (silly me). Perhaps this is the problem.
> >
> > Is there a way to restore the original database even to a minimum level
> > so I can
> > extract the data? I don't want to make the database work again. All I
> > want
> > is to extract the data somehow.
> >
> > Since I am really desperate here, please help me.
> >
> > If I send the files to ORACLE support do you think they can recover the
> > data?
> >
> > My setup:
> > Windows NT 4.0 (SP3), NTFS file system
> > ORACLE 8.0
> >
> > Thanasis
> > ANKO SA
> > Kozani, Greece
> >
> >
Received on Sun Oct 24 1999 - 05:58:34 CDT