Recovery

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

If yes, how?

Thanks

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

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.

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

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

good luck

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

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

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.

resetlogs recreates redo logs though

Quote:

---

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.

Why i asked u about list of redologs?

Steps:
1. startup database mount;
2. recreate ALL redologs files (groups):

alter database add logfile group X ('...','...') size XXXM;
alter database add logfile group Y ('...','...') size XXXM;
...
or
alter database add logfile member '...' to group X;
alter database add logfile member '...' to group Y;

3. drop ALL old logfiles that u lost:

alter database drop logfile member '...';
alter database drop logfile member '...';
or
alter database drop logfile group X_OLD;
alter database drop logfile group Y_OLD;

4. altrer database open reset logs (as posted Juriy).

Best regards.

Shestakov,

Why steps 1., 2. and 3., when step 4. alone is totaly sufficient?

Because i had this problem a couple years ago, and
alter database open resetlog;
didn't recreate 'in scratch' log files.
I had to recrteate all logs manually.

well that must be a bug because oracle actually mentions in the doc you dont need to backup redologs in cold backups