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

From: sysdba <sysdba_at_inter.net.il>
Date: Sun, 24 Oct 1999 16:40:04 +0200
Message-ID: <7uv59u$kni$1@news2.inter.net.il>

try do the following :

enter server manager (svrmgr23 or svrmgr30)

"connect internal;"
"shutdown immediate"
"startup mount"
"recover database until cancel"

if it prompt for a log, then theres a problem. if not , it will tell u that media recovery complited.
and then:
"alter database open resetlogs".

If this method wont work, call oracle support and ask for the event of adjust SCN and try it. it will let u export your database and then re-create the database, and import it.

Good luck
--
Asaf Shoval
Oracle Israel Support Center

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 - 09:40:04 CDT