Lost online redolog files

[habeebksa]

Hi, I have lost all my online redo log files. Iam having full RMAN backup of database. How to recover the database now. I tried with mounting the database and then got connected to rman. I issued the following commands

RMAN>restore database;
Restore was successful, this command restored all the datafiles.

RMAN>recover database;
But during recovery Iam getting error these errors
"ORA-00283:recovery session cancelled due to errors"
"ORA-00313pen failed for members of group 1 of thread 1"
"ORA-00312nline log 1 thread 1: '/u01/app/oracle/oradata/TEST/redo1.log'"
"ORA-27037:unable to obtain file status"

[KenCunningham]

Have you tried open resetlogs?

[habeebksa]

Yes, I have also tried with open resetlogs. Iam getting the following errors:

RMAN-03002: failure of alter db command at 08/15/2007 12:15:23
ORA-01139: RESETLOGS option only valid after an incomplete database recovery

[davey23uk]

recover database using backup controlfile until cancel;
type CANCEL
alter database open resetlogs;

[habeebksa]

Shall I type these commands from RMAN prompt or from SQL prompt. I want to recover from RMAN. Please clear this doubt.

I typed from RMAN, after restoring database. I get the following error:


RMAN> recover database using backup controlfile until cancel;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "identifier": expecting one of: "archivelog, check, delete, from, high, noredo, ;, skip, tablespace, until"
RMAN-01008: the bad identifier was: using
RMAN-01007: at line 1 column 18 file: standard input

[Bore]

From Sqlplus
RMAN Does not supports incomplete cancel based recovery
Maybe you can try with RMAN
recover database using backup controlfile;
sql "alter database open resetlogs"

[habeebksa]

Iam getting the following error, when i tried without giving until cancel option.
Can't we recover the database from RMAN whose online redologs are lost?

RMAN> recover database using backup controlfile;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "identifier": expecting one of: "archivelog, check, delete, from, high, noredo, ;, skip, tablespace, until"
RMAN-01008: the bad identifier was: using
RMAN-01007: at line 1 column 18 file: standard input


thanks,

[davey23uk]

do what i said from sqlplus

[Bore]

:-) There is a hard way. What Davey says is the smart way

[habeebksa]

Thanks a lot, the database is recovered now by executing the commands from sql. Thanks to all the members.


Regards,