Error generated when attempting to start the eHealth Oracle DB (via nhStartDb):
ORA-16038: log 2 sequence# 2698 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 2 thread 1: '/u01/oradata/EHEALTH/REDO2A.log'
ORA-00312: online log 2 thread 1: '/u01/oradata/EHEALTH/REDO2B.log'
eHealth 6.0 and later
1. Access database using sysdba with command of sqlplus sys/ehealth as sysdba, then run following sql commands one by one:
recover database until cancel;
alter database open resetlogs;
2. as $NH_USER, do nhStopDb immediate followed by nhStartDb, then followed by starting ehealth server.