Redo log file

Hi,

I got this problem:

I deleted the redo log files of a database by accident i want to know how can i open the database!

The error message while opening teels me the file does not exist.

Thanks

PFMS

Mount the database, and open the database with resetlog option. The redo log files will be created.

sorry;

Can you tell me the command?

An example will be helpful

thanks,
pfms

from svrmgrl or sqplus as sysdba

startup mount
alter database open resetlogs

I´ve tried that and it didn´t worked.
I receive the message:
"RESETLOGS option only valid after an incomplete database recovery"

Now i can´t drop the group or file cause it is linked to a thread.
Can anybody tell me how i can solve this problem?

Note: I´can´t open the database and cause of that i can´t do an export too;

Thanks

PFMS

recover database until cancel;

do this and then
alter database open resetlogs;

now i got the following error after doing :

recover database until cancel

ORA-00279: change 513301 generated at 10/19/2001 19:50:43 needed for thread 1
ORA-00289: suggestion : E:\ORACLE\ORA81\RDBMS\ARC00172.001
ORA-00280: change 513301 for thread 1 is in sequence #172
Specify log: {=suggested | filename | AUTO | CANCEL}

i tried : auto

then it appears:

ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file1:
'E:\ORACLE\ORADATA\db\SYSTEM01.DBF'

Any suggestion?

Pfms

Try CANCEL while using recovery instead of AUTO. That might work.

I got the same problem like described here. Could anybody help on the last step written here? - I need the syntax for this step!
Thank you in advance,

chris

Run

Code:

---

recover database until cancel using backup controlfile;

---

in the mount status and then type the name of the current redolog. Then open the database with resetlogs:

Code:

---

alter database open resetlogs;

---

This should work.

mount ur database and take that particular logfile offline.
alter database logile 'file_name' offline;then
open the database alter database open;
Then recreate the delete logfile.

cheese
anandkl