Lost online redolog files
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 17

Thread: Lost online redolog files

  1. #1
    Join Date
    Aug 2007
    Posts
    54

    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-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"

  2. #2
    Join Date
    Apr 2003
    Location
    Gourock, Scotland
    Posts
    102
    Have you tried open resetlogs?
    If I have to choose between two evils, I always like to choose the one I haven't tried yet.

  3. #3
    Join Date
    Aug 2007
    Posts
    54

    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

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    recover database using backup controlfile until cancel;
    type CANCEL
    alter database open resetlogs;

  5. #5
    Join Date
    Aug 2007
    Posts
    54

    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

  6. #6
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    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"

  7. #7
    Join Date
    Aug 2007
    Posts
    54

    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,

  8. #8
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    do what i said from sqlplus

  9. #9
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    :-) There is a hard way. What Davey says is the smart way

  10. #10
    Join Date
    Aug 2007
    Posts
    54

    Lost online redolog files

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


    Regards,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width