Redo log file

[psoares]

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

[tamilselvan]

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

[psoares]

sorry;

Can you tell me the command?

An example will be helpful

thanks,
pfms

[Sureshy]

from svrmgrl or sqplus as sysdba

startup mount
alter database open resetlogs

[psoares]

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

[helpme]

recover database until cancel;

do this and then
alter database open resetlogs;

[psoares]

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

[kulkarnira]

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

[kiltz]

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

[julian]

Run

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:

alter database open resetlogs;

This should work.