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"
Lost online redolog files
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
Lost online redolog files
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
Lost online redolog files
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,
Lost online redolog files
Thanks a lot, the database is recovered now by executing the commands from sql. Thanks to all the members.
Regards,
Lost online redolog files
may I also know the hard way please.
thanks,
Lost online redolog files
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
Lost online redolog files
Hi, can you please let me know about how to register the incarnation in the catalog.
thanks,
Lost online redolog files
Hi, thanks a lot. By reading the documentation suggested by you the problem is solved.