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 2017Errors 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 1ORA-00312: online log 1 thread 1: 'C:\EHEALTHDB\ORADATA\EHEALTH\REDO1B.LOG'ORA-27041: unable to open fileOSD-04002: unable to open fileO/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 fileOSD-04002: unable to open fileO/S-Error: (OS 2) The system cannot find the file specified.
Thu Nov 16 13:00:45 2017ARC0: Becoming the 'no FAL' ARCHARC0: Becoming the 'no SRL' ARCHThu Nov 16 13:00:45 2017ARC1: Becoming the heartbeat ARCHThu Nov 16 13:00:45 2017ORA-313 signalled during: alter database open...
Thanks in advance!!
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.
General guide for troubleshooting issue of redo log files that fill up the ArchiveLogs directory
eHealth Space Related Issue Troubleshooting Guide
I guess the same, but not were recreated after restart, the solution was restore a backup. (destroy db, restart os, create db, restore db)