Recovery

[Mickey]

IS recovery possible if I have control file and and data files.

If yes, how?

Thanks

[Shestakov]

In what mode was database before:
ARCHIVELOG or NOARCHIVELOG ?
and than
Do u have list of all redo log files, that u lost?

[Mickey]

Database was not in Archive mod.

My hard drive died but I was able to recover control file and data files.

Basicaly, nothing is lost.

Now I have new hard drive and I want to create the sane DB as on the old one.

[Shestakov]

What about redo log files - this is very important in this case.

[pando]

your database was open when disk crashed?
if so without redo logs say byebye to your database

good luck

[Mickey]

I do not have Redo Log Files but I think I don't need them because everything was saved in data files.

At the moment when my hard drive died, Oracle was not started, so there is no data lost

[pando]

if the database was not open then simplt mount the database and then open the database with resetlogs option (make sure the datafile/redologs PATHs are there

[jmodic]

In that case your database needs no recovery at all, so the subject line of this thread is misnomer .

Having all datafiles and controlfile is all you need in this case, no recovery will be needed, all you'll have to do is to recreate your redo log files before opening your database.

Provided of course that your database was shut down cleanly before the disk crash happened.

[pando]

resetlogs recreates redo logs though

[jmodic]

Originally posted by pando
resetlogs recreates redo logs though

That's one of the options that I had in mind when I said "you'll have to do is to recreate your redo log files before opening your database". Although the command is "ALTER DATABASE OPEN RESETLOGS", you are actually creating new (or overwriting existing ones) redo logs *before* you open the database.