DX Infrastructure Management

Expand all | Collapse all

eHealth REDO1A.log missing

Jump to Best Answer
  • 1.  eHealth REDO1A.log missing

    Posted 11-16-2017 11:17 AM

    Hello !
    A user for disk space problems delete some redo files from C:\ehealthDB\oradata\EHEALTH\ArchiveLogs, but he also delete files from the parent directory "C:\ehealthDB\oradata\EHEALTH\", for example REDO1A.LOG. And now eHealth services dont start.. is posible rebuild this files ?

     

    Thu Nov 16 13:00:45 2017
    Errors in file c:\oracle\oracle.10.2\admin\bdump\ehealth\ehealth_lgwr_3816.trc:
    ORA-00313: open failed for members of log group 1 of thread 1
    ORA-00312: online log 1 thread 1: 'C:\EHEALTHDB\ORADATA\EHEALTH\REDO1B.LOG'
    ORA-27041: unable to open file
    OSD-04002: unable to open file
    O/S-Error: (OS 2) The system cannot find the file specified.
    ORA-00312: online log 1 thread 1: 'C:\EHEALTHDB\ORADATA\EHEALTH\REDO1A.LOG'
    ORA-27041: unable to open file
    OSD-04002: unable to open file
    O/S-Error: (OS 2) The system cannot find the file specified.

    Thu Nov 16 13:00:45 2017
    ARC0: Becoming the 'no FAL' ARCH
    ARC0: Becoming the 'no SRL' ARCH
    Thu Nov 16 13:00:45 2017
    ARC1: Becoming the heartbeat ARCH
    Thu Nov 16 13:00:45 2017
    ORA-313 signalled during: alter database open...

     

    Thanks in advance!!

    Diego Pereyra



  • 2.  Re: eHealth REDO1A.log missing

    Posted 11-16-2017 10:02 PM

    Is it only the REDO logs that were deleted or any other files too? If its on REDO logs then I guess they should be recreated after starting the Oracle and eHealth services .

     

    Normal procedure would be to stop eHealth server and Oracle, remove all of the redo log files under the ArchiveLogs directory, then start Oracle and the eHealth server again.

     

    Check below 

     

    General guide for troubleshooting issue of redo log files that fill up the ArchiveLogs directory 

     

    eHealth Space Related Issue Troubleshooting Guide 

     



  • 3.  Re: eHealth REDO1A.log missing
    Best Answer

    Posted 11-22-2017 09:07 AM

    I guess the same, but not were recreated after restart, the solution was restore a backup. (destroy db, restart os, create db, restore db)