Lost online redolog files

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-00313:open failed for members of group 1 of thread 1"
"ORA-00312:online log 1 thread 1: '/u01/app/oracle/oradata/TEST/redo1.log'"
"ORA-27037:unable to obtain file status"

Have you tried open resetlogs?

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

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

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

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"

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,

do what i said from sqlplus

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

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


Regards,

may I also know the hard way please.


thanks,

why on earth - the way i showed you is THE correct way to do it

Hi, I opened the database by giving open resetlog command. But when I tried to backup the database using rman as I was doing earlier Iam getting the following error, the list backup command also shows the same error. Need help. Do I need to register the database again in recovery catalog.

thanks,



RMAN> backup database plus archivelog;


Starting backup at 18-AUG-07
current log archived
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 08/18/2007 13:16:10
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20003: target database incarnation not found in recovery catalog

RMAN> list backup
2> ;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of list command at 08/18/2007 13:16:35
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20003: target database incarnation not found in recovery catalog

you have to register that incarnation in the catalog

Hi, can you please let me know about how to register the incarnation in the catalog.

thanks,

heard of google? rman docs?

http://download.oracle.com/docs/cd/B...4/rcmrepos.htm

Hi, thanks a lot. By reading the documentation suggested by you the problem is solved.